PrestaShop 1.6.x. How to export/import data in CSV files

NOTE: In PrestaShop, you can export and import categories, products, customers, addresses, manufacturers, suppliers, combinations, and aliases. This is useful if you want, for example, to export categories and products from one store and import them into another. The export and import process is done with the help of CSV (comma-separated values) files.
Export Information from PrestaShop
  1. Log into your Prestashop admin panel.
  2. You can export information from the page in the admin panel where you can manage that particular information. For instance, to export the products, go to Catalog->Products in the admin panel: 
  3. Click the Export button in the top right corner:
  4. A small window will appear. So, you can save the products into a CSV file on your local computer.
  5. To export categories, go to Catalog->Categories and use the Export button. If you want to export the customers, go to Customers->Customers and use the Export button; to export the addresses this will be Customers->Addresses->Export button, etc.
  6. You can import it into another PrestaShop instance or in the same one when you have the CSV file(s) with the exported information on your local computer. You can edit the file before importing it, in case you need it.
Import Information into PrestaShop
  1. We recommend making a BACKUP of that shop before you import anything into your PrestaShop unless it’s empty and you have nothing to lose.
  2. In your admin panel go to Advanced Parameters ->CSV Import to import a CSV file, regardless of whether it’s for categories, products, customers, etc.
    [notice type=”warning”]You can also go to the page for managing whatever you want to import and click on the Import button there. For instance, if you want to import categories, you can go to Catalog -> Categories and click the Import button. This will automatically redirect you to the same CSV Import page in the admin panel.
  3. There are the following options on the CSV Import page :
    • what kind of entity would you like to import? – select whether the CSV file that you’re about to import contains categories, products, customers, address, etc. from this drop-down menu. When you select an entity you’ll see the fields for that entity in the area on the right;
    • select your CSV file – upload the CSV file that’s about to be imported. Click Upload as file button and use the window that pops out to locate the CSV file that you have previously exported on your local computer. Choose from history/FTP button allows to upload CSV file directly from FTP (adminXXX/import directory of the Prestashop installation);
    • the language of the file – select the language of the CSV file;
    • ISO-8859-1 encoded file? – if the file is in that encoding, you should enable this option;
    • field separator – usually the field separator in CSV files is a semicolon;
    • multiple value separator – this is a comma, by default;
    • delete all … before import – if you enable the option, the existing data will be deleted;
    • use product reference as key – this option is available only when you’re importing products. It’s disabled by default which means that the product key that will be used is automatically selected by PrestaShop. If you want to force PrestaShop to use the product reference option as the product key, enable this option;
    • force all ID numbers – by default, this setting is disabled which means that PrestaShop will assign its own IDs to the imported data. If you want to keep the original IDs, enable this option.
  4. Click the Next Step button below, when you’re done with the settings.
  5. On the page that appears you’ll see a table with the data that’s about to be imported. You can use it to make sure that the headers of the CSV file that you’re going to import match the headers required by PrestaShop. At the top of the table there are drop-down menus showing which header PrestaShop expects at each particular position of the table, and under them, you’ll see the headers of the columns as they exist in the CSV file.
  6. Click Import CSV data button.
  7. When the data from the file is imported, you’ll be brought back to the CSV Import page. If there was some problem with the import, there will be a message(s) on the red background. There might be some other non-critical warning messages which don’t mean the import wasn’t successful. Such messages are shown on the brown background.

Hopefully, this tutorial was helpful for you.