To analyze a wholesale price list for Amazon, match each product to its Amazon listing, add the selling price and fees, work out the profit and ROI, then check demand and competition for the products that pass. The result is a short list of products worth ordering.
Quick answer: Put the price list in a spreadsheet, find each product on Amazon by UPC, add the Buy Box price and Amazon’s fees, calculate profit and ROI, then filter out anything below your minimum before you check sales rank and sellers.
How to Read a Supplier Price List for Amazon
Most price lists include these columns:
| Column | What it means |
|---|---|
| Item / SKU | The supplier’s own product code |
| Description | Product name, size and pack |
| UPC / EAN | The barcode, used to find the Amazon listing |
| Case pack | How many units come in one case |
| Unit cost | Your cost per unit |
| MOQ | The minimum quantity you must order |
Check the pack size carefully. A price list may show a single unit while the Amazon listing is a 3-pack, or the other way round. Matching the wrong pack is the most common price-list mistake.
Step-by-Step Analysis
- Clean the list. Keep the UPC, description, pack size and cost. Remove products you cannot sell, such as brands you are not approved for.
- Match each UPC to Amazon. Search the UPC on Amazon or use a bulk tool that matches UPCs to ASINs.
- Add the selling price. Use the current Buy Box price, and check its recent history so you do not rely on a temporary spike.
- Add the fees. Referral fee, FBA fulfillment fee, inbound shipping and prep. Amazon’s revenue calculator gives the first two.
- Calculate profit and ROI. Profit = price − fees − cost. ROI = profit ÷ cost. Compare with your target; see what makes a good ROI for Amazon wholesale.
- Check demand and competition. For products that pass, look at the good BSR for wholesale and the number of sellers. You can use Keepa for wholesale to see both over time.
Worked Example
| Product A | Product B | |
|---|---|---|
| Unit cost | $6.00 | $9.00 |
| Buy Box price | $18.99 | $16.49 |
| Amazon fees (referral + FBA) | $6.20 | $6.10 |
| Inbound shipping + prep | $0.60 | $0.60 |
| Profit | $6.19 | $0.79 |
| ROI | 103% | 9% |
Example figures for illustration only. Use Amazon’s revenue calculator for real fees.
Product A moves on to the demand and competition check. Product B does not make the cut.
Tips
- Note the date you ran the numbers. Prices and fees change.
- Keep a “watch” tab for products that almost pass; they may work after a price change.
- Ask the supplier about case-pack discounts on products you will reorder.
For the full research process, see how to find profitable wholesale products.
Request Our Price List
Our price list includes UPCs and case packs so you can run this analysis in minutes. Apply for a wholesale account to get it.
Frequently Asked Questions
What if a UPC matches more than one listing?
Check each listing’s pack size and condition, and use the one that matches the product exactly.
What if a product has no Amazon listing?
You can create one, but that is closer to private label work than wholesale. Most wholesale sellers skip these.
How often should I re-run the numbers?
Every time you reorder. Selling prices, seller counts and fees all move over time.