What is actually in the file
Open any Taobao spreadsheet and the operative column is a set of URLs shaped item.taobao.com/item.htm?id= followed by eleven or twelve digits. Those digits are the whole payload. Everything else in the row — the photo, the price, the seller note — is annotation.
The ID belongs to the seller's listing, not to any agent. This is why the same find appears in one sheet as a CNFans link and in another as a raw Taobao link: both wrap the identical number.
Why Taobao specifically needs an agent
Taobao is domestic infrastructure. Sellers price for domestic delivery, accept domestic payment rails, and in most cases will not ship outside mainland China at all. Nothing about that is a policy against foreigners; it is simply what the platform was built for.
The agent exists to bridge exactly that gap: they hold a Chinese account and address, buy on your behalf, receive the parcel, and forward it. Three functions, one fee — and six of the eight agents with verified rates charge nothing visible for it, recovering the margin on the exchange rate and the freight quote instead.
Taobao versus Weidian versus 1688, in one line each
All three need an agent, and people mix them up constantly because the sheets look identical.
| Platform | URL parameter | Typical seller | Best for |
|---|---|---|---|
| Taobao | id= | Established storefronts, ratings, dispute system | Breadth — the deepest catalogue of the three |
| Weidian | itemID= | Small independent sellers, often WeChat-first | Rep-specific stock that never lists on Taobao |
| 1688 | offer/ in the path | Factories and wholesalers, minimum quantities | Buying five or more of the same thing |
The parameter names matter because hand-editing a Taobao link into a Weidian slot produces a URL that looks right and resolves to nothing.
How to read a sheet before you spend anything
- Check the link is live before converting. Listings get pulled; a dead ID converts perfectly into eighteen dead links.
- Check the date on the sheet. Prices drift and sellers close. A 2023 Taobao sheet is a starting point, not a price list.
- Ignore the agent in the link. Whoever built the sheet picked their own agent. That is not a recommendation, it is a default.
- Watch for PandaBuy and WeGoBuy links. Both agents are closed — see the recovery page. The IDs inside still work.
Tmall is Taobao, with one difference
Plenty of sheet rows point at detail.tmall.com rather than item.taobao.com, and people assume it needs different handling. It does not — the converter treats both identically, because the ID space is shared and every agent accepts either.
The difference is who is allowed to sell. Tmall storefronts are operated by registered businesses or authorised distributors, with a deposit lodged against the account, whereas anyone can list on Taobao. That raises the floor on accountability and raises prices with it. For genuine brand goods Tmall is the safer half of the same platform; for the things people build spreadsheets around, Tmall storefronts largely do not carry them.
Reading the seller, not just the item
Taobao is the only one of the three agent platforms with a mature reputation system, and spreadsheets throw that information away by reducing a listing to a link. It is worth opening the storefront before converting anything.
Three signals carry most of the weight. The first is the shop's rating tier, displayed as a run of hearts, diamonds or crowns — the scale escalates with cumulative transactions, so a crown-tier store has processed orders in the hundreds of thousands. The second is the trio of scores Taobao shows against every shop: description accuracy, service, and dispatch speed, each rated against the category average and colour-coded green or red. Description accuracy is the one that matters here, because it measures precisely the gap that hurts you — the difference between the listing photos and what turns up.
The third is the review tab with the buyer-photo filter applied. Listing images are supplied by the seller and are routinely the retail product rather than what ships. Buyer photographs are not, and on a high-volume listing their absence is itself a signal.
None of this replaces the QC stage — it just means fewer items reach it in a state you would reject.
The part sheets never tell you
A Taobao spreadsheet lists the goods price and stops there, which is why first orders come in over budget so reliably. The item is the smallest of four costs: after it come the agent's exchange rate spread, international freight, and import charges at your border. On a single low-value item, freight alone routinely exceeds the goods.
Run the parcel through the shipping calculator with box dimensions before you commit — volumetric weight, not the scale, is what gets billed on anything bulky.