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, EANs and ASINs. If your price list uses other identifiers like SKUs or GTIN-8, 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: Unsupported column data
The "Identifier" and "Cost of Goods" columns must contain values that are recognized as numbers. If the column contain a formula, this will result in incorrect analysis and the product will be displayed with incorrect values.
Outcome 3: Empty rows in the file
If the uploaded file contains many empty rows, during the preliminary analysis the Price List Analyzer tool may count these rows toward the total number of identifiers. As a result, you might see an error that the identifier limit has been exceeded, even if it hasn't.
Before uploading the file, delete empty rows in your excel file and try uploading again.
Outcome 4: 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.