Importing data into your store: Prestashop Import CSV Tool

Importing data into a web store is essential to keep catalogs up to date. Prestashop offers the possibility to import a vast amount of field types. Let’s take a look at the Prestashop Import CSV tool.

Running Time: 15 mins

Prestashop Version Used: 1.4.8.2

Watch The Screencast

Additional Resources

Wikipedia: CSV – Comma separated Values

You like the tuts and want to say "thank you"? Well, you can always feel free to donate:

  • Ben

    Hi Nemo, do you know why the csv I exported from Prestashop 1.6.0.9 is not including Description, Manufacturer, Discount, etc? It’s only ID, Image, Name, Ref, Categories, Price, Quantity, and Status.

  • Luber Panda

    Hi Nemo, thanks for your tutorial. i have 1 question….

    How to import combination with different attribute but same references code ? say it :
    1. Color : Black, Size : M, Reference Code : ABCD
    2. Color : Blue, Size : L, Reference Code : ABCD

    i tried to import that, but successful only for the second combination. if you know how to fix that ?
    is it possible to do that in prestashop ? i used 1.5.6.1

    thanks for your advice and help.

  • http://www.pcpbooks.net JIm

    You left out some critical things:

    1: Excel must be set to use the semi colon as the field separator. This is not the default for Excel otherwise it is a jumble when CSV is imported. To import the file use [in Excel] Data>Import External Data>select CSV then change separator to semi colon when it appears.

    2. I have always used category numbers not names and it has worked fine and is easier (IMHO).

    3. Let them know if you leave the image file in (after already loading it previously) it will load it again and you will have the exact same picture loaded twice. Customers will see two pictures (or more if you keep doing it!) of the same thing.

    4. They can make there own CSV file but importing the sample file into Excel, editing it and saving it with their stuff ! For newbies it was not clear.

    As an additional note I have a master Access database with my products (thousands) you can have it export csv files for import with some fiddling just make it look like the sample file set UTF-8 and use semicolon as seperator.

  • dan

    The video is great and everything but why is no one posting how to make the darn csv? There are pages and pages of documents on how to import..its easy, use the drop downs! But HOW do you create the actual CSV?

  • http://www.vincenzolarosa.it Vincenzo

    how i can import client and andress from one csv file?

    sorry for my english..

    • http://nemops.com Nemo

      You can’t. Unfortunately, they must b imported separately :(

Store Top Sales

You like the tuts and want to say "thank you"? Well, you can always feel free to donate: