AllChinaBuy Spreadsheet Order Tracking Guide
Master order tracking with your allchinabuy spreadsheet. Track domestic shipping, warehouse status, international transit, and delivery confirmation.
Ready to start tracking your hauls?
Start NowOrder tracking is the heartbeat of international buying. When you are managing multiple purchases across different sellers, agent warehouses, and shipping lines, things slip through the cracks fast. This allchinabuy spreadsheet order tracking guide gives you a complete system to monitor every order from click to doorstep.
The Four Tracking Stages
Every China fashion order passes through four distinct stages. Your spreadsheet should have a column for each, or at minimum a single Status column with these exact values. Consistency matters more than complexity.
- Ordered — Item purchased, payment confirmed, awaiting seller shipment
- Warehouse — Item received by agent, awaiting QC or consolidation
- Shipped — International package dispatched with tracking number
- Delivered — Package in your hands, inspection complete
Tracking Numbers: What to Record
Most buyers only record the international tracking number. Smart buyers record both. The domestic tracking number from seller to warehouse helps you confirm the agent actually received your item. If a seller marks shipped but the warehouse never logs receipt, you have early warning of a problem.
| Tracking Stage | Number Type | Where to Find | Priority |
|---|---|---|---|
| Seller to Warehouse | Domestic tracking | Agent order detail page | Medium |
| Warehouse to You | International tracking | Agent shipping confirmation | Critical |
| Customs Clearance | Same as international | Carrier tracking page | Medium |
| Last Mile Delivery | Local carrier number | International carrier hands off | Medium |
Shipping Line Comparison
Different shipping lines have different tracking behaviors. Some update in real time. Others batch updates once per day. Some show detailed customs status. Others stop updating once the package leaves China. Know your line.
- EMS / E-Packet — Reliable end-to-end tracking, moderate speed
- DHL / FedEx — Premium tracking, fastest delivery, higher cost
- SF Express — Good Asia-to-Europe speed, decent tracking
- Sea Mail — Minimal tracking, cheapest, slowest, 30-60 days
- Triangle Shipping — Tracking may show origin country first, not China
Expected Timeframes by Stage
Setting realistic expectations prevents anxiety and unnecessary support tickets. Here are the typical timeframes for each stage when buying fashion items from China.
- Ordered to Warehouse — 3 to 7 days domestically within China
- Warehouse to Shipped — 1 to 5 days for QC and consolidation
- Shipped to Customs — 2 to 10 days depending on shipping line
- Customs to Delivery — 1 to 7 days for local carrier handoff
Total typical delivery window: 7 days for DHL express, 14 to 21 days for EMS, 30 to 60 days for sea mail. Record your actual delivery times in a Days to Deliver column to build personal benchmarks.
Tracking Alerts and Automation
Manually checking tracking pages is tedious. Automate it. Use your carrier's app for push notifications. Forward tracking emails to a dedicated folder. In Google Sheets, set a notification rule to email you when a status cell changes to "Shipped" or "Delivered."
Handling Stuck Orders
An order stuck in "Warehouse" for more than 10 days without QC photos is a red flag. An international shipment without tracking updates for 14 days may be delayed or lost. Your spreadsheet should surface these issues automatically using conditional formatting. Any row with a Last Update date older than the threshold turns red.
Track Smarter
Combine this tracking guide with our bulk buying guide for managing large hauls, or check our automation guide for auto-alerts.
Read Full Pillar GuideFrequently Asked Questions
My tracking has not updated in 10 days. What do I do?
Contact your agent with the order number. For international shipments, check if the package is in customs. Delays there do not always show in tracking.
Should I track every item or just the consolidated package?
Track both. Item-level tracking confirms everything made it to the warehouse. Package-level tracking monitors the international leg.
Can I track through the spreadsheet itself?
Not directly, but you can store tracking URLs and use HYPERLINK formulas to make numbers clickable. For true auto-tracking, use carrier APIs with Apps Script.
Conclusion
Good tracking is not obsessive. It is protective. Every tracked order is an order that cannot disappear without you knowing. Build your allchinabuy spreadsheet tracking system once, maintain it with discipline, and never lose sleep over a missing package again.
Get the AllChinaBuy Spreadsheet
Join thousands of resellers tracking their fashion hauls smarter. Download free templates and start optimizing your workflow today.