When I got into wholesale on Amazon, my first supplier sent over a catalog. It had thousands of products. I opened the spreadsheet, looked at the UPC column, and thought — okay, I’ll just look these up.
That was a mistake that took about four months to fully understand.
The process goes like this: copy a UPC, open Amazon, paste it in the search bar, find the right listing (not always the first result), check whether it’s actually selling, look at the BSR, note the Buy Box price, count how many sellers are on it, open a spreadsheet tab, paste everything in, go back, do it again. For thousands of products.
I made it maybe 200 rows before the errors started. Wrong ASIN from a confusing search result. A price I copied from the wrong variant. A BSR I noted for the parent listing, not the child. By the time I was a few hundred rows in, I had a spreadsheet I couldn’t fully trust, for maybe 3% of the catalog.
I kept going because what else are you going to do. The whole thing took the better part of four or five months of part-time work to get through 10,000 products. And by the time I was done, some of the data at the top was already out of date.
I started building a private tool in 2023 specifically to never do that again. Upload the file, get back matched ASINs with confidence scores, BSR, Buy Box price, all of it — without touching Amazon’s search bar once. That tool became SKUBrite.
The same 10,000-product catalog now takes about 80 minutes. You can go do something else while it runs.
If you’ve been doing this by hand, try it on your next file.