Streamline Your Sourcing by Merging Taobao, Weidian, and 1688 Orders for Easy Cost & Weight Tracking
For cross-border shoppers and resellers, managing separate orders from platforms like Taobao, Weidian, and 1688.com
Why Consolidate Your Orders?
- Centralized Overview:
- Accurate Cost Calculation:
- Weight Aggregation:
- Prevent Errors:
- Efficient Submission:
- Accurate Cost Calculation:
Step-by-Step Consolidation Guide
Step 1: Prepare Your Source Data
As you shop, record every order's details. For each item, note:
| Data Point | Example | Platform |
|---|---|---|
| Item Store Link | (URL of the product) | Taobao/Weidian/1688 |
| Item Name/Description | Men's Canvas Jacket, Black, Size L | All |
| Quantity | 2 | All |
| Unit Price (¥) | 150.00 | All |
| Item Weight (g)* | 500 | All |
| Domestic Shipping (¥) | 0.00 or 10.00 | All |
| Seller/Store Name | Fashion Direct Store | All |
| Order Notes (Size, Color) | Color: Black | All |
*Estimated or provided by seller. Essential for freight calculation.
Step 2: Download & Open the CNFANS Template
Access the official CNFANS Consolidation Spreadsheet Template
Step 3: Input and Merge All Order Data
Create a new row for every unique item
Step 4: Utilize Formulas for Automatic Totals
The CNFANS template includes pre-set formulas. Key sections to check:
Total Item Cost:(Quantity × Unit Price) + Domestic Shipping. This calculates the cost for each line item.Grand Total Cost:SUMTotal Estimated Weight:SUM
Ensure formulas auto-update as you add more rows.
Step 5: Submit to Your Agent
Once all orders are placed and data is entered:
- Double-check the Grand Total CostTotal Estimated Weight.
- Share the spreadsheet with your CNFANS agent via their designated upload system or email.
- Provide funding for the total product cost. Your agent will now handle purchasing, warehousing, and consolidating the physical items from all the different stores into one parcel for international shipment.
Pro Tips for Effective Management
- Color-Coding:
- Hyperlink Items:
- Regular Updates:
- Tab System:
- Hyperlink Items:
Conclusion
By leveraging the CNFANS consolidation spreadsheet, you transform multi-platform sourcing from a chaotic task into a streamlined, data-driven process. Having a single source of truth for Taobao, Weidian, and 1688