Price List Analyzer by Seller Assistant

As a seller who deals with huge supplier price lists of thousands of products, it can be challenging to quickly spot profitable deals to sell on Amazon. If you have many suppliers who often introduce new products, you must process the price lists fast. Your task is to match supplier products to Amazon and find out if they will be profitable.

Seller Assistant's Price List Analyzer helps automate supplier price list processing and identify the most high-margin items for your Amazon store in minutes.

In this post, we will explore how Price List Analyzer works and help you easily identify the best deals among thousands of your supplier products.

Note. Seller Assistant is a comprehensive product-sourcing software that helps Amazon sellers quickly find high-profit deals. It combines three extensions: Seller Assistant Browser Extension, IP-Alert Chrome Extension by Seller Assistant, and VPN by Seller Assistant, Amazon seller tools: Price-List Analyzer, Bulk Restrictions Checker, Seller Spy, API and features: Side Panel View, FBM&FBA Profit Calculator, Quick View, ASIN Grabber, Stock Checker, IP Alert, and Restrictions Checker. Great for Wholesale, Online Arbitrage, and Dropshipping.

Seller Assistant shows all essential product data on Amazon search, product, and inventory pages, and on any website to help you find high-margin deals. By using this FBA and FBM product sourcing software, you can easily identify products that have the potential to be sold well on Amazon.

What Is Seller Assistant’s Price List Analyzer?

Price List Analyzer by Seller Assistant is a bulk Amazon product analyzer tool that finds profitable deals. Its primary function is to automate research of supplier price lists and efficiently identify the most profitable products to sell on Amazon.

The tool is designed specifically for Amazon wholesale and online arbitrage sellers, and dropshippers to simplify the process of evaluating the profitability of products, and helps make informed decisions quickly and efficiently.

Price List Analyzer Functionality

Price List Analyzer by Seller Assistant simplifies the complex process of managing supplier data for product sourcing by providing you with the functionality and data described below.

UPC/EAN to ASIN conversion

Converts UPC or EAN codes to Amazon Standard Identification Numbers (ASINs), exactly matching each supplier product to its corresponding Amazon listing.

Product identification and details

• ASIN

Amazon Standard Identification Number for the product

• Link

Direct link to the product listing on Amazon

• Product image

Visual representation of the product

• Title

Product name or title as it appears on Amazon

• Brand

Manufacturer or brand of the product

• Category

The product’s category on Amazon

• Model, manufacturer, part number

Specific details related to the product's manufacturing necessary to match the product to supplier catalog

Sales performance metrics

• BSR (Best Sellers Rank)

Indicator of the product's sales ranking within its category. Shows how well the product sells

• Top BSR

Top helps understand the product’s sales velocity as a percentage. If the Top equals 0.5% or less, the product sells well. If the Top equals 1% or more, a product is a slow-mover

• Sales Estimate (pcs/month)

Estimated number of units sold per month. Helps understand average product sales to estimate how many units to order

• Sales Estimate ($/month)

Estimated revenue per month from product sales. Helps understand how much money you can potentially earn from product sales/month

Pricing and profitability

• COG (Cost of Goods)

Cost of goods before tax. Product price at the supplier

• Cost of Goods incl. VAT

Total cost including VAT

• Buy Box price

Current price of the product winning the Buy Box on Amazon

• Break-Even price (FBA/FBM)

The minimum product price with 0% profit for Fulfillment by Amazon (FBA) or Fulfillment by Merchant (FBM). If you go below break-even threshold, you lose money on the product 

• Profit (FBA/FBM)

Estimated profit per unit using FBA or FBM fulfillment methods. Shows how much money you earn on the product

• ROI (FBA/FBM, %)

Return on investment for FBA or FBM orders, as a percentage

• Margin (FBA/FBM, %)

Profit margin after costs, expressed as a percentage

Fulfillment costs

• Total FBA/FBM fees

Overall fees associated with FBA or FBM services

• FBA fees

Fulfillment by Amazon fees

• Referral fee

Amazon's percentage-based fee on the sale

• Storage fees

Cost to store the product in Amazon’s warehouse

• Variable Closing Fee

A fee applied for books, music, video, blu-ray, and DVDs (BMVD) on top of other fees

• Inbound shipping costs (FBA)

Cost of shipping the product to an Amazon warehouse (for FBA) 

