A field-by-field breakdown of exactly what information belongs in your AllChinaBuy tracking sheet and why each column matters. This article is part of our comprehensive resource hub dedicated to helping you optimize allchinabuy spreadsheet workflows. Whether you are a beginner or a power user, the strategies below will save you time and money.
The Non-Negotiable Columns
Every AllChinaBuy spreadsheet needs at minimum: Product Name, Product URL, Original Price, Size or Variant, Agent Name, Domestic Shipping, Service Fee, International Shipping, Total Cost, Status, and Order Date. Skip any of these and you will face a blind spot later. The Product URL is especially critical. When a dispute arises, the agent needs the exact link. Without it, resolution takes days instead of hours.
Cost Layers You Cannot Ignore
First-time buyers track the product price and call it done. Then the invoice arrives with three extra lines: domestic freight within China, agent service charge, and international shipping. Each layer typically adds fifteen to thirty percent to the base price. Tracking them separately in your spreadsheet prevents the shock of a final cost that is forty percent higher than expected.
Status Fields That Prevent Disasters
Status tracking is not just for organization. It is for protection. When an item sits in Ordered status for three weeks without moving, that is a red flag. When something shows Delivered but never arrived, you have a timestamped record for the agent. Use these statuses: Wishlist, Ordered, Paid, In Warehouse, Shipped, In Customs, Delivered, Refunded, and Disputed.
Optional but Powerful Extras
Resellers should add Resale Price, Platform Fee, Net Profit, and Reorder Flag. Group buyers should add Member Name and Split Cost. Fashion buyers should add Material, Fit Notes, and Photo Received. These extras take thirty extra seconds per order but save hours of backtracking later.
| Column | Priority | When It Saves You |
|---|---|---|
| Product URL | Critical | Every dispute |
| Original Price | Critical | Budgeting |
| Size/Variant | Critical | Wrong item returns |
| Agent Name | Critical | Multi-agent confusion |
| All Cost Layers | Critical | Invoice shock |
| Status | Critical | Delay detection |
| Resale Price | High | Profit tracking |
| Fit Notes | Medium | Repeat sizing |
| Photo Received | Medium | QC verification |
Related Resources
Ready to Put This Into Practice?
Head to our main store to start sourcing products, then track every order with the strategies in this guide.