Prepare your supplier file (Excel or CSV)
Which columns you need, how to handle UPC, EAN, ASIN and ISBN, case packs and MOQ, and the mistakes to avoid.
A clean supplier file gives a clean scan. Wholesale Analyzer reads Excel (.xlsx) and CSV files of up to 200,000 rows.
Columns you need
- An identifier: UPC, EAN, ASIN or ISBN. You choose the type when you start the scan, and the column can have any name.
- Your cost (recommended): the supplier's unit price. Without it you still get market data, but no profit, ROI or decision.
Useful optional columns
- Product name and brand: help you recognise products and improve brand-risk checks.
- MOQ and case pack: let the tool check whether the minimum order is sensible. When you start the scan you say whether the MOQ is counted in units or cases.
Avoid these common mistakes
- Lost leading zeros. Excel turns 012345678905 into 12345678905. Format the identifier column as text before pasting, or export as CSV from the supplier's system.
- Scientific notation. 8.85E+11 is not a UPC. Again, format the column as text.
- Mixed currencies. Use one currency per file: the marketplace's currency.
- Case price instead of unit price. If the supplier quotes per case, divide by the case pack first.
- Several sheets. Put the price list on the first sheet.
Check identifiers before you scan
Our free UPC & EAN validator checks the check digit of every code, so you can fix bad rows in advance. See also UPC, EAN and ASIN matching mistakes.
Still stuck? Write to support and we will help you, usually within one business day.
Stop guessing. Start buying with confidence.
Upload your next supplier list and see which products are worth your money, how many to order and the most you should pay. Your first scan every month is free.