Sorting a pasted column into two queues
Platform, route, item number, duplicate. Four things the cleaner reads off the addresses themselves, with nothing sent anywhere.
Platform, route, item number, duplicate. Four things the cleaner reads off the addresses themselves, with nothing sent anywhere.
Two separate queues. The box ones can go in now; the request ones need a form each and will land later, so submit those first.
Taobao 1 · 1688 1 · Weidian 1 · JD 1 · Yupoo 1
https://item.taobao.com/item.htm?spm=a1z10&id=648643962926Goes in the search boxhttps://item.taobao.com/item.htm?id=648643962926Duplicate of an earlier linehttps://detail.1688.com/offer/771234567890.htmlGoes in the search boxhttps://weidian.com/item.html?itemID=5566778899Goes in the search boxhttps://x.yupoo.com/albums/123456Needs the request formhttps://item.jd.com/100012345678.htmlNeeds the request formThe sample demonstrates the output before you replace it. Everything runs in the browser from a fixed table of host names. The official manual-request service covers additional examples, including Zhuanzhuan; this tool does not classify every supported platform. Read the supported address examples.
Read the request-form guidance for manual links and allow time for clarification. Suggested routing does not confirm that an item can be purchased.
Lists arrive in both shapes depending on what they were copied out of, so both are accepted.
The tool matches listed platform domains or their subdomains, not words inside URL parameters. Other domains and unrecognized short links stay unclassified.
It reads numeric listing IDs from the appropriate query field, or the /offer/ path on 1688. Query-name case is ignored; variant IDs are kept outside the duplicate decision.
Not the whole address, which almost never matches. Duplicates are struck through rather than deleted, so you can see what it did.
What it will not do is open anything. A link that resolves today and not tomorrow looks identical to this tool, and pretending otherwise would be the one genuinely misleading thing it could tell you.
| What it says | What to do with it | Why it happens |
|---|---|---|
| Try direct search | Paste it into the operator's search field. | Host is Taobao, Tmall, 1688 or Weidian. |
| Prepare a manual request | Prepare the exact item and options; allow time for a reply. | Host is JD, Yupoo, Xianyu, Xiaohongshu or Dewu. |
| Duplicate of an earlier line | Review the options before omitting it; the same listing can contain different intended variants. | Same platform and same item number, different tracking parameters. |
| No item number in the address | Keep it, but check it by eye against the others. | The tool found no supported numeric listing ID; inspect the original manually. |
| Not placeable | Find the listing again and copy the address properly. | The host is outside this tool’s fixed examples, the URL is malformed, or the line is not a link. |
A flagged duplicate means the platform and listing number match. It may still represent another colour, size or quantity you intend to buy. Check the variant details before removing anything from your buying list.
Two identical orders placed from two copies of one address, which then arrive as two items and have to be unpicked.
A request missing size, colour or quantity can need clarification. Preparing these details early can reduce avoidable back-and-forth.
Shops. Grouping by shop is a separate pass and the one with money attached to it, covered on the one-shop page.
Stock. Nothing in an address says whether the listing still has your size.