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

How to export all info of products in CSV


unica e-shop

5,146 views

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

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
Link to comment
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
Link to comment

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
Link to comment
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)

Link to comment

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...