Gain complete control over your parcels by combining data from multiple sources into one powerful tracking tool.
The Challenge of Multiple Sellers
Shopping from platforms like Taobao, 1688, or TmallMyCNBox Spreadsheet
Why Use the MyCNBox Spreadsheet?
Unified Visibility
Transform fragmented data from various sellers and shipments
Proactive Quality Control
Track the QC status
Accurate Cost Forecasting
Record actual weightvolumetric weight
How to Set Up Your Master Spreadsheet
Follow this step-by-step structure to build your command center:
| Column Header | Purpose & Data Source |
|---|---|
| Order # / Item ID | A unique identifier for each purchased item. Source: Your order confirmation from the seller. |
| Seller Name & Store Link | Note the seller and a direct link to the product page for easy reference and future reordering. |
| Domestic Tracking # | China logistics number (e.g., YTO, STO, ZTO). Update once seller ships to your MyCNBox warehouse. |
| QC Status & Photo Link | Mark as [Pending], [Approved], or [Rejected]. Paste the URL from MyCNBox where your QC photos are hosted. |
| Actual Weight (kg) | The physical weight measured by MyCNBox warehouse staff. Enter this data upon receipt. |
| Warehouse Storage Code | The specific bin or location code assigned by MyCNBox to your item in their facility. |
| Consolidation Batch | Group items to be shipped together internationally (e.g., "Batch-01-March"). |
| International Shipping Cost | Final calculated or quoted cost for sending the batch via your chosen carrier (e.g., DHL, EMS, Sea Freight). |
Optimized Management Workflow
- Data Entry:
- Update with Tracking:
- QC & Weight Update:
- Consolidate & Ship:
- Archive & Analyze:
- Update with Tracking: