If you're having a problem importing or exporting your products CSV, check this article to see if we've got a solution. If you can't find your issue listed, please get in touch and we'll look into it for you.
This article includes:
- CSV downloaded and opens as text in a new browser window
- Product descriptions including HTML when importing
- Header title's can't be blank
- Invalid characters in row ****
- Invalid characters in number fields
- Inventory is importing as blank
- Barcode / UPC looks strange after importing
CSV downloaded and opens as text in a new browser window
Once you're exported products are ready and you've selected 'DOWNLOAD' from the new notification in the top right of the navigation bar, the file may open with all the data as a text file. If this happens, you need to save this to create the CSV file by selecting CMD + S (for mac) or CTRL + S (for windows).
Product descriptions including HTML when importing
If you've exported your products leaving the 'do not export description column' unchecked, your products would have exported with their full descriptions in the CSV. This would include any HTML descriptions.
If you edit your exported CSV to update your products in bulk, when re-importing the CSV the extra characters (such as < , > , / ) from the HTML descriptions will cause the upload to fail.
Header title's can't be blank
Header names can't be blank on the first line of your CSV. The first line of your CSV header should look like:
Remember to check for extra white spaces at the end of the first line.
Invalid characters in row ****
This error is caused by invalid characters included in the CSV you're trying to import. To fix this, check your CSV file is UTF-8 encoded or go through the file and remove the invalid characters (e.g. ?, !, #). Dashes ( - ) are accepted.
To enable UTF-8 encoding, open the file in Notepad and when you save it, make sure that UTF-8 encoding is specified in the save dialog.
Invalid characters in number fields
Your CSV either has letters or is blank where the file is expecting numbers. Please check the fields have the correct characters. For example, when adding a product price if a currency symbol (£) is used this will cause an error.
Inventory is importing as blank
If you've left the 'total_qty' column blank or removed it from your CSV file, the column will be ignored when importing.
Barcode / UPC looks strange after importing
If you've noticed your Barcode / UPC is no longer working or looks strange, it may be due to the decimal places setting in your spreadsheet editor.
To check if your decimal places setting is at 0 for the Barcode / UPC column, open the CSV in Excel. If your Barcode / UPC column looks similar to the screenshot below, select the column. Right click one of the cells and select 'FORMAT CELLS'. Select 'NUMBER' from the category column, set the 'DECIMAL PLACES' to 0 and hit 'OK'.