Skip to main content

How to read Price List Analyzer results

Detailed description of Price List Analyzer results

Updated this week

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:

  • 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

  • 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.

  • Link
    Product link

  • Image
    Product image

  • Like
    Products marked with a like or dislike

  • Notes
    Your notes on the product

  • Title
    Name of the product

  • 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)
    - Sales Tax (if any)
    - Referral Fees
    - VAT (if any)
    - FBA Commission
    - Monthly storage cost
    - FBA logistics costs (3PL)

    If there is no BB price, then next to FBA/FBM Profit there will be hints where the price for calculation is taken from:

    • Lowest - Min FBA or FBM Price

    • Avg 30 - Average BB Price 30 days

    • Avg 90 - Average BB Price 90 days

    • Avg 180 - Average BB Price 180 days

    • No BB - There is no price to calculate

  • 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))
    * 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, $
    This is the cost of the product at which Profit is $0

  • COG, $
    Cost of goods from initial price list

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

  • 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, $
    This is the cost of the product at which Profit is $0

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

    Profit FBM = Price
    - Cost of Goods (COG)
    - Sales Tax (if any)
    - Referral Fees
    - VAT (if any)
    - FBM logistics costs (3PL)

  • ROI FBM, %
    ROI is calculated using the following formula:

    ROI FBM = Profit FBM
    / (Cost of goods (COG)
    + Sales Tax (if any)
    + FBM logistics costs (3PL))
    * 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

    If there is no BB price, then next to Sales Estimate there will be hints where the price for calculation is taken from:

    • Lowest - Min FBA or FBM Price

    • Avg 30 - Average BB Price 30 days

    • Avg 90 - Average BB Price 90 days

    • Avg 180 - Average BB Price 180 days

    • No BB - There is no price to calculate

  • 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

  • Listing Restrictions

  • Approval Link

  • Amazon in Buy Box

  • Rating

  • Review Count

  • BB Price, $

  • Avg BB Price 30 days

  • Avg BB Price 90 days

  • Avg BB Price 180 days

  • Price Dynamics, %

  • Total Offers

  • Avg AMZ BB Share 30 days, %

  • Avg AMZ BB Share 90 days, %

  • Avg AMZ BB Share 180 days, %

  • Alerts & Flags:

    • Oversize Flag

    • HazMat Flag

    • Meltable Flag

    • IP Complaints risk flag

    • Variation Flag

    • Set/Bundle Flag

  • Sales Tax, $

  • Sales Tax Rate, %
    depends on your extension settings

  • 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 Fixed, $

    • Misc Fee, $

  • 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

    • 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

    • 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

  • Product description and dimensions:

    • Model

    • Part Number

    • 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​

  • Supplier SKU

  • Supplier Case Qty

  • Marketplace

  • Keepa
    Link on Keepa

  • Original File Columns

Did this answer your question?