There are two kinds of people who shop with Chinese buying agents: the ones who order three things at once and remember everything, and the rest of us. Once your warehouse starts filling with separate parcels — one from Taobao, two from Weidian, a pre-order that shipped late — the only thing standing between you and a forgotten item is a decent tracking sheet. Here's how to build one, column by column, and the formulas that do the heavy lifting for you.
Why a spreadsheet beats your memory
Buying agents operate on a timeline that spans weeks. An item is ordered, then purchased by the agent, then shipped to their warehouse, then photographed for QC, then held until you consolidate, then shipped internationally, then cleared by customs, then delivered. That's at least eight touchpoints. A spreadsheet gives you one place to see every parcel's current stage, spot anything that's been sitting too long, and know exactly what you've already paid for.
The good news is you don't need anything fancy. If you'd rather skip building it from scratch, a tool like sheetquik.com gives you a ready-made haul tracker designed for agent shopping — but the concepts below work in Google Sheets, Excel, or any table you prefer.
The columns that matter
Resist the urge to add forty columns. Eight well-chosen ones cover 95% of hauls:
| Column | Why it exists | Example |
|---|---|---|
| Item name | Short, searchable label | Chunky knit cardigan (grey) |
| Store / platform | For disputes and re-orders | Taobao — 月月家 |
| Price (CNY) | Original item cost | 168 |
| Domestic shipping | Agent fee + courier to warehouse | 12 |
| Status | One-word stage flag | In warehouse |
| Warehouse arrival date | Triggers storage-fee awareness | 2026-08-18 |
| Parcel / tracking no. | Once consolidated | LV882913456CN |
| Notes | QC issues, pre-order ETA, refunds | Slightly darker than photo |
The two columns people forget are domestic shipping and warehouse arrival date. The first is where surprise costs hide; the second is what tells you a parcel has been gathering dust long enough that you should check on it.
Build it in ten minutes
- Create a new sheet and add the header row above.
- Freeze the top row (View → Freeze → 1 row) so headers stay visible as you scroll.
- Add a Status dropdown via Data Validation with the options: Ordered, Purchased, In warehouse, QC pending, QC approved, Consolidated, Shipped, Delivered, Refunded.
- Conditional-format the Status column so each stage gets a colour — this is what turns a grid into a dashboard you can read in two seconds.
- Add one row per item, not per order. A 6-item order becomes 6 rows. This matters when you split an order across parcels.
The three formulas worth knowing
- Days in warehouse:
=IF(H2="","",TODAY()-H2)— counts how long a parcel has been sitting since arrival. - Running total spent:
=SUM(C2:C)— always know your damage before consolidation. - Items per parcel:
=COUNTIF(G2:G,"LV*")— confirms nothing got left out of a consolidation.
A conditional-format rule on the days-in-warehouse column that turns red after 90 days (most agents start charging storage fees around then) will quietly save you money.
Workflow habits that make the sheet useful
A spreadsheet only earns its keep if you update it. The habit that works: update status the moment an event happens, not at the end of the week. Bought? Flip it. QC photos arrive? Flip it. If you update weekly instead of daily, you'll double-check a parcel that already shipped. Oopbuy Spreadsheet readers who track this way report far fewer "wait, did I actually order that?" moments.
When an item lands at the warehouse and passes QC, that's your cue to move it into your consolidation plan. If you're juggling several hauls at once, give each haul its own tab, or add a Haul column so you can filter one shipment at a time. Finally, keep a second small tab for refunds and disputes — items whose money is in limbo deserve their own list, complete with the date you filed and what the agent promised.
Three habits that quietly break trackers
- One row per order, not per item. The moment an order ships in two parcels or a pre-order arrives late, a merged row stops matching reality. Split it and you'll always know what's where.
- Statuses that are too vague. "Processing" covers too many stages to be useful. Use the eight specific statuses above so you can see the exact bottleneck instead of a fuzzy blob.
- Deleting delivered rows. Keep your completed hauls — they're your price history, your size reference, and your proof of what you've paid when a dispute comes up months later.
That's the whole system. Eight columns, three formulas, two dropdowns, and a weekly two-minute update routine. It won't make the shipping faster, but it will make sure nothing quietly disappears between your warehouse and your doorstep.