Imported data must be in a text file, using a CSV-based format (Comma-Separated Values) and the accompanying .csv file extension.
We recommend using a semicolon ";" as a field separator. If your text data (product description and such) contains semicolons, you should either remove them, or choose another field separator.
You can create a CSV file using any text editor (we recommend Notepad++: http://notepad-plus-plus.org/), but we do advise you to use a spreadsheet program, then save your work in the CSV format. Using a spreadsheet program enables you to have an easier and more visual grasp of your data, in comparison to the plain text file. You can use Microsoft Excel or the free OpenOffice.org software.
Here is a sample import file, with a list of products:
Note that this is only a sample file built for this demonstration; it is deliberately not optimized for PrestaShop import. If you need sample files you can base your own import files on, use the ones you can download from the window that appears when you click the "Upload" button.
The first row should be a descriptive name for the data column (you will be able to skip it during the import process). There must be the same number of columns on each row.
You should remember that:
The price column will use your store's default currency;
Categories are to be specified using their existing IDs (so you should have imported them first), and separated with a comma;
The URL of the images must be an absolute link. In other words, it should be the link that may be used in a web browser in order to display the image. For instance: http://www.myprestashop/images/productXXX.jpg;
The file's character encoding should be UTF-8. If not, use ISO-8859-1 and check the "ISO-8859-1 encoded file" option.
Dates use the ISO 8601 format, without a time zone designator (the time zone is the one for your store): 2013-06-21 15:07:27.