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" button.
You will be directed to the window where you need to:
Choose the marketplace you are working on
Note
Only marketplaces supported by Keepa are available for selection. You can find a list of these 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.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 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 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
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.
Step 6. Analyze.
After you click Analyze Price List, you will be able to see the progress in your Personal account. When the tool finishes processing your file, you will be able to open results clicking the button Open or on the number in column ASINs or download results by pressing the download in the status column.
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's an example of how your initial file should be formatted before uploading it to Price List Analyzer
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.
You might also find article "How to read Price List Analyzer results" useful