Importing Product Database Print

You can import product data into PrestaShop by using the Import tool (also known as a “bulk lister”).

At present, data can only be imported from .CSV (Comma Separated Value) files. 

For example:

You can import the following values (PrestaShop 1.1):

• ID
• Active
• Name
• Categories (x,y,z…)
• Prices
• Tax rate
• On sale
• Reductions
• Reference #
• Supplier reference #
• Supplier
• Manufacturer
• EAN13
• Weight
• Quantity
• Short description
• Description
• Tags (x,y,z…)
• Meta-title
• Meta-keywords
• Meta-description
• Text when in-stock
• Text if back-order allowed
• Image URLs (x,y,z…)
• Features

To import product data:

1. Open your .CSV file in any text editor software to identify the column separator used. In many cases this is a ;, but it can be almost any character, for example, , or :.
   • For example: In your .CSV file, one line of data reads:
     050-D821,Superman T-shirt,Red and white on a blue background,10.00,100
2. In Back Office >> Tools >> Import, browse to select the .CSV from your hard drive or network drive.
3. In the Column separator: field, type the character used to separate values in the .CSV file you will be importing.
4. Click Next Step.
5. On the next page, the ten first lines of your file are displayed to help you to set up the import. Select from the drop-down list above each column the value you want to attribute to the corresponding value.
   • Note: You must designate at least one column as “Name”.
   • Note: Data to be imported as “Price” and “Quantity” can only contain numbers (no currency symbols allowed).
     
6. To delete (ignore) a column, select Ignore this column in its drop-down list.
7. Click Import .CSV data.

Please note that the imported products are added to your current product database. No existing products are deleted. This means that you can successively add .CSV files if desired.

As of PrestaShop v1.1, the quantity discounts are not importable using the Import tool.

Importing attributes

Attributes data can only be imported from a separate .CSV file.

You can import the following values:

• Product ID
• Options (group1:attribute11,group2:attribute21…)
• References
• EAN13
• Prices
• Ecotax
• Quantity
• Weight
• Default

Groups and attributes will be added automatically if they do not already exist.

Example:
id_product ; options ; reference ; supplier_reference ; ean13 ; wholesale_price ; price ; ecotax ; quantity ; weight ; default 1;Length:120,Width:140;AB11242;15472C;1234567890123;120;900;5;10000;5;1 1;Length:100,Width:160;AB11243;15473C;1234567890124;120;900;5;10000;5;0