Skip to main content

How to read Price List Analyzer results

Detailed description of Price List Analyzer results

When Price List Analyzer finishes the process of analyzing, you can download the report with the created leads. The tool prepare a report in the .xlsx format.

Detailed description of all columns in the final report:

  • ASIN
    Amazon Standard Identification Number is a unique identifier for an item in the Amazon catalog. Link to the product on Amazon is inserted into ASIN.

  • ASIN Link
    Link to Amazon product page

  • Image
    Product image

  • Title
    Name of the product

  • Like
    Products marked with a like or dislike

  • Tags
    Your tags on the products

  • Notes
    Your notes on the products

  • Restrictions

  • Approval Link
    Link to Amazon account for approval

  • Brand
    Brand of the product

  • Package Quantity

  • Profit FBA, $
    Your profit in the currency of the site. Profit is calculated using the formula:

Profit FBA = Price - Cost of Goods (COG) - Referral Fee - Sales Tax (if any) - VAT (if any) - FBA Fee (if any) - Monthly storage Fees (if any) - Digital Service Fee (if any) - Inbound placement service fee (if any) - FBA logistics costs (3PL) - Additional Expenses (if any) - ROI FBA, %
Return on Investment,%. The metric that shows the return of investment when selling a product i.e. the percentage of money you get versus the money actually spent. While calculating ROI, only incurred costs are used i.e. Amazon commissions are not counted because they are not paid with "real money", but are withdrawn from an account upon sale. ROI is calculated using the following formula:

ROI FBA = Profit FBA / (Cost of goods (COG) + Sales Tax (if any) + Logistics costs FBA (3PL) + Additional Expenses (if any)) * 100 - Margin FBA, %

A metric that shows the share of your profit in the selling price. Calculated by the formula:

Margin FBA = Profit FBA / Price * 100 - Break Even Price FBA, $
The selling price for FBA at which profit = 0, after Amazon fees, taxes, and logistics costs

  • COG, $
    Cost of goods from initial price list

  • Cost of Goods incl. VAT
    We can display 'yes' or 'no' depending on your extension settings

  • Max COG FBA, $
    The maximum cost of goods for FBA at which profit = 0, after Amazon fees, taxes, and logistics costs

  • Max COG FBM, $
    The maximum cost of goods for FBM at which profit = 0, after Amazon fees, taxes, and logistics costs

  • Selling Price
    This price used to calculate Profit. By default, BB Price is used for calculation. You can select one of the options when preparing the price list for analysis.

Selling Price = BB Price if available, else Selling Price = Min FBA or FBM Price if available, else Selling Price = Avg BB Price 30 days if available, else Selling Price = Avg BB Price 90 days if available, else Selling Price = Avg BB Price 180 days if available, else Selling Price does not contain a value - Break Even Price FBM, $
The selling price for FBM at which profit = 0, after Amazon fees, taxes, and logistics costs

  • Profit FBM, $
    Profit is calculated using the formula:

Profit FBM = Price - Cost of Goods (COG) - Referral Fee - Sales Tax (if any) - VAT (if any) - Digital Service Fee (if any) - FBM logistics costs (3PL) - Additional Expenses (if any) - ROI FBM, %
ROI is calculated using the following formula:

ROI FBM = Profit FBM / (Cost of goods (COG) + Sales Tax (if any) + Logistics costs FBM (3PL) + Additional Expenses (if any)) * 100 - Margin FBM, %

A metric that shows the share of your profit in the selling price. Calculated by the formula:

Margin FBM = Profit FBM / Price * 100 - Sales Estimate, pcs/mo
The approximate number of product sales, calculated based on BSR and Category

  • Sales Estimate, $/mo
    The approximate revenue​

  • Category

  • BSR
    Best Sellers Rank is the ranking of a product in a specific category

  • TOP BSR
    The data from Keepa on the downward BSR change

