CNFANS Guide: How to Consolidate Multi-Store Orders Using the CNFANS Spreadsheet
Merge Taobao, Weidian, and 1688 Orders in One Sheet to Monitor Total Costs and Freight Weight Easily.
Shopping across multiple Chinese platforms like Taobao, Weidian, and 1688CNFANS Consolidation Spreadsheet
Why Use the CNFANS Order Consolidation Sheet?
- Centralized Tracking:
- Cost Calculation:
- Weight Management:
- Error Reduction:
- Easy Submission:
- Cost Calculation:
Step-by-Step Guide to Merging Your Orders
Step 1: Download the Template
Get the official CNFANS consolidation spreadsheet from your member center or request it from your agent. Ensure you have the latest version.
Step 2: Input Core Order Information
For each item purchased, create a new row in the sheet and fill in the following essential columns:
| Column | What to Enter | Example |
|---|---|---|
| Platform/Store Name | The source (e.g., Taobao Official Store, Weidian Shop XYZ). | 1688 Factory Direct |
| Product Link/Item No. | The full URL or item ID for quick reference. | https://detail.1688.com/item... |
| Product Description | Specify color, size, version, and any custom notes. | Black, Size L, with Logo |
| Quantity & Unit Price (RMB) | Number of units and the price per unit. | 2 x 50.00 RMB | Estimated Weight (kg) | The per-item weight from the product page or your estimate. | 0.75 |
Step 3: Record Domestic Shipping & Notes
Don't forget the intra-China shipping fees charged by each seller. Use the "Domestic Freight""Remarks"
Step 4: Utilize Formulas for Totals
Leverage built-in formulas. A SubtotalTotal with Domestic ShippingSUM
// Example of a simple subtotal formula in Google Sheets or Excel
=Quantity * Unit_Price
Step 5: Final Review and Submission
Double-check all links, quantities, and weights for accuracy. Once verified, save the file and upload it to your CNFANS member dashboard or send it directly to your assigned agent. They will now have a perfect blueprint to purchase, receive, and consolidate your parcels.
Pro Tips for Maximum Efficiency
- Screenshot Everything:
- Color-Code Rows:
- Update in Real-Time:
- Communicate with Your Agent:
- Color-Code Rows: