Skip to main content
All CollectionsToolsPrice List Analyzer
How to Ensure Accurate Results with Price List Analyzer
How to Ensure Accurate Results with Price List Analyzer
Arianna Borodinova avatar
Written by Arianna Borodinova
Updated over a week ago

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.

Did this answer your question?