Managing orders from multiple Chinese platforms like Taobao, Weidian, and 1688 can be chaotic. This guide shows you how to merge all your orders into one powerful CNFANS spreadsheet for effortless cost and weight tracking.
The Problem: Disorganized Multi-Platform Shopping
Shopping across TaobaoWeidian1688
The Solution: The CNFANS Unified Order Spreadsheet
Our customizable spreadsheet template is designed to bring clarity and control to your cross-platform hauls.
Core Features
| Feature | Benefit |
|---|---|
| Unified Format | A single table for orders from all platforms (Taobao/Weidian/1688/Pinduoduo). |
| Automatic Calculations | Auto-summing of item costs, domestic shipping, and total purchase cost. |
| Weight & Freight Tracker | Log estimated and actual weight to calculate and forecast shipping fees accurately. |
| Status Dashboard | Visual overview of what's purchased, arrived at the warehouse, and shipped. |
How to Use the CNFANS Spreadsheet: A Step-by-Step Guide
Step 1: Download and Duplicate the Template
Access the CNFANS Google Sheets or Excel template. Create a personal copy for your haul.
Step 2: Input Your Order Data
For every item
Step 3: Update Upon Warehouse Arrival
Once your agent (like CNFANS) receives the item:
- Mark its status as
"Arrived". - Input the Actual Weight (kg)
- Attach a screenshot of the product in your warehouse gallery for visual reference.
Step 4: Consolidate and Calculate Totals
This is where the magic happens. The spreadsheet will automatically:
- Calculate your Total Product Cost.
- Sum all Domestic Shipping Fees.
- Provide a Total Purchase Cost
- Sum the Consolidated Weight
You now have one clear number for total cost and weight to plan your international shipment.
Pro Tips for Effective Tracking
Color Coding
Use cell colors to indicate status: e.g., Yellow for Ordered, Green for Arrived, Blue for Shipped Internationally.
Note Special Requests
Add a column for "Agent Instructions" like "Remove packaging" or "Check for defects."
Share with Your Freight Forwarder
Export the sheet or share a view-only link with your agent (like CNFANS) to ensure they have perfect clarity on your parcel contents.