• Prepare/labeling cost (FBA/FBM)

Cost for preparing or labeling the product for shipment

• Fragile/bubble wrapping (FBA/FBM)

Additional cost if the product requires special packaging for fragility

Tax and compliance

• VAT on fees 

Value-Added Tax applied to fees. Applicable if you sell internationally

• Sales tax rate (%)

Applicable sales tax rate

• Sales tax

Total sales tax applied to the transaction

• Apply sales tax

Option to apply sales tax to the product or not

• VAT on fees rate (%)

Percentage of VAT applied to fees

Product restrictions and flags

• Warning

Shown if the product has any alerts, for example: no FBA Fees, no Buy Box price, no COGs, ASIN not found, set or bundle, approval required, too low FBA ROI, too high FBA ROI. For such products, more detailed research is required

• Oversize flag

Marks if the product is considered oversize by Amazon

• HazMat flag

Indicates if the product is classified as hazardous material

• Meltable flag

Alerts for products that can melt in certain conditions

• Fragile flag

Marks fragile products requiring special handling

• IP complaints flag

Indicates the risk of intellectual property complaints

• Variation flag

Denotes if the product has multiple variations (size, color, etc.)

• Set/bundle flag

Marks if the product is part of a set or bundle

Dimensions and Packaging

• Height, width, length, weight (in/cm/lbs/kg)

Physical dimensions and weight of the product, useful for calculating shipping costs

• Product volume (cu ft/cu cm)

The product's volume, helpful for storage and shipping calculations

• Package quantity

Number of units in a package

Additional identifiers

• UPC, EAN, GTIN

Global Trade Item Numbers used for identifying the product in various marketplaces

• Parent ASIN

The parent ASIN, if the product has multiple variations

Benefits of Price List Analyzer

The Price List Analyzer by Seller Assistant offers a number of benefits that can significantly enhance the efficiency and simplify product sourcing for Amazon sellers. Here are some of the key advantages.

Automated deal identification

The tool automates the conversion of UPC/EAN codes to ASINs, helps detect high-margin leads by showing product profitability and ROI, saving sellers countless hours of manual work.

Smart bulk sourcing

Quickly process up to 50,000 supplier UPCs/EANs in one click to uncover potential opportunities in bulk. Apply advanced filtering and sorting to refine your product searches by profit, sales volumes (BSR), and other metrics.

Accurate profitability insights

Focus on products with higher profit margins, maximizing your return on investment. The tool provides accurate profit and margin calculations, helping sellers understand the true profitability of each product.

Product performance estimations 

The Price List Analyzer provides essential insights into product performance, including how well the product sells, its potential sales volume, and sales velocity (how fast it sells). By analyzing metrics like Best Sellers Rank (BSR) and monthly sales estimates, sellers can accurately gauge a product's market demand and make informed decisions on inventory stocking and pricing strategies.

Product flags and warnings

The Price List Analyzer automatically detects and flags potential issues with products, alerting sellers to important factors that require attention. These flags include oversize, HazMat, meltable, fragile products, and those with IP complaints, variations, or sets/bundles. Warnings include "No FBA Fees," "No Buy Box Price," "No COGs," "ASIN Not Found," "Set or Bundle," "Approval Required," "Too Low FBA ROI," and "Too High FBA ROI." For flagged products, more detailed research is needed to address these issues and ensure profitability. This feature helps sellers avoid costly mistakes and compliance issues.

Data-driven sourcing decisions

Access key metrics on a large scale, like profitability and costs. Make informed choices about product selection, reducing the risk of choosing low-profit or slow-moving items. 

Identifying bulk product restrictions and brand gate

Upload the data you obtained with the Price List Analyzer to Seller Assistant’s Bulk Restrictions Checker and quickly identify in bulk restricted products and brands, and your eligibility to sell on Amazon the products from your supplier lists.

Price List Analyzer Use Cases 

Price List Analyzer simplifies bulk product research and helps you make informed sourcing decisions by quickly choosing profitable deals. Here are some practical use cases to consider.

Profitable deal finder

The Price List Analyzer converts UPCs or EANs to Amazon ASINs and calculates profitability metrics like profit and ROI. This allows sellers to quickly identify the most profitable deals and focus on the most promising of them.

Use case

