Skip to content
Lovegobuy SpreadsheetLinks & buying guide

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.

Try “black cargo pants” or “canvas tote bag”.

What is in that list

3 in the box, 2 by request6 lines read

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

  • 1 duplicate removed by item number.
  • 2 addresses carry no item number, so they were not compared with the rest.
  1. https://item.taobao.com/item.htm?spm=a1z10&id=648643962926Goes in the search box
  2. https://item.taobao.com/item.htm?id=648643962926Duplicate of an earlier line
  3. https://detail.1688.com/offer/771234567890.htmlGoes in the search box
  4. https://weidian.com/item.html?itemID=5566778899Goes in the search box
  5. https://x.yupoo.com/albums/123456Needs the request form
  6. https://item.jd.com/100012345678.htmlNeeds the request form

The 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.

What it does, in order

  1. Splits on lines and commas

    Lists arrive in both shapes depending on what they were copied out of, so both are accepted.

  2. Reads the host

    The tool matches listed platform domains or their subdomains, not words inside URL parameters. Other domains and unrecognized short links stay unclassified.

  3. Pulls the item number

    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.

  4. Compares platform plus number

    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.

Reading the result

The five things the cleaner can say, and what each means for the batch.
What it saysWhat to do with itWhy it happens
Try direct searchPaste it into the operator's search field.Host is Taobao, Tmall, 1688 or Weidian.
Prepare a manual requestPrepare the exact item and options; allow time for a reply.Host is JD, Yupoo, Xianyu, Xiaohongshu or Dewu.
Duplicate of an earlier lineReview 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 addressKeep it, but check it by eye against the others.The tool found no supported numeric listing ID; inspect the original manually.
Not placeableFind 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.
Duplicate is not the same as two

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.

Why this is worth four minutes

What a mixed list costs

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.

What it does not fix

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.