Some Amazon analysis software require a specific format for files to be in in order to allow them to run successfully. Price Checker is different:
Price Checker supports .xls, .xlsx, .csv, and .tab (tab delimited) file formats |
Column order doesn’t matter |
Missing headers don’t matter |
Missing check digits don’t matter |
Spaces in IDs don’t matter |
Mixing of IDs is fine, too |
Prices can use comma or dot as decimal delimiter |
Single digit currency symbols in front of prices don’t matter |
The only thing we really ask is that your files contain proper columns, not ones that were created using visual formatting tricks.
Price Checker will attempt to auto-detect the type of Product ID and the cost column. If for some reason it got it wrong, you can change the column mapping before you start your run. See Run Settings
Occasionally company header and brand formatting above the data can interfere with column detection. The easiest workaround is to delete all rows above the actual product data and any blank columns to the left. |
Price Checker will bias its selection when it sees the following non-case-sensitive keywords in column titles:
For detecting column | Header Keywords, in order of preference | Additional notes |
|---|---|---|
Product ID | ASIN, EAN, UPC, ISBN, Keywords, SellerSKU, ID, Barcode, Bar Code | The first few values are also checked, and the most likely candidate selected (e.g. data format should be valid) |
Cost | My Cost, My Price, Net Cost, Cost, Special, Sale Price, Price, Amount Additions: ‘My’, ‘Case’, ‘Wholesale’, ‘WHSL’ | The presence of any of the additions will give more weight to that candidate column |
Wholesale Pack | Pack, Packaging, Case, Qty, Box |
Using these as the column title or part of the column title will make it more likely that the correct column is chosen.
Price Checker will attempt to correct Product Identifiers by automatically adding leading zeros and calculating missing check digits.
You can mix ID types within your file, as long as they are in the same column. Please note that this may have a small impact on throughput.