There are some common reasons why your bulk imports into RepricerExpress might fail or be rejected.
We would recommend reviewing these before creating your file, to ensure you get everything updated first time.
1. Import files layout/Invalid headers (Global Min/Max Vs Channel Min/Max):
The layout of the bulk import file is fixed, that means that all headers and columns must remain exactly as in the template. If you remove columns or change headers then the file will fail to import. The headers should always be as in the images below, depending on the set up you have:
Global Min/Max format:
Channel Min/Max format:
As you will see the two file formats are distinctly different. If you are unsure of which format your account uses you can download the correct file format on the 'Imports/Exports' screen:
2. Extra 'invisible' column in the file:
Sometimes it can happen that the spreadsheet programme you use will add an 'extra column'. You won't necessarily notice it but this will make your import fail. All you need to do is copy your file in a brand new spreadsheet, making sure that you stopped at the 'Max Price' column, as shown in the example below:
3. Import files format
The format of the bulk import file must be .CSV (comma delimited). Please select this option when saving your file within your spreadsheet software.
As the file is a .CSV (Comma Separated Values) file, commas are used by the system to determine where one column ends and another begins. This means if you include commas in your titles or any other fields this will cause the file to fail. Please remove all commas (,) before attempting to import your file.
5. Required fields are missing
Both bulk import files have their own required fields. Unless the required fields are filled in with data then the import will reject that product line. Below are the required fields for each import.
- Min/Max import: SKU, Min & Max.
- Fixed Price imports: All fields are required.
6. Corrupted Merchant SKUs
When you open a spreadsheet, the program tries to read a very long number (e.g. a barcode or UPC) it will display it incorrectly (e.g. 9.07895E+17). If any of your merchant SKUs are very long numbers you must reformat this column to be a number.
To do this follow the steps below (see video for process).
- Select the column header (where it says A, B, C etc.)
- Right click and select 'Format cells'
- On the 'Number' tab select "number" from the 'Category list'
- Change the 'Decimal places' to '0' then press 'OK' to apply this
Your number will then appear correctly. You must do this before saving your file otherwise, the number will be permanently corrupted.
7. Non-numbers in price fields
It's important when you are updating your Min and Max prices, especially if you're using Excel functions to ensure that only numbers are in these fields. If you have letters or special characters in the Min or Max price fields this will stop the file importing correctly. A common example would be if you use 'VLookup' and leave #N/A in this field.
8. European Regional Settings
RepricerExpress uses default English Language Regional Settings for our imports. This means that columns in imports need to be separated by a comma (,). Many European countries use Regional Settings which use a semicolon (;) rather than a comma.
If your PC uses one of these European Regional Settings it will cause your imports to fail, this help file will show you what steps to take to change your PCs Regional Settings to use a comma rather than semicolon.
- Select Start > Control Panel > Regional and Language Options.
- Click Additional Settings.
- For List Separator enter a comma (,) rather than a semicolon (;).
- Update and you’re done.