Guide · 2026-11-05
The column legend
A row is only as honest as its weakest column. Here is what each one means, and which three you can act on.
Most spreadsheet arguments are column arguments in disguise. One person reads the price, another reads the batch, a third reads a weight that was copied from a listing. The row is the same; the decisions are not.
SPU / item ID
The seller's internal item identifier. It is the most stable part of the row and the best search phrase when a link dies. Paste it into the catalogue search rather than clicking the original link — IDs survive relists, URLs do not.
Seller
The Weidian or Taobao shop behind the row. Two rows with identical titles and different sellers are different products. If a seller is not named, the row cannot be audited, only admired.
Batch
A shorthand for a factory run — GX, PK, LJR and so on. Useful inside a seller community, nearly meaningless without the seller name. Treat "best batch" as a claim, not a column.
Packed weight
The number the freight line uses. If the sheet only shows item weight, add 10–15% for packaging. The gap is largest on hoodies and smallest on accessories.
QC state
Measured or pending. There is no "QC available" middle state that means anything. Pending is a timing signal, not a defect.
Price
The sheet price, usually in USD or CNY, before freight and duty. Compare price per gram across rows, not price alone: a $22 tee at 240 g and a $26 tee at 420 g are not the same value.
The three columns to act on
Packed weight, QC state and seller. Price is a consequence of those three, not a substitute for them. If a row has all three, it is auditable. If it has none, it is a screenshot.