Merge Taobao, Weidian, and 1688 Orders for Effortless Cost & Weight Tracking
Sourcing from multiple Chinese platforms like Taobao, Weidian, and 1688
Why Use the CNFANS Spreadsheet?
- Centralized Dashboard:
- Real-Time Cost Aggregation:
- Weight Management:
- Order Status Tracking:
- Simplified Agent Handoff:
- Real-Time Cost Aggregation:
How to Set Up Your Master Sheet
Step 1: Create Your Core Columns
Design your spreadsheet with these essential columns:
| Column Header | Purpose |
|---|---|
| Store Platform | Tag as Taobao, Weidian, or 1688. |
| Store Name / Link | Record the shop name and URL. |
| Item Name & Description | Detail the product, including SKU/color/size. |
| Quantity | Number of units purchased. |
| Unit Price (¥) | Price per single item. |
| Item Weight (g) | Estimated or actual weight per item. |
| Domestic Shipping (¥) | Shipping fee from seller to the agent's warehouse. |
| Subtotal (¥) | Calculate: (Quantity * Unit Price) + Domestic Shipping. |
| Status | Track: Order Placed, Shipped, Warehouse Received, etc. |
Step 2: Log Orders as You Shop
Whenever you make a purchase on any platform, immediately add a new row. Fill in all available data, especially the product price, domestic shipping fee, and estimated weight
Step 3: Use Formulas for Automatic Totals
Create summary cells that auto-calculate using spreadsheet formulas:
Total Product Cost: =SUM(Subtotal_Column)
Total Estimated Weight: =SUM(Item_Weight_Column) [in kg or grams]
Avg. Cost Per Item: =AVERAGE(Unit_Price_Column)Step 4: Update Upon Warehouse Reception
Once your agent receives an item and provides the actual weight
Step 5: Share with Your Agent for Consolidation
When all items arrive, simply share the filtered or finalized sheet with your CNFANS agent. They can quickly identify all your items, their weights, and locations for merging into one international parcel.
Pro Tips for Maximum Efficiency
Use Color Coding
Color rows by platform (e.g., Taobao-blue, Weidian-green) for instant visual reference.
Add a "Notes" Column
Record special instructions, packaging requests, or links to product conversations.
Freeze Header Rows
Keep your column headers visible as you scroll down your growing list.
Leverage Dropdowns
Use data validation for the Status and Platform columns to ensure consistency.