Sellers need to quickly identify which products offer the highest profitability from their supplier’s price list. By converting UPCs or EANs to ASINs and calculating metrics like profit and ROI, sellers can focus on the most promising deals.

Solution

The Price List Analyzer streamlines this process by providing immediate insights into the most profitable products, allowing sellers to concentrate on high-return opportunities.

Comprehensive supplier analysis

Wholesale sellers can upload a price list from their existing suppliers into the Price List Analyzer to get a detailed report with detailed product metrics such as profit, ROI, and BSR. They can then filter products by these metrics to choose the most suitable items for their inventory.

Use case

Wholesale sellers often need to analyze large price lists from their suppliers to find the most profitable products. They require a detailed report with important metrics like profit, ROI, and BSR to make informed decisions.

Solution

The Price List Analyzer allows sellers to upload price lists, filter the results by key metrics, and choose the most suitable products for their inventory, simplifying the decision-making process.

Bulk restrictions and brand gate check

Using the Price List Analyzer with Seller Assistant’s Bulk Restriction Checker allows sellers to see product and brand gate restrictions in bulk, and their eligibility to sell on Amazon the products their account. You can additionally upload your product list to Bulk Restriction Checker and check bulk products for restrictions.

Use case

Sellers need to ensure that their products meet Amazon’s eligibility requirements, particularly in bulk, when dealing with product restrictions or brand gate issues.

Solution

By integrating the Price List Analyzer with Seller Assistant’s Bulk Restriction Checker, sellers can easily upload a product list and verify which products are restricted, ensuring they comply with Amazon’s policies.

Product performance estimation 

Use case

Sellers need to evaluate how well a product is performing in terms of sales velocity, market demand, and potential profitability. Analyzing metrics like BSR and monthly sales estimates is essential for making informed stocking decisions.

Solution

The Price List Analyzer provides sellers with essential data on product performance, helping them optimize inventory management by focusing on high-demand products.

Risky products identification

Use case

Sellers need to be alerted to potential issues with products, such as missing fees, no Buy Box price, ASIN not found, or approval required. These flags help prevent costly mistakes and ensure product viability.

Solution

The Price List Analyzer automatically detects and flags issues like "No FBA Fees," "No COGs," or "Too Low FBA ROI," enabling sellers to conduct further research and avoid risky products.

Fetched data analyzer

Use case

Online arbitrage sellers and dropshippers need to identify profitable products from various e-commerce websites. They require a tool that matches fetched products to Amazon listings and calculates profitability.

Solution

The Price List Analyzer enables sellers to upload scraped data, find matching ASINs, and analyze profitability, helping them add the most profitable products to their sales pipeline.

New supplier finder

The Price List Analyzer helps sellers find new suppliers by analyzing multiple price lists for profitability and other key metrics. This allows sellers to compare different suppliers and choose those that offer the best deals and align with their business goals.

Use case

Sellers looking to expand their supplier network need to compare multiple price lists to identify the most profitable partnerships. Analyzing metrics like profit and ROI helps in choosing the best suppliers.

Solution

The Price List Analyzer enables sellers to upload and compare different price lists, helping them find new suppliers that align with their profitability goals and business strategy.

How Does Price List Analyzer Work? 

With Price List Analyzer, you can automate processing bulk price lists. The tool automatically matches your supplier products to Amazon, calculates profitability for each product, and shows other essential metrics. You can filter the results by any metric you need.

To process a price list with Price List Analyzer, upload your price list and download .xls files with potentially profitable deals.

You can access the Price List Analyzer in your Seller Assistant personal account. From there, you can add your supplier price lists and download .xls files with the reports. 

Analyzing supplier price lists with Price List Analyzer step-by-step

Step 1. Access Price List Analyzer

Open your Seller Assistant personal account and access Price List Analyzer.

Step 2. Upload your wholesale price list 

Click the “Upload” button, choose your marketplace, drag or select your prepared Excel file with a wholesale list, and add the file name to quickly spot the processed results.

Step 3. Set up your wholesale list for processing

To ensure correct data display, it is important to map your wholesale list, choose the columns in your file with UPC/EAN, supplier price (COG), and product title (optional). Also, map the starting row for data processing.

• Select the Excel file sheet

If your wholesale list has multiple sheets, in the dropdown, select the one you want to process.

• Select the starting row for data processing

Price List Analyzer shows your table preview so that you can correctly map the table. Mark the first row in your table to start processing your data. The starting row must not be empty and must contain all data you want to process.

