Combine, Organize, and Track All Your Purchases in One Master Document
Ordering from multiple Taobao, Weidian, or 1688 sellers can quickly turn exciting shopping into a logistical headache. Managing disparate order confirmations, QC (Quality Check) photos, and shipping updates is challenging. The USFANS Multi-Seller Order Spreadsheet
Why Use the USFANS Consolidation Spreadsheet?
- Centralized Control:
- QC Efficiency:
- Transparent Tracking:
- Financial Overview:
- Enhanced Communication:
- QC Efficiency:
How to Set Up Your Master Spreadsheet
Step 1: Create Your Document Framework
Open a new spreadsheet (Google Sheets or Excel are ideal for sharing and real-time updates). Create the following column headers:
| Column Header | Purpose |
|---|---|
Seller/Store Name | Identify the source of each item. |
Product Link/ID | Direct URL or item ID for reference. |
Product Details (Size/Color/Notes) | Exact specifications of your purchase. |
Price (¥) | Item cost in Chinese Yuan. |
Domestic Shipping (¥) | Shipping cost from seller to agent's warehouse. |
QC Photos | Hyperlink to your agent's QC image folder or embedded notes. |
Warehouse Received? | Status: "Ordered," "Received," "QC Done." |
| International shipping cost, weight, and tracking number. |
Step 2: Consolidate All Orders
As you place orders with different sellers, immediately
Step 3: Integrate QC Photos & Updates
Once your agent receives an item, they will provide QC photos. Paste the link to the album in the QC PhotosWarehouse Received?"GL" (Green Light)"RL" (Red Light)
Step 4: Final Consolidation & International Shipping
After approving all QC, instruct your agent to consolidate all items into one international parcel. Update the final section of your spreadsheet with the consolidated parcel's tracking number, total weight, and final shipping cost. This becomes your single source of truth for the final delivery.
Pro Tips for Power Users
- Use data validation
- Employ conditional formatting
- Utilize the SUM function
- Share the view-only link
- Employ conditional formatting