How to Analyze a Wholesale Price List for Amazon FBA
A distributor sends you a price list with 400 products. Some are worth ordering, most aren’t. Here’s how to cut through it fast and find the ones that actually make sense.
Getting a price list from a supplier feels like progress. And it is. But a spreadsheet with 400 SKUs doesn’t tell you much on its own. You need Amazon data sitting next to those prices before you can make any real decisions.
Most beginners either stare at the spreadsheet hoping something stands out, or they check products one by one in Seller Central. Both are slow and miss things. Here’s the process that actually works.
If you don’t have suppliers yet and aren’t sure how to get price lists in the first place, start with the supplier sourcing guide first.
Step one: get the data out of the spreadsheet
You can’t analyze a price list by looking at it. You need Amazon sales data pulled in next to the distributor’s prices. There are two ways to do this.
Option 1: AMZ Analyzer (faster)
Upload the price list directly to AMZ Analyzer. It matches your products to Amazon ASINs automatically and pulls in BSR, Buy Box price, number of sellers, ROI, and profit in one view. You can filter the whole list in minutes instead of hours.
Use code Jakub26 for 25% off.
Option 2: Keepa bulk upload (more detail)
Pull the UPCs from the price list and upload them to Keepa’s bulk ASIN tool. You get detailed Amazon history for each product going back 12 to 24 months. More steps than AMZ Analyzer, but Keepa’s chart view is very good for the historical analysis that actually matters.
In practice, AMZ Analyzer works well for the first pass. Keepa is better for looking closely at anything that passes the initial filters.
The filters to run first
When you’re doing an initial cut, you’re not trying to find the perfect product. You’re trying to eliminate the obvious nos fast. These are the filters worth running:
This first pass cuts most price lists down by 80% or more. What’s left is worth a proper look.
The Amazon Buy Box is not an automatic no
This is one of the most common things I see people get wrong. The advice you’ll hear everywhere is: if Amazon is on the listing, don’t touch it. That’s too simple.
What actually matters is Buy Box share percentage. If Amazon holds 50% of the Buy Box and the product moves 400 units a month, there are still 200 units going to third-party sellers. That’s a real number. If Amazon holds 95% consistently, then yes, move on.
Check the Buy Box percentage history in Keepa. If Amazon’s share has been dropping over time, that’s even better. It means the listing is opening up.
Why history matters more than today’s numbers
This is the part most beginners miss entirely. When you look at a product for the first time, you see a snapshot. BSR of 40,000. Price of $26.99. Six sellers. Looks fine. But those numbers tell you nothing about whether this product is stable or about to fall apart.
What you actually need to check in Keepa:
- Buy Box price history. Has the selling price been holding steady, or is it slowly dropping as more sellers pile in and compete on price?
- BSR history. Consistent and in a healthy range for months, or is today just a spike with long stretches of poor sales either side?
- Number of reviews. Growing steadily means real buyers. Flat for 12 months means the product has stopped gaining traction.
- Number of sellers. Has it been 3 to 5 sellers for months, or did 12 new sellers show up in the last 30 days?
A product where the price is dropping, seller count is rising, and BSR is inconsistent is a bad bet no matter what today’s numbers look like. A product with a stable price, consistent BSR, growing reviews, and a steady seller count is worth ordering even if the current snapshot looks ordinary.
- BSR stable and within range for the category
- Buy Box price flat or growing over 6+ months
- 3 to 6 sellers, same ones month after month
- Reviews growing gradually
- Amazon not present, or under 70% Buy Box share
- BSR all over the place with no pattern
- Buy Box price dropped 20%+ in recent months
- Seller count jumped recently
- Amazon holds nearly all Buy Box share
- Hazmat, oversized, or margin doesn’t work
On minimum ROI
There’s no universal number here. Some sellers don’t go below 10% ROI. Others won’t touch anything under 30%. It depends on your capital, your volume targets, and how fast the product turns.
What matters more than hitting a specific threshold is that your ROI calculation is accurate. That means accounting for FBA fees, any prep costs, shipping to Amazon, and seasonal pricing shifts you spotted in the history. A product showing 25% ROI that shrinks to 8% after fees is not a 25% ROI product.
AMZ Analyzer handles this math automatically once you enter your cost per unit, which is one of the main reasons it’s worth using for the initial pass.
One more thing: check if you can actually sell it
Before you get too excited about a product, make sure you’re not gated on the brand. There’s no point doing deep analysis on something you can’t list yet. Check in Seller Central first. If you need brand approval, that’s a separate process. The ungating guide covers how that works.
In the mentorship we go through your actual price lists and I show you exactly what I’m looking at and why. You leave with products worth ordering, not just a framework.