Import

BackOffice>>Tools>>Import

THIS SECTION IS INCOMPLETE

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.

Theer are seven types of CSV files you can import which includes;

Categories | Products | Attributes | Customers
Addresses | Manufacturers | Suppliers

For each CSV type, you can import the following values (From PrestaShop 1.1):

Categroies

    * ID
    * Active (0/1)
    * Name
    * parent categroy
    * Description
    * meta-title
    * meta-keywords
    * Meta-description
    * URL rewrited
    * Image URL

Products

    * ID
    * Active (0/1)
    * Name
    * Categroies (x,y,z)
    * Price tax excl. or Price tax incl.
    * Tax rate
    * Wholesale price
    * On sale (0/1)
    * Reduction amount
    * Reduction percent
    * Reduction from (yyyy-mm-dd)
    * Reduction to (yyyy-mm-dd)  
    * Reference #
    * Supplier reference #
    * Supplier
    * Manufacturer
    * EAN13
    * Ecotax
    * 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

Attributes

Customers

Addresses

Manufacturers

Suppliers

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).

IMAGE

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