[SOLVED] How do you make a .CSV file

[chris449]

Hi,

I know uploading .csv files is a far more efficient way of populating the database but I'm kinda confused how to do it properly. I've searched these forums and others over the passed week but its still unclear- i know what they are but I don't know how to make one.

Any suggestions?

Thanks

[webbusiness23]

In order to make a .csv file follow these steps:

1. create an empty Excel spreadsheet

2. Make sure you create the EXACT columns as required in the BO (id, product name, category_id, etc etc)

3. fill in just 2 lines of the .csv file and upload it.

4. Check to see if the products were added successfully.

5. If the products were not added successfully, check the .csv file again to see if it is exactly as the one required by the Back Office.


Tips and tricks: Make sure the product id column remains empty, because the id is auto_increment (when you upload the csv, the first product of your csv file will have an id equal with the last product's id + 1, so you don't need to write something on the product_id column)

Hope it helps you!

[chris449]

Thanks,

though is there an example or template somewhere?

[webbusiness23]

Try here .

And search the forum. There's plenty of info.

[rylersbud]

If you create the file in excell you will need to open it in notepad or some text editor and change it to utf-8 or prestashop will not see it

[archproject]

This is very good information ... Thanks for sharing...