Configuring Price List for Analysis
Step 1. Go to your Seller Assistant personal account and find Price List Analyzer in the side bar menu
Note: In order to use Price List Analyzer you need to connect your Amazon Seller account
Step 2. Press "Upload" button and you will be directed to the window where you need to:
choose the marketplace you are working on
upload the file (.xlsx or xls.)
the file must not contain any other information than the one you want to analyze. For example: The tool will show an error if it won't be able to find any data in the first 15 rows
if the first 15 rows do not contain headers you can choose from - the tool will show an error
create the name or leave pre-filled one
Step 3. Choose the columns from your file representing:
Identifier - the column with UPC or EAN codes from your file (mandatory)
Options how to name this column in your file: “EAN”, “UPC”, “GTIN”, “Identifier”, “Barcode”
This column will be highlighted in the preview table
Cost of Goods - the column with the price on supplier site (mandatory)
Options how to name this column in your file: “Price”, “Cost”, “COG”; “minimum allowed price” is excluded
This column will be highlighted in the preview table
Title - any other column you want to include (optional)
Options how to name this column in your file: “Name”, “Title”, ”Product” “Description”
This column will be highlighted in the preview table
Note: If you choose the same columns for example: Identifier and Title refer to the same column in your file - you will see an error message.
The table preview screen reflects the actual information in the table, if you see an empty row, then the selected tab is empty, and if you see 1 row, it means that there is only 1 row of the data in the file.
If the first row is taken by any other information, you can choose the row with Identifier, Cost of Goods in the preview table manually (the chosen row will be highlighted).
Step 4. See the progress in your Personal account and download results by pressing the Exсel icon. If you want to delete the results — press red bin, just be aware that if you do so you will lose the results forever.
Example of the initial file
Here you can see an example how your initial file, which you are planing to download into Price List Analyzer, suppose to look like.
You might also find article "How to read Price List Analyzer results" useful.