CNFANS: How to Consolidate Multi-Store Orders Using the CNFANS Spreadsheet
As an experienced Taobao, Weidian, and 1688 shopper, you know the frustration of tracking multiple orders across different platforms. The CNFANS Spreadsheet Method provides a powerful solution to merge all your purchases into one organized system, giving you complete control over your shipping costs and package weights.
Why Use the CNFANS Spreadsheet Method?
- Centralized Tracking:
- Cost Monitoring:
- Weight Management:
- Time Efficiency:
- Cost Monitoring:
Setting Up Your CNFANS Spreadsheet
Step 1: Create Your Main Columns
| Column Header | Description | Example |
|---|---|---|
| Store Platform | Indicate Taobao, Weidian, or 1688 | Taobao |
| Store Name | Seller/shop name | Fashion Trends Store |
| Item Description | Product name and specifications | Men's Winter Jacket Size L |
| Price (RMB) | Item cost in Chinese Yuan | 288.00 |
| Quantity | Number of units purchased | 2 |
| Item Weight (kg) | Weight per item if known | 0.8 |
| Domestic Shipping | China domestic freight cost | 10.00 |
Step 2: Add Consolidation Formulas
Total Cost Formula: =SUM([Price Column]*[Quantity])+[Domestic Shipping]
Total Weight Formula: =SUM([Weight Column]*[Quantity])
Platform Summary: Use FILTER or Pivot Tables to organize by platform
Step 3: Implement Data Validation
Create dropdown menus for Store Platform to maintain consistency:
- Taobao
- Weidian
- 1688
- Other
Pro Tips for Maximum Efficiency
Regular Updates
Update your spreadsheet immediately after making purchases to avoid forgetting details. Set aside 10 minutes daily to maintain your records.
Color Coding
Use different colors for each platform: Blue for Taobao, Green for Weidian, Orange for 1688. This provides quick visual reference.
Include Shipping Deadlines
Add a column for "Domestic Shipping Deadline" to track when items need to reach your consolidation warehouse.
Screenshot Backups
Take screenshots of product pages and store them in a linked folder for easy reference if issues arise.
CNFANS Platform Integration
Once your spreadsheet is complete, use CNFANS' batch submission feature to submit all your orders simultaneously. The platform recognizes consolidated spreadsheets and streamlines the international shipping process.
CNFANS Submission Checklist:
- Verify all item prices and weights
- Confirm store/platform categorization
- Double-check domestic shipping costs
- Export your spreadsheet as CSV format
- Upload to CNFANS order system
Common Issues and Solutions
Missing Weights
Problem: Solution:
Multiple Domestic Shipping Fees
Problem: Solution:
Currency Fluctuations
Problem: Solution:
Start Consolidating Today
The CNFANS Spreadsheet Method transforms chaotic multi-platform shopping into an organized, efficient process. By implementing this system, you'll gain complete visibility over your purchases, avoid surprise costs, and streamline your international shipping experience. Start your consolidated spreadsheet today and experience the difference in your next shopping haul!
Free Template Available
Download our pre-formatted CNFANS spreadsheet template from the CNFANS resources page to get started immediately.