[contact-form-7 id="24078" title="Feedback EN"]

Featured templates

PrestaShop 1.6.x. How to create .CSV file for products import

In this tutorial we will show you how to create a .CSV file for PrestaShop. Using this .CSV file you will be able to import Products and Categories to the store.

PrestaShop 1.6.x. How to create .CSV file for products import

Before we proceed, we need to install the program which will be used to edit the .CSV file.

We recommend using OpenOffice Calc program.

Downloading required software

  1. Follow this link to download the OpenOffice program: https://www.openoffice.org/.

  2. Click on I want to download Apache OpenOffice link.

  3. On the next page, select your OS and language, then click on Download Full installation button:

    prestashop_how_to_create_csv_1

  4. In the next window, click on Save File button:

    prestashop_how_to_create_csv_2

  5. Once it is done, go to the file download location and proceed with OpenOffice program installation.

Creating .csv files

  1. Download the sample prestashop_example_products.csv file using this link.

  2. Open prestashop_example_products.csv file using OpenOffice Calc program.

    The Character set should be Unicode (UTF-8).

    The Semicolon option should be checked by default. Otherwise, please select the Semicolon option.

    Click OK button to proceed:

    prestashop_how_to_create_csv_products_3

  3. The .CSV file should have the following fields. The following fields are required to import products:

    • Active (0 = No, 1 = Yes) – defines whether this product is active or not. Use 0 for inactive and 1 for active.

    • Name – full product’s name that will be used by your client for product selection. Product Name should not be more than 128 symbols.

    • Categories (x,y,z…) – in this field put the category Name.

    • Price – the value the product is on sale for and for which it can be obtained by the shopper. Should include only numbers with a dot to separate the decimals. This field should not be empty.

    • Quantity (stock) – required to be more than 0 in order to show your products.

    • Minimal quantity (to order) – should not be less than 1.

    • Short description – more concise description of the product that customers will immediately see viewing the product description page. Should not be more than 400 symbols.

    • Description – should contain the information that advertises item and will help a client learn about the product.

    • Available for order (0 = No, 1 = Yes) – defines whether this product is available for order or not. Use 0 for not available and 1 for available.

    • Show price (0 = No, 1 = Yes) – defines whether you wish to show or hide the product price.

    • Image URLs (x,y,z…) – should contain the URL to your image(s). For example: http://domain.com/images/name.jpg

      Note: If you do not have Product Images, simply leave “Image URLs” field empty.

  4. The following fields are optional:

    • Reference # (optional)

    • Supplier reference # (optional)

    • Supplier (optional) – will require additional .CSV file (suppliers_import.csv).

    • Manufacturer (optional) – will require additional .CSV file (manufacturers_import.csv).

    • EAN13 (optional)

    • UPC (optional)

    • Width (optional)

    • Height (optional)

    • Depth (optional)

    • Weight (optional) – indicate the value for weight as it may be used to calculate shipping cost. Leave empty for no value:

      prestashop_how_to_create_csv_products_4

  5. Download the sample prestashop_example_categories.csv file using this link.

  6. The second file is required to import Categories. Open prestashop_example_categories.csv file using OpenOffice Calc program:

    prestashop_how_to_create_csv_categories_1

  7. The .CSV file should have the following fields. The following fields are required to import Categories:

    • Active (0 = No, 1 = Yes) – defines whether this product is active or not. Use 0 for inactive and 1 for active.

    • Name full Category name. Name should not be more than 128 symbols.

    • Parent category – Parent category Name. Should not be empty.

    • Root category (0/1 – Should be 0.

  8. The following fields are optional:

    • Description – should contain the information that advertises Category;

    • Meta title;

    • Meta keywords;

    • Meta description:

      prestashop_how_to_create_csv_categories_2

  9. When you are done, go to File -> Save As. Keep the Text CSV (.csv)(*.csv) type. Check the Edit filter settings option.

    Then click Save button:

    prestashop_how_to_create_csv_products_5

  10. In the popup window, make sure to select the Character set: UTF-8. Select the semicolon field delimiter.

    Click OK:

    prestashop_how_to_create_csv_products_6

This is it. Now we have a correct .CSV file for PrestaShop site.

Feel free to check the detailed video tutorial below:

PrestaShop 1.6.x. How to create .CSV file for products import