User Guide
customers,
addresses,
manufacturers,
suppliers.
Have a good look at the exemple displayed on the page. You will have to
create a relationshop between the contenu of your columns, and the
location of the data in the PrestaShop catalog.
Data format
Imported data file must be in text-file, using a CSV-based format (Coma
Separated Value), and the accompanying .cvs file extension. We
recommend using a semicolon ";" as a separator.
You can create such a file using any text editor (we recommend
Notepad+\+), but we do advise you to use a spreadsheet program, such
as the commercial Microsoft Excel or the free software OpenOffice.org
Calc, 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.
Here is a sample import file, for a list of products:
"Enabled";"Name";"Categories";"Price";"Tax rule ID";"Buying price";"On
sale";"Reference";"Weight";"Quantity";"Short desc.";"Long desc";"Images
URL"
1;"Test";"1,2,3";130;1;75;0;"PROD-TEST";"0.500";10;"'Tis a short
desc.";"This is a long
description.";"http://www.myprestashop/images/product1.gif"
0;"Test 02";"1,5";110;1;65;0;"PROD-TEST2";"0.500";10;"'Tis also a short
desc.";"This is a long description
too.";"http://www.myprestashop/images/product2.gif"
1;"Test 03";"4,5";150;1;85;0;"PROD-TEST3";"0.500";10;"'Tis a short desc.
again";"This is also a long
description.";"http://www.myprestashop/images/product3.gif"
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 will note 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 image must be specified in full. In other words, the
link that may
be used in a web browser to display the image. Example:
http://www.myprestashop/images/productXXX.gif
File encoding should be UTF-8, or ISO-8859-1 at worst.
