Prestashop import files with all column

Apr 19, 2014

Robert Edwards wrote

I am trying to get the store manager to export a full csv. file with all fields so that I can start inputting content.
However on each occasion I have no joy. Could you assist

5 Answers

Apr 22, 2014

Dmytro Grycelyak agent wrote

Hello Robert!

Could you please describe the issues you're facing while trying to export products more exactly.

In case you can see any error or notification, please provide us with the screen capture

Feb 24, 2015

DaveN wrote

Hi, I'm trying to export all products with all fields. I can't seem to get the .csv to display more like a .xls sheet so I can update.

I thought I'd done this before as export all products then use TAB as the delimiter. I've tried open with .xls and do a conversion but it's pulling the wrong data in to the fields.

Is there a trick to exporting all fields and all products.

Thanks

David

Feb 25, 2015

Dmytro Grycelyak agent wrote

Hello,

It is recommended to export products into comma or semicolon delimited files, please see the screen capture.
Also you should try OpenOffice Calc spreadsheet editor to manage .csv files:
https://www.openoffice.org

2015-02-25_1847.png

Feb 25, 2015

DaveN wrote

Thanks are you saying Open Office handles .csv's better than Microsoft excel?

Feb 25, 2015

DaveN wrote

Wow, ok so I tried and worked straight away. No converting etc needed thanks.