CNFANS: Streamline Your Sourcing – How to Consolidate Multi-Store Orders
Merge Taobao, Weidian, and 1688 Orders into One Master Sheet for Effortless Cost and Weight Tracking.
Sourcing products from multiple Chinese platforms like Taobao, Weidian, and 1688
Why Consolidate Your Orders?
- Clarity & Control:
- Error Reduction:
- Efficient Agent Communication:
- Better Budgeting:
- Error Reduction:
How to Merge Orders Using the CNFANS Spreadsheet
Step 1: Download the Master Template
Access the CNFANS order consolidation spreadsheet. It typically contains these key columns:
| Column | Purpose |
|---|---|
| Product Link/ID | Paste the item URL from Taobao/Weidian/1688. |
| Store Name | Track which vendor the item is from. |
| Item Description | Specify color, size, version, etc. |
| Quantity | Number of units. |
| Unit Price (RMB) | Price per item. |
| Total Price (RMB) | Calculated as (Quantity x Unit Price). |
| Estimated Weight (kg) | From product page or agent's estimate. |
| Remarks | Notes for your agent (e.g., "check for flaws"). |
Step 2: Gather Data from Each Platform
Open your carts or pending orders from each site side-by-side with the spreadsheet.
- Taobao/Tmall:
- Weidian:
- 1688:
- Weidian:
Step 3: Input & Standardize Data
Fill one row per item in your master sheet. Consistency is key.
For weight, if unknown, use a reasonable estimate or leave it for your agent to fill later. The sheet will auto-sum the Grand Total CostTotal Estimated Weight.
Step 4: Monitor Totals and Adjust
Watch the running totals at the bottom of your sheet. This real-time overview allows you to:
- Stay within your budget by removing or replacing items.
- Assess if freight costs (based on total weight) are still economical.
- Ensure you've met MOQs for 1688 orders.
Step 5: Share with Your Agent
Once finalized, simply share the spreadsheet with your CNFANS agent. This eliminates back-and-forth questions and ensures they purchase the exact correct items from the right stores.
Pro Tips for Effective Consolidation
Color-Code by Platform
Use cell shading to visually differentiate Taobao (blue), Weidian (green), and 1688 (orange) orders.
Include Screenshots
Add a column for screenshot links (e.g., Google Drive) for complex items to avoid errors.
Update Religiously
When you add/remove items from your cart, update the sheet immediately to keep totals accurate.
Use Version Control
Save versions as "CNFANS_Order_Date_V1" before making major changes.