Jump to content
thirty bees forum
  • entries
    2
  • comments
    5
  • views
    6,972

How to export all info of products in CSV


Dear all,

I was trying to export full information for my products as CSV, but noticed that by using the default "export" function in backoffice -> products only exported id, image, name, price, Quantity, ref, and category but not full description, i searched for at way to do it easily, and came across this very helpfull articel:

 

https://premiumpresta.com/blog/export-products-for-csv-import-prestashop-1-6/

That explain in full detail including the code.

-.... And if you dont want to read it all just need the code then download it directly from Github:

https://github.com/PremiumPresta/export-products-for-csv-import-prestashop-1.6

Hope it will be usefull 🙂 

  • Like 1

5 Comments


Recommended Comments

Mark

Posted

When I tried it downloaded but didnt install

Pedalman

Posted (edited)

solved. see next post

(Ehm, I made the experience using this override that it reports to be incompatible with TB (latest stable).

It would be very great if some one capable could test it.)

Edited by Pedalman
movieseals

Posted

20 hours ago, Pedalman said:

Ehm, I made the experience using this override that it reports to be incompatible with TB (latest stable).

It would be very great if some one capable could test it.

I have used it with no issues on TB 1.1

  • Like 1
Pedalman

Posted (edited)

Oh, that is good to hear. I will check my other installations.

! update: I did so and no problems at all on my live server with the override. All I had to to as always with overrides was to delete the class_index.php file in /cache/

 

(

Absolutely my fault. The problem I faced is realted to the way I set up my local database.

I could not get it working with a clone of my live shop. This clone runs local on Xampp. With debug on I could not get the export beining generated due to the errow message shown:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' a.`reference`, NULL AS features, NULL AS tags, supplier.`name` AS supplier_name' at line 3

in file classes/db/Db.php at line 488

With debug off I could generate the csv ! very nice but else than expected it contained only the 'header line' without any articles. These I had checked in product list.

)

 

Edited by Pedalman
Mark

Posted

On 11/26/2019 at 5:58 AM, Pedalman said:

solved. see next post

(Ehm, I made the experience using this override that it reports to be incompatible with TB (latest stable).

It would be very great if some one capable could test it.)

Not solved.. same problem exists... the module is incompatible (unless we mess round changing core files which we shouldn't have to)

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...