Configuring Price List for Analysis
Step 1. Go to your Seller Assistant personal account and find Price List Analyzer in the side bar menu.
Step 2. Press "Upload price list" button.
You will be directed to the window where you need to:
Choose the marketplace you are working on
Note
Price List Analyzer doesn't support all marketplaces. You can view a list of supported marketplaces in this article.
Upload the file (.xlsx or .xls)
Note
If you encounter difficulties when uploading a file in .xls format, we recommend saving your document in the new .xlsx format and using it to work with Price List Analyzer.Mark "Add all ASINs from this price list to the Products database" checkbox if you want to automatically add the analyzed products to the Product database.
Notes
Select the checkbox before uploading. Adding ASINs to the Products database cannot be turned on later for a price list that is already analyzed.Create the name or leave a pre-filled one
Add the supplier's name or link for reference (optional)
You can create a new supplier directly at this step
You can also change the Cost Settings specifically for this price list by clicking the
button. In the opened window, configure all necessary expenses and fees.
Select the Price type for the prices in your file:
Each – by default. The price in your file is the price of one unit.
Case – the price in your file is the price of one case. The cost of one unit is the case price divided by Supplier Case Qty. If a product has no Supplier Case Qty, its price is used as it is.
Select the Selling Price Calculation Method on which your profit will be calculated. There are four options to chose from:
Current BuyBox Price – by default
Average BuyBox Price for 30 days
Average BuyBox Price for 90 days
Average BuyBox Price for 180 days
Note
If there is no data for 180 days, then data for 90 days is used, then for 30 days, and then the current BuyBox Price.
Step 3. Select a tab.
If you upload multi-tab file, start by choosing the tab you want to analyze
Price list preview screen displays up to 15 rows of data. If fewer rows are shown, it means the uploaded file or selected sheet contains less than 15 rows. The number displayed matches the actual number of rows in your file.
Step 4. Select a header row.
Then, select the row containing the column titles or any other row you'd like to use as a starting point for analysis (the chosen row will be highlighted).
Step 5. Map the columns.
After header row is selected, the system will automatically fill mapping options:
Identifier – the column with one of tree types of code or any combination of these codes from your file:
UPC (Universal Product Code) – standard for coding products in retail trade. The code is a number consisting of 8 or 12 digits.
EAN (European Article Number) – European barcode standard designed to encode product. The code is a number consisting of 8 or 13 digits.
ASIN (Amazon Standard Identification Number) – unique identifier assigned by Amazon to each product.
Cost of Good – the column with the price
Title – any other column you want to include
Supplier SKU – the column with supplier's internal product code
Supplier Case Qty – the column with the number of units per case from supplier:
Mapping this column sets the Price type of this price list to Case, unless you have saved a default Price type in Cost Settings. You can change the Price type back to Each at any time.
If a cell contains text, the first number in it is used, for example 12 in "12 pcs". If a cell is empty, or has no whole number of 1 or more, the Supplier Case Qty is 1.
After the analysis you can change the Supplier Case Qty of any product in the price list table.
Title, Supplier SKU and Supplier Case Qty are optional: if you do not need one of them, click the cross in its field to clear the selected column. Identifier and Cost of Good are required.
Note
If the identifiers don't match the expected UPC/EAN/ASIN format, you may encounter issues after processing. Learn more about preventing such errors here.
Once selected, these column will be highlighted in the preview table.
Keep in mind, some columns may not be automatically mapped. Since Identifier and Cost of Goods fields are required to proceed, make sure to carefully review and adjust the pre-selected columns if necessary.
Note
Identifier and Cost of Good fields should have unique columns mapped to them, otherwise, you will be unable to proceed with analysis.
Below the mapping fields, the Price settings block defines how the prices in your file and your profit are calculated for this price list. The same two settings are in Cost Settings in Step 2:
Price type – Each or Case. Select Case if the prices in your file are case prices. The cost of one unit is then the case price divided by Supplier Case Qty.
Selling Price Calculation Method – the price your profit is based on: Current BuyBox Price, or the average BuyBox price for 30, 90 or 180 days.
Step 6. Analyze.
After you click Analyze Price List, you will be able to see the progress in your Personal account. You can open the price list clicking on the Price List line without waiting for the analysis to finish and work with products that have already been processed.
When the tool finishes processing your file, you will receive an email notification and you will be able to download results by pressing the "Export results" in the actions menu.
If you want to delete the results – press "Delete" in the actions menu, just be aware that if you do so you will lose the results forever.
Example of the initial file
Here's an example of how your initial file should be formatted before uploading it to Price List Analyzer
You might also find article "How to read Price List Analyzer results" useful.