Column one
The first column is the item ID, usually a long run of digits. For sample 2026W39-014 that number is 7577045115, and it is the most durable thing in the whole row. It identifies the listing rather than the wrapper around it.
Use it as your key. When you compare two sheets, match them on the ID rather than on the item name, since names get shortened and rewrapped as lists get copied. Two rows with the same ID are the same listing, however different the words look.
One limit is worth stating before you lean on it. The ID alone does not tell you which marketplace the listing sits on, so it gets you to the item and no further. You need the next column for the marketplace.
Column two
The second column is the wrapped address. All 31 wrapper records in snapshot 2026-W39 had the same shape: acbuy.com/product, then an id, then a source marker reading WD. That marker is the part of the row that earns its place.
Read it as a pointer, not as a shop. A source marker of WD points at Weidian, and the listing lives there rather than at the address in the cell. Marketplace listings belong to the marketplaces, which is why a wrapper can stop answering while the item stays exactly where it was.
Copy this column into the sheet column mapper and it will sort the link shapes apart for you, which beats doing it by eye across a list of any real length. Mixed shapes are the usual reason one row behaves differently from the next.
The column everyone misreads
The price column is the one that gets misread almost every time. It is a snapshot from the day somebody added the item to their list, not a live figure and not a quote from any seller. Read it as history.
The error runs in both directions. People assume the number is what they will pay, then meet a different figure at the marketplace. Others treat a change as a sign that something went wrong, when it just means the listing was repriced between two moments.
The same caution covers any quantity, size or comment cell a sheet author added while building the row. Those are notes rather than fields, and they were written for the author's own use. Treat them as clues worth checking against the live listing, never as facts to build a budget on.
Using them together
The reading order is fixed: item ID first, source marker second, rebuild third, price last. Sample 2026W39-014 walks that path cleanly. The ID gave us the listing, the WD marker told us where it lived, and the weidian.com address behind it answered normally in our 2026-W39 window.
Do it in that order and a whole sheet becomes readable without opening a single order box. Going backwards, starting from the price or the item name, is how people spend an evening rebuilding addresses for things they never actually wanted in the first place.
The field notes entry on reading a row you did not build yourself walks the same columns at greater length, including the ones that look informative and carry nothing you can act on. Read it before you inherit a second sheet from somebody else.