TOP = (BSR / Number of goods in the category) * 100 - Avg BSR 30 days

  • Avg BSR 90 days

  • Avg BSR 180 days

  • Sales Rank Drops 30 days

  • Sales Rank Drops 90 days

  • Sales Rank Drops 180 days

  • Warnings – we included custom warnings on yellow background to draw your attention:

  • No FBA Fees
    FBA fees are unavailable. The product may be ineligible for FBA or lack sufficient data for fee calculation

  • No Buy Box Price
    The product has no active offers, or the Buy Box is suppressed

  • ASIN not found
    The ASIN is invalid, doesn’t exist, or has been removed or suppressed by Amazon

  • Set or Bundle
    The ASIN represents a bundled or multi-pack item

  • Approval Required
    You need approval to sell this product

  • No COGs
    Price data is missing in the original price list

  • Restricted
    You are not eligible to sell this product

  • FBA ROI is lower than -300%
    The ROI for this product is below the threshold of -300%

  • FBA ROI exceeds 200%

    Too high FBA ROI

  • Alerts & Flags:

  • Oversize Flag

  • HazMat Flag

  • Meltable Flag

  • Fragile Flag

  • IP Complaints risk Flag

  • Variation Flag

  • Generic Flag

  • Set/Bundle Flag

  • Stock
    Displays if product is currently out of stock or in stock

  • Sales Tax, $

  • Sales Tax Rate, %
    Depends on your extension settings

  • Monthly Sold

  • Monthly Sold 30 days

  • Monthly Sold 90 days

  • Monthly Sold 180 days

  • Amazon in Buy Box
    Indicates whether Amazon was the Buy Box winner

  • Rating

  • Review Count

  • BB Price, $

  • Avg BB Price 30 days

  • Avg BB Price 90 days

  • Avg BB Price 180 days

  • Price Dynamics, %

  • Total Offers

  • Buy box eligible offers FBA

  • Buy box eligible offers FBM

  • Top Seller BB FBA, %

  • Top Seller BB FBM, %

  • Top Seller FBA
    Seller ID with the highest Buy Box win percentage over recent intervals, when available

  • Top Seller FBM
    Seller ID with the highest Buy Box win percentage over recent intervals, when available

  • Avg AMZ BB Share 30 days, %

  • Avg AMZ BB Share 90 days, %

  • Avg AMZ BB Share 180 days, %

  • Total FBA Fees, $
    The total amount of FBA Amazon commissions

  • Total FBM Fees, $
    The total amount of FBM Amazon commissions

  • Referral fee, $
    A fee Amazon charges you every time you sell a product

  • FBA Fee, $
    Fees for fulfilment by Amazon

  • Inbound Placement Service Fee, $
    Depends on your extension settings

  • Storage fee, $
    A fee Amazon charges you for storing your product in the warehouse

  • Variable Closing fee, $
    Per item fee that Amazon charges you for selling books, music, video, blu-ray & DVDs

Note

Amazon deducts the greater of the applicable referral fee percentage or applicable per-item minimum referral fee. If the Referral fee amount per item is less than the minimum threshold, a minimum fee of $0.30 will be applied instead.

  • Misc Fee Rate, %

  • Misc Fee Calc, $

  • Misc Fee Flat, $

  • VAT on Fees Rate, %
    Depends on your extension settings

  • VAT on Fees, $

  • Third Party Logistics FBA:

  • Third Party Logistics (FBA), $
    Total logistics costs (Ship + Prep + Frgl)

  • Inbound Shipping FBA cost (per item + per lbs), $
    The amount of shipping costs per item + per lbs (it depends on your extension settings)

  • Digital Service Fee, %
    Depends on your extension settings

  • Digital Service Fee FBA, $
    Depends on your extension settings

  • Seller proceeds FBA, $
    Displays gross proceeds before excluding Cost of Goods Sold and logistics

  • Shipping costs/item, (FBA), $
    Depends on your extension settings

  • Shipping costs/lbs, (FBA), $
    Depends on your extension settings

  • Prepare/Labeling Cost, (FBA), $
    Depends on your extension settings

  • Fragile/Bubble Wrapping, (FBA), $
    Depends on your extension settings

  • HazMat Fee FBA, $
    Depends on your extension settings

  • Oversize Fee FBA, $
    Depends on your extension settings

  • Third Party Logistics FBM:

  • Digital Service Fee FBM, $
    Depends on your extension settings

  • Seller proceeds FBM, $
    Displays gross proceeds before excluding Cost of Goods Sold and logistics

  • Third Party Logistics (FBM), $
    Total logistics costs (Ship + Prep + Frgl)

  • Inbound Shipping FBM cost (per item + per lbs), $
    The amount of shipping costs per item + per lbs (it depends on your extension settings)

  • Shipping costs/item, (FBM), $
    Depends on your extension settings

  • Shipping costs/lbs, (FBM), $
    Depends on your extension settings

  • Prepare/Labeling Cost, (FBM), $
    Depends on your extension settings

  • Fragile/Bubble Wrapping, (FBM), $
    Depends on your extension settings

  • HazMat Fee FBM, $
    Depends on your extension settings

  • Oversize Fee FBM, $
    Depends on your extension settings

  • Parent ASIN

  • Variations Qty

  • Variations

Lists ASINs belonging to the same product family (variation set). Each ASIN links to its Amazon product page.

  • Frequently Bought Together

  • Product description and dimensions:

  • Model

  • Part Number

  • Size Info

  • Manufacturer

  • Size Type

  • Size, in and cm

  • Height, in and cm

  • Width, in and cm

  • Length, in and cm

  • Weight, lbs and kg

  • Product Volume, cu ft and cm

  • Color

  • Product codes:

  • UPC
    product code from initial price list or the code found by the system

  • EAN
    product codes from initial price list or the code found by the system

  • GTIN
    Global Trade Item Number

  • Identifier​

  • Description

  • Features

  • Supplier SKU

  • Supplier Case Qty

  • Marketplace

  • Keepa
    Link on Keepa

  • Original File Columns

​

​

​

​

​

​

​

​

Do it with AI

Read the results of an analysis in chat, or narrow the leads by ROI and estimated sales.

Connect Seller Assistant MCP in Claude or ChatGPT (Business and higher), then ask in chat:

  • "Show the leads from price list analysis [name or ID] - ASIN, profit, ROI, and seller counts."

  • "From my price list [name or ID], show the products with ROI above 30% and at least 20 estimated sales a month."

More about this workflow: Price List Analyzer.

Setup: How to connect MCP Server to Claude, How to connect MCP Server to ChatGPT. More prompts: Prompts for Seller Assistant MCP.

Did this answer your question?

Related Articles