A systematic approach to organizing larger hauls, tracking timelines, QC, and shipping for maximum efficiency and peace of mind.
Planning a larger purchase from EastMallBuy—spanning multiple suppliers, weeks, and product categories—can quickly become chaotic. The solution? A structured spreadsheet. This guide walks you through using a custom spreadsheet to transform a complex haul into a manageable, streamlined process.
Why a Centralized Spreadsheet is Essential
Without a system, you risk overspending, missing QC issues, and losing track of parcels. A dedicated spreadsheet provides:
- Holistic Visibility:
- Proactive Timeline Management:
- Quality Control Centralization:
- Financial & Logistical Control:
- Proactive Timeline Management:
Setting Up Your EastMallBuy Master Spreadsheet
Create a new spreadsheet with the following core columns. This structure is your project's command center.
| Column/Section | Purpose & Data to Record |
|---|---|
| Item & Details | Product name, link/SKU, size/color, price (¥), and purchase quantity. |
| Seller & Order Timeline | Seller name, order date, and expected PSP date |
| QC & Approval | Link to QC photos, your GL/RL (Green Light/Red Light) decision, and actual approval date. |
| Shipping & Consolidation | Domestic tracking, warehouse arrival date, parcel weight, and expected submission date |
| Consolidated Parcel Info | Final parcel ID, international tracking number, carrier, and estimated delivery window. | Status & Notes | A dropdown for "Not Ordered," "Ordered," "Awaiting QC," "Approved," "Warehoused," "Shipped," "Delivered." Plus a free-text notes column for issues or reminders. |
The Multi-Week Workflow: A Phase-by-Phase Approach
Phase 1: Planning & Initial Ordering (Week 1)
Input all intended items into the spreadsheet. Place orders for your first batch of sellers, focusing on those with longer production times. Record the Order DateExpected PSP Date.
Phase 2: Staggered QC & Approval (Weeks 2-3)
As QC photos arrive, link them in the sheet, make your decision (GL/RL), and update the status. This staggered approval prevents last-minute rushes. Items from the first week's orders will typically enter this phase while you place orders for a second batch.
Phase 3: Warehouse Consolidation & Final Submission
As approved items arrive at the warehouse, update their "Warehouse Arrival Date" and recorded weight. Use the spreadsheet to plan your final consolidation—grouping items logically by weight, value, or category. Set your Expected Submission Date
Pro-Tips for Efficiency
- Use conditional formatting
- Freeze the top row and first few columns for easy scrolling.
- Add a summary cell
- Share the sheet with your agent if you're using one, for seamless coordination.