Step 1: Download and Duplicate the Template
Access the MyCNBox Spreadsheet (typically a Google Sheets or Excel file). Create a personal copy to be your master order file for each purchasing cycle.
MyCNBox: How to Use the MyCNBox Spreadsheet to Manage Your Orders Effectively
2026-03-19
Streamline your purchasing process with a powerful organizational tool.
Managing multiple purchases from different sellers can quickly become chaotic. The MyCNBox Spreadsheet
Why Use the MyCNBox Spreadsheet?
- Centralized Information:
- Enhanced Transparency:
- Improved Communication:
- Reduced Errors:
- Enhanced Transparency:
How to Use the Spreadsheet: A Step-by-Step Guide
Step 2: Input Core Product Information
For each item you intend to purchase, fill in the following columns:
| Column | What to Enter |
|---|---|
| Product Link (URL) | The exact webpage link to the product. This is crucial for agents to find the correct item. |
| Item Description | Size, color, style, and any specific customization notes. |
| Quantity & Price | Number of units and the price per unit in your local currency or CNY. |
| Seller/Store Name | Helps in identifying the source, especially if issues arise later. |
Step 3: Track Order Placement & Payment
Once you submit the order to your agent, update columns like Order Date, Paid Amount, and Agent Order Number. Change the Status
Step 4: Integrate QC Photos
When your agent sends Quality Control photos, insert the image links or use the spreadsheet's insert image function in the QC PhotosQC Approval
Step 5: Log Shipping Details
As items are consolidated and shipped, record the Domestic Tracking NumberInternational Tracking Number, and the Shipping Cost. Update the Status
Step 6: Final Delivery & Archive
Upon receipt, mark the item as "Delivered". You can add final notes on the product's condition. Archive the completed sheet for future reference or cost analysis.
Pro Tips for Maximum Effectiveness
Color-Code Status
Use cell colors: Yellow for ordered, Blue for QC, Green for shipped. Visual cues speed up scanning.
Hyperlink Everything
Make product links and QC photo links clickable for one-click access.
Use the Notes Column
Log any communication with sellers or agents about delays, changes, or issues.
Share View-Only Access
When sharing with an agent, provide view-only or comment-only access to prevent accidental edits.