• Map the key column headers

Select the columns in your file containing the UPC/EAN codes, product prices, and titles (optional). The columns you must map are highlighted in the preview table. From the dropdown in the corresponding fields, choose your option:

• Identifier: “EAN,” “UPC,” “GTIN,” “Identifier,” or “Barcode” 
• Cost of Goods: “Price,” “Cost,”  or “COG”
• Title: “Name,” “Title,” ”Product,” or “Description.”

• Start price list processing

Click the “Analyze price list” button to start processing.

Note. To ensure you correctly map your wholesale list, do one of the following or both:

• Download the file example to see how it should look like 

• Read the help article to ensure it’s mapped correctly.

Step 4. Get the Price List Analyzer results

Once the analysis is complete, you’ll receive a detailed report with all the metrics for each product. Download the .xls file with the report.

Report data:

• ASIN
• Link
• Product image
• Title
• Brand
• Category
• Model, manufacturer, part number
• BSR (Best Sellers Rank)
• Top BSR
• Sales Estimate (pcs/month)
• Sales Estimate ($/month)
• COG (Cost of Goods)
• Cost of Goods incl. VAT
• Buy Box price
• Break-Even price (FBA/FBM)
• Profit (FBA/FBM)
• ROI (FBA/FBM, %)
• Margin (FBA/FBM, %)
• Total FBA/FBM fees
• FBA fees
• Referral fee
• Storage fees
• Variable Closing Fee
• Inbound shipping costs (FBA)
• Prepare/labeling cost (FBA/FBM)
• Fragile/bubble wrapping (FBA/FBM)
• VAT on fees 
• Sales tax rate (%)
• Sales Tax (Y/N; amount)
• VAT on fees rate (%)
• Warnings
• Oversize flag
• HazMat flag
• Meltable flag
• Fragile flag
• IP Complaints flag
• Variation flag
• Set/bundle flag
• Height, width, length, weight (in/cm/lbs/kg)
• Product volume (cu ft/cu cm)
• Package quantity
• UPC, EAN, GTIN
• Parent ASIN

Step 5. Filter results. Use the filters available in Excel tables to sort products by metrics like profit, ROI, or BSR to easily identify the best deals.

FAQ

What is the Price List Analyzer and how does it work?

The Price List Analyzer is a tool designed for Amazon sellers to analyze supplier price lists quickly and efficiently. It converts UPC or EAN codes into Amazon ASINs and calculates key metrics like profit, ROI, and various fees to help sellers identify the most profitable products.

What file formats does the Price List Analyzer support?

The Price List Analyzer supports Excel (.xlsx) and .csv file format. Before uploading, make sure your file has columns clearly labeled for UPC/EAN codes and product prices.

What metrics does the Price List Analyzer calculate?

The tool calculates several important metrics, including Buy Box price, FBA fees, referral fees, storage fees, profit, ROI, and Best Sellers Rank (BSR). These metrics provide a comprehensive view of a product's profitability and market performance.

Can I use the Price List Analyzer for wholesale?

Yes, the Price List Analyzer is useful for wholesale. You can upload price lists from your suppliers and the tool will automatically show you profitable deals. That helps make informed decisions on which products to sell.

How can I ensure my analysis is accurate?

To ensure accurate analysis, make sure to upload a file with correctly labeled columns for UPC/EAN codes and prices. Verify that the data you input is up-to-date and reflects current market conditions for the most reliable results.

Final Thoughts

As an Amazon seller, it is important to constantly add new products. However, selecting profitable deals from thousands of products in your supplier price list is quite a challenge. 

Seller Assistant's Price List Analyzer can automate this process, allowing you to quickly identify the most high-margin products in your supplier list.

‍Seller Assistant is an all-in-one product sourcing software offering all the features vital for product sourcing. It combines three extensions: Seller Assistant Extension, IP Alert, and VPN by Seller Assistant, tools: Price List Analyzer, Brand Analyzer, Seller Spy, Bulk Restrictions Checker, and API integrations, and features: Side Panel View, FBM&FBA Profit Calculator, Quick View, ASIN Grabber, UPC/EAN to ASIN converter, Stock Checker, and other features that help quickly find high-profit deals. Seller Assistant also offers integration with Zapier allowing to create custom product sourcing workflows.