Import a CSV file of Products into PrestaShop

If you have a large number of products you want to offer in your PrestaShop store, importing a CSV file of those products will make the process quicker than entering each product one by one in the PrestaShop back office. In this tutorial, we will walk you through importing a CSV file of products into PrestaShop.

Please be sure that you have properly formatted your CSV file before beginning the import process in PrestaShop. Before you import your CSV product file, check the following:

• The Name field is required for importing and creating products.
• You can let PrestaShop automatically assign a Product ID by leaving the ID field blank in your CSV file.
• Active field: 0 = not active, 1 = active
• To assign a product to a category (or categories) during import the category (or categories) should be identified by name (not ID as was the case in previous PrestaShop installations).
• The category you assign a product to must already exist in PrestaShop. You can create the categories either through the PrestaShop back office or by importing a CSV file of categories.
• If you want to assign a product to multiple categories, separate the category names with a comma (,) in the Category field.
• If you do not assign a category for a product, it will be automatically assigned to the Home category in PrestaShop.
• The price column uses your store's default currency (this is set in Payment > Currencies > Currency options).

1. To begin the import process, log into your PrestaShop back office.
2. Click on the Tools tab and click on the CSV Import link.

   

3. In the Upload area on the CSV Import page, click the Browse button and select the product CSV file to import from your local computer.

   

4. Click the Upload button.

   

5. Under the Import heading, choose Products from the drop down menu of what you would like to import and click Next step.

   

6. If your product file contains a header row (most do) input 1 in the Skip lines field provided.
7. Make sure the field names (column names) in your CSV file are properly matched to their corresponding field name in PrestaShop (e.g. ID to id, Active to Active, Name to Name, etc.).
8. Select Import .CSV data to begin importing your CSV file of products into PrestaShop.

   

9. Verify your products imported correctly by navigating to the Catalog tab and viewing each of the categories you imported products into or viewing your your live site.

   

Anytime you want to import new products, use the steps above. To update existing products, simply input each product ID of the products to be updated in the ID column of your product CSV file.