Importing - FAQ

Q: Why won't my file import ?

A: Usually this is because the file is in the wrong format. The most common cause is that the file is not comma delimited, and is in fact semi-colon or tab delimited.

You can verify that this is the case by opening the file in a text editor such as Notepad or Wordpad. Each "column" in the file should be separated by a comma. For example, if the first line of the file is something along the lines of;

Then the file is semi-colon delimited and needs to be converted.

Another common cause of issues is if you are a Mac or Linux user. Mac or Linux surprisingly save CSV files out of spec with regards to the linebreaks, so these fail to import too.

This can be easily corrected on either platform. Linux users (and possibly Mac users too) can use the unix2dos command line utility to convert the file. After that, the file should import correctly.

For Mac users only, there is some free software that can be downloaded from the following link;

You can run the file through this software, and this will also correct the linebreaks.

Q: How can I convert my file using OpenOffice or LibreOffice ?

A: Open the file and make sure it's showing properly, with each field in a separate column. Choose "Save As" from the "File" menu and ensure that the Format is set to "Text CSV (.csv). Tick the "Edit filter settings" checkbox, then click "Save".

If you're prompted to overwrite the file, either choose Yes, or change the file name after selecting No and carry on.

If prompted to Confirm File Format, select "Use Text CSV Format".

At the Export Text File prompt you should be able to leave everything as it is, apart from the "Field Delimiter". Ensure that this is set to a comma (,), then click OK to save the file.

If using Linux or Mac OSX, don't forget to convert the linebreaks as above, then you should be ready to import.

Q: I've tried all the above, but it still won't import. What can I do ?

A: Please email the file you're trying to import to from the email address that your store is registered with, and we'll be happy to take a look at it for and point you in the right direction.

Please note that we can not perform imports on your behalf.