CNFANS: How to Consolidate Multi-Store Orders Using the CNFANS Spreadsheet
Shopping across multiple Chinese platforms like Taobao, Weidian, and 1688 can be challenging when trying to track all your orders and calculate total costs. The CNFANS spreadsheet system provides a streamlined solution to merge and manage all your purchases in one place.
Why Consolidate Your Orders?
- Centralized order monitoring from multiple platforms
- Accurate total cost calculations
- Easy freight weight estimation
- Simplified international shipping preparation
- Reduced risk of missing items
Step-by-Step Consolidation Process
Step 1: Download the CNFANS Spreadsheet Template
Begin by downloading the official CNFANS consolidation spreadsheet from your account dashboard. This template is specifically designed to accommodate data from all major Chinese shopping platforms.
Step 2: Gather Order Information
Collect order details from each platform:
- Taobao:
- Weidian:
- 1688:
- Weidian:
Step 3: Input Data into Designated Columns
The CNFANS spreadsheet includes specific columns for:
- Product name and description
- Original price (RMB)
- Platform source (Taobao/Weidian/1688)
- Seller information
- Product weight and dimensions
- Domestic shipping costs
- Purchase quantity
Step 4: Calculate Total Costs and Weight
The spreadsheet automatically calculates:
- Combined product costs
- Total domestic shipping fees
- Aggregated weight for international shipping quotes
- Currency conversions if needed
Step 5: Review and Submit
Double-check all entries for accuracy before submitting the spreadsheet to your CNFANS agent for consolidation and international shipping.
Benefits of Using the CNFANS Spreadsheet System
Time Efficiency
Reduce hours of manual tracking to minutes of data entry
Cost Accuracy
Eliminate surprise costs with precise total calculations
Shipping Optimization
Accurate weight data helps choose the most economical shipping method
Order Visibility
Maintain clear oversight of all purchases regardless of source platform
Pro Tips for Effective Consolidation
- Update the spreadsheet immediately after each purchase
- Include direct product links for easy verification
- Note any special packaging requirements
- Flag fragile items in the comments section
- Take screenshots of product pages as backup reference
The CNFANS spreadsheet system transforms multi-platform shopping from a logistical challenge into a streamlined process. By consolidating Taobao, Weidian, and 1688 orders in one centralized document, you gain complete visibility of your purchases and costs while simplifying the international shipping process.