Managing purchases from multiple sellers across different platforms can quickly become a logistical challenge. The MyCNBox Spreadsheet
When you buy from Taobao, 1688, or other Chinese platforms, your items originate from various sellers, arrive at the warehouse at different times, and have unique QC and shipping details. Tracking this manually is prone to error. The MyCNBox Spreadsheet solves this by allowing you to: A well-organized spreadsheet is key. We recommend creating the following columns to capture every critical data point: As you make purchases, immediately log each item in the spreadsheet. Once the item arrives at the MyCNBox warehouse and QC photos are uploaded, update its row with the photo link and mark its QC Status. Filter the "QC Status" column to quickly see all "Pending" items. Use the weight and dimension datashipping cost quotes
Once you approve a consolidated parcel and pay for shipping, update the rows for all included items with the shared MyCNBox Parcel Number
After delivery, use the complete cost data to determine your final landed cost per item. This historical data is invaluable for budgeting future purchases. By transforming scattered information into structured data, the MyCNBox Spreadsheet
The Core Challenge & The Solution
How to Structure Your Master Spreadsheet
Spreadsheet Column
Data to Input
Purpose & Benefit
Seller/Source
Seller name, platform, store link
Identifies the purchase origin for easy communication and tracking.
Item Details & QC Status
Product link, SKU, color/size, QC photos, approval status (Pending/Pass/Fail)
Centralizes Quality Control.
Weight & Dimensions
Individual item weight, packaged weight (from warehouse photos), parcel dimensions
Provides the raw data to calculate accurate shipping costs
Cost & Logistics
Item cost, domestic shipping, MyCNBox service fee, international shipping quote
Tracks all expenditures in one place for precise total cost per item
Shipment & Tracking
MyCNBox parcel number, international tracking number, carrier, status (e.g., Warehoused, Consolidated, Shipped)
Offers end-to-end visibility
Your End-to-End Management Workflow
1. Initial Entry & QC Phase
2. Consolidation & Weight Analysis
3. Shipping Execution & Tracking
4. Final Cost Calculation
Pro Tips for Maximum Efficiency
Streamlining Your Multi-Seller Purchases: A Guide to the MyCNBox Master Spreadsheet
2026-03-25