CNFANS: Streamline Your Sourcing with Unified Order Management
For those sourcing products from China, managing orders across multiple platforms like Taobao, Weidian, and 1688CNFANS Consolidation Spreadsheet
Shoppers typically face three core challenges: This specially designed spreadsheet acts as a central command center for all your sourcing orders. A single dashboard to monitor everything from item links to final freight costs. Search for the free "CNFANS Order Consolidation Spreadsheet" template within the CNFANS community resources or create your own using a basic spreadsheet program. The key is consistency in data entry. Start consolidating your next multi-store haul and experience the clarity and control it brings to your sourcing journey. By centralizing data from Taobao, Weidian, and 1688, the CNFANS spreadsheet method transforms order management from a stressful task into a streamlined, efficient process. Take charge of your total costs and freight today.The Multi-Store Problem
The Solution: CNFANS Master Spreadsheet
How to Consolidate Your Orders in 4 Steps
For each item purchased on Taobao, Weidian, or 1688, collect the essential details: Store name, Item URL, Quantity, Price (¥), Paid Domestic Shipping (¥), and the item's Weight (kg).
Open the CNFANS spreadsheet. Create a new row for each unique item and fill in the corresponding columns. Use separate tabs or sections if you are ordering for multiple clients or projects.
The spreadsheet's formulas will automatically:
As you add more orders or receive actual weights from your agent, simply update the spreadsheet. Your totals and projections will update instantly, giving you a real-time view of your budget.Key Benefits of This Method
Benefit
Description
Complete Cost Visibility
See your total investment—from product cost to final shipping—at a glance, preventing budget overruns.
Accurate Freight Planning
Provide agents with exact total weights for precise shipping quotes, avoiding surprise charges.
Time Efficiency
Eliminate switching between tabs and manual calculators. All critical data is consolidated.
Simple Sharing
Easily share the single sheet with business partners or agents for transparency and discussion.
Pro Tips for Effective Use
Getting Started