Guides9 min read

What to Track in Your AllChinaBuy Spreadsheet

A half-empty spreadsheet is almost as bad as no spreadsheet at all. Here is the complete list of what to track in your allchinabuy spreadsheet, ranked by priority, so you never miss a critical detail again.

What to track in AllChinaBuy spreadsheet data columns

The Tracking Priority Matrix

Not every data point deserves equal attention. Some columns are mission-critical. Others are nice-to-have. The table below ranks every tracking element by priority and explains exactly why it matters.

Use this as your blueprint when building or customizing your allchinabuy spreadsheet.

Need a template with these columns pre-built?

Free Templates

Complete Tracking Checklist

Item to TrackPriorityWhy It Matters
Item URL / LinkCriticalProof of purchase, reordering, and dispute resolution
Translated NameCriticalYou will not recognize Chinese titles in three weeks
Size & ColorCriticalAgent processing errors drop to near zero with this data
Item Price (CNY)CriticalBase cost before any add-ons
Domestic ShippingHighHidden cost that surprises 70% of beginners
Agent Service FeeHighVaries by platform; must be factored into total
Weight (grams)HighDirectly determines international shipping cost
International ShippingMediumUsually calculated after warehouse arrival
Total Landed CostCriticalThe only number that matters for budgeting
StatusCriticalPrevents anxiety and premature refund requests
Warehouse Arrival DateMediumStorage fees often kick in after 30–90 days
Delivery DateLowNice for year-end review and resale planning
Seller Name / StoreMediumHelps you identify reliable sellers for repeat buys
NotesLowRefund status, quality issues, or sizing feedback

The Critical Four

If you are in a hurry and can only track four things, make them these:

1

Item URL

The single source of truth. Dead links still carry item IDs that agents can trace.

2

Size & Color

One wrong size ruins an entire haul. Write it down before you forget.

3

Total Landed Cost

Item price + domestic shipping + agent fee + international shipping. This is your real budget number.

4

Status

Knowing whether an item is purchased, in warehouse, or shipped eliminates 90% of anxiety.

Advanced Tracking for Power Users

  • Resale price and platform fee columns for profit-margin tracking.
  • Quality score (1–5) after delivery to build a personal seller blacklist/whitelist.
  • Return deadline countdown to avoid missing the window for refunds.
  • Shipping method used (EMS, DHL, sea freight) to compare speed vs cost over time.
  • Parcel number for each item so you can trace exact location with carriers.

Continue Your Learning

Tracking is only half the battle. Learn how to use your allchinabuy spreadsheet effectively, or read about common mistakes to avoid. Return to the homepage.

Frequently Asked Questions

Track Everything, Regret Nothing

The shoppers who never have problems are not luckier — they are better trackers. Build your allchinabuy spreadsheet around these fourteen data points and you will shop with complete confidence.