Use Cases / Supplier List Analysis

Supplier Price List Analysis

Supplier price list analysis is the process of evaluating bulk product lists from distributors to identify profitable items for Amazon resale.

What is a Supplier Price List?

A supplier price list is a document, typically in CSV or Excel format, that contains product information from a wholesaler or distributor. These lists are provided to potential buyers to show available inventory and pricing.

A typical supplier price list includes:

  • Product codes: EAN (European Article Number), UPC (Universal Product Code), or ISBN (for books)
  • Product descriptions: Names or titles of products
  • Wholesale prices: The cost to purchase from the supplier
  • Stock availability: Current inventory levels (sometimes)
  • MOQ: Minimum Order Quantities (sometimes)

These lists can range from a few dozen products to tens of thousands of items, depending on the supplier. Large catalogs require automated analysis since manual evaluation would be impractical.

The Analysis Process

1

Obtain the supplier list

Receive the CSV or Excel file from the supplier. Typical columns include product code (EAN/UPC/ISBN), product name, wholesale price, and sometimes stock quantity.

2

Convert product codes to ASINs

EAN, UPC, or ISBN codes need to be converted to Amazon ASINs. This mapping identifies which products exist on the Amazon marketplace.

3

Fetch Amazon selling prices

Current Amazon selling prices are retrieved for each product, including the Buy Box price and competitive offers.

4

Calculate all applicable fees

Amazon fees are calculated: FBA fulfillment fees (based on size/weight), referral fees (category percentage), and any other applicable charges.

5

Determine profit margin

Profit is calculated: Selling Price - Wholesale Cost - FBA Fees - Referral Fees - Other Costs = Net Profit.

6

Evaluate additional factors

Review sales rank for demand indication, check competition levels, and consider any restrictions or gating requirements.

Understanding the Numbers

The core calculation in supplier list analysis is determining potential profit:

Net Profit = Amazon Selling Price

- Wholesale Cost (your purchase price)

- FBA Fulfillment Fee (pick, pack, ship)

- Referral Fee (category percentage, typically 8-15%)

- Other Fees (storage, prep, inbound shipping)

For example, if a product sells for $25 on Amazon, costs $10 wholesale, and has $8 in combined Amazon fees, the net profit would be $7 per unit (28% margin). Sellers typically filter for products meeting their minimum margin requirements.

Using Profit-Scanner for This

Profit-Scanner is designed to handle supplier list analysis workflows. The process works as follows:

  1. Upload your supplier CSV or Excel file containing product codes and wholesale prices
  2. The system maps EAN/UPC/ISBN codes to Amazon ASINs automatically
  3. Current Amazon prices, fees, and sales rank data are fetched for each product
  4. Profit is calculated for each item based on your supplier prices
  5. Use filters to find products meeting your criteria (minimum profit, maximum rank, etc.)
  6. Export your shortlist for ordering or further review

This automated approach allows processing large supplier catalogs in minutes rather than the hours or days manual analysis would require.

See how it works