A systematic approach for buyers managing dozens of links to track payment, QC, and delivery effectively.
The Chaos of Large Hauls & The Spreadsheet Solution
Managing a large "haul" from overseas platforms like Taobao, Weidian, or 1688OrientDig Spreadsheet Method
Building Your OrientDig Tracking Spreadsheet
A simple, well-structured spreadsheet is your most powerful tool. We recommend creating the following core columns:
| Section | Core Columns | Purpose |
|---|---|---|
| Product & Link | Item Name, Store Name, Direct Link, Size/Color | Quickly identify the item and return to the source. |
| Financials | Price (¥), Domestic Shipping (¥), Total Cost (¥), Payment Status (Paid/Unpaid) | Track expenses and manage your budget precisely. |
| Warehouse & QC | Agent's Parcel Number, QC Status
| Monitor warehouse receipt and make informed GL/RL decisions. |
|
| Logistics | International Shipping Line, Tracking Number, Delivery Status | Follow the final journey to your doorstep. |
The Three-Phase Workflow in Practice
Phase 1: Payment & Procurement
As you browse, immediately add the item link and details to your spreadsheet. Once you submit the order through your agent, update the Payment Status"Paid."
Phase 2: Quality Control (QC) & Consolidation
When items arrive at your agent's warehouse, update the QC StatusGreen Light (GL)Red Light (RL)
Phase 3: Final Shipping & Delivery
After submitting your international parcel, input the chosen shipping line and tracking number. The Delivery Status"Shipped," "In Transit," "Arrived," "Delivered") provides a clear, real-time view of your haul's final leg.
Pro Tips for Spreadsheet Mastery
- Use Color Coding:
- Hyperlink Everything:
- Leverage Filters & Sorts:
- Create a Summary Dashboard:
- Hyperlink Everything: