Step 1: Download the Template
Get the official CNFANS Multi-Store Order Template
CNFANS: How to Consolidate Multi-Store Orders in One Spreadsheet
2025-12-15
Merge Taobao, Weidian, and 1688 Orders to Monitor Total Costs & Freight Weight Easily
For international shoppers and agents, managing multiple orders from different Chinese platforms like Taobao, Weidian, and 1688CNFANS
Why Consolidate Your Orders?
- Centralized Overview:
- Cost Control:
- Weight Management:
- Time Efficiency:
- Error Reduction:
- Cost Control:
How to Use the CNFANS Consolidation Spreadsheet
Step 2: Set Up Your Master Sheet
Create the following columns in your sheet. This structure is key:
| Column Header | Description |
|---|---|
| Store Platform | Dropdown list for Taobao, Weidian, 1688, etc. |
| Store Name/Link | Link to the store for easy reference. |
| Item Name & Link | Product description and exact URL. |
| Item Price (¥) | Unit price of the item. |
| Quantity | Number of units purchased. |
| Item Weight (g) | Per unit weight from the product page. |
| Domestic Shipping (¥) | Shipping fee from seller to agent warehouse. |
| Subtotal (¥) | Formula: (Item Price * Quantity) + Domestic Shipping |
| Notes/Status | e.g., "Ordered", "Arrived at Warehouse", "Waiting for Exchange". |
Step 3: Input Data for Each Order
For every item you buy, add a new row. Copy-paste links directly
Step 4: Use Summary Formulas for Totals
At the top or bottom of your sheet, create a summary section with these formulas:
- Total Product Cost:=SUM( range of 'Subtotal' column )
- Total Estimated Weight:=SUM( range of 'Item Weight' column ) / 1000
- Item Count:=COUNTA( range of 'Item Name' column )
These figures will auto-update as you add rows, giving you a real-time financial overview.
Step 5: Share with Your Agent (Optional but Recommended)
Once your list is finalized, you can share the view-only sheet link with your CNFANS agent. This provides them with perfect clarity for purchasing, storage, and pre-packaging checks, streamlining the entire process.
Pro Tips for Effective Use
Color Coding
Use cell colors for status: e.g., YellowGreen
Freeze Header Row
Always freeze the top row so your column headers are visible as you scroll down a long list.
Regular Updates
Update the sheet as soon as you order or receive status updates from sellers to keep data accurate.
Check Store Reviews
Note seller reputation from the platform in your "Notes" column to track potentially problematic orders.