Streamline Your Sourcing: Merge Taobao, Weidian, and 1688 Orders for Easy Cost & Weight Tracking
Sourcing products from multiple Chinese platforms like Taobao, Weidian, and 1688
Why Consolidate Your Orders?
- Centralized Overview:
- Accurate Cost Calculation:
- Weight Management:
- Error Reduction:
- Time Efficiency:
- Accurate Cost Calculation:
How to Use the CNFANS Spreadsheet: A Step-by-Step Guide
Step 1: Access & Copy the Template
Download or make a copy of the official CNFANS consolidation spreadsheet. This is your master workbook.
Step 2: Input Store & Order Information
Create separate sections or columns to identify each source:
- Platform:
- Store Name:
- Order/Link:
- Item Details:
- Store Name:
Step 3: Record Financials & Quantities
For each item, meticulously enter:
- Unit Price (¥):
- Quantity:
- Item Total (¥):Unit Price × Quantity.
- Domestic Shipping (¥):
- CNFANS Service Fee (¥):
- Line Total:
- Quantity:
Step 4: Input Estimated Weight
For each unique item, enter the Estimated Weight per item (kg)
Step 5: Utilize Formulas for Automatic Totals
The power of the spreadsheet lies in automation. Key formulas include:
- Grand Total Cost:=SUM(range)
- Total Estimated Weight:=SUM
- Cost per Kilogram:=Grand Total Cost / Total Estimated Weight
- Total Estimated Weight:=SUM
Step 6: Submit to CNFANS
Once all orders are pasted and data is complete, use this consolidated sheet to fill out CNFANS' order submission form quickly and accurately. Simply copy and paste information row by row, or share the sheet with their customer service for assistance.
Pro Tips for Effective Consolidation
- Color-Coding:
- Freeze Header Row:
- Regular Updates:
- Notes Column:
- Verify Warehouse:
- Freeze Header Row: