The Price List Analyzer is a powerful tool designed to process supplier price lists efficiently. However, achieving optimal results requires attention to specific details.
Here are key outcomes and tips to guide you:
Outcome 1: Unsupported Identifiers
Price List Analyzer processes files based on UPCs and EANs. If your price list uses other identifiers like SKUs or ASINs, or you choose another column with numeric or alphanumeric values, the tool will still process the file, however, the results will include only the data already provided in the original price list, such as:
Identifier
Product titles
Categories
Brands
Prices
Outcome 2: Excel Formatting Issues
Spreadsheets like Excel and Google Sheets may treat numeric values as numbers and remove leading zeros (e.g., 012345678912 becomes 12345678912). This can corrupt identifiers (UPCs and EANs) and lead to incomplete or inaccurate results.
To fix this, you will need to:
1. Identify Affected Rows
Create a new column next to your identifier column.
Use the formula
=LEN(A1)
to calculate the length of each identifier.Filter the results to identify rows where the length is less than 12 (for UPCs) or 13 (for EANs).
2. Convert to Text Format
Select the identifier column.
Change the Data Type to Text before proceeding.
3. Restore Leading Zeros
Create one more column.
Use the formula to add leading zeros
="00" & A1
.Drag the formula down to apply it to the entire column.
Copy and paste the results as values, replacing the values in the original column.
Outcome 3: Unsupported upload file formats
The Price List Analyzer only supports files in .xlsx or .xls formats.
If your price list file is in a format other than the supported ones (e.g., .csv or .xml), you need convert it to .xlsx or .xls formats before uploading it to Price List Analyzer.