Please create mysql query for products export in csv for prestashop 1.4.8.2

[Ritesh]

Hi,

I am looking for product export mysql query for prestashop 1.4.8.2, i required below fields,

product id,

product name,

product description,

price

product category

manufacturer id or name

product active or inactive

product image link

product html URL

 

please help me, thank you in advance.

Regards,

Ritesh

[selectshop.at]

On older Prestashop version you can export data directly with phpMyAdmin SQL queries.

 

This old thread should help you: https://www.prestashop.com/forums/topic/143083-how-can-i-export-my-products-to-a-csv-file/?do=reportComment&comment=780131

 

[Ritesh]

i do not have any programming knowledge, can you please create for me.

 

thanks,

regards,

Ritesh

[selectshop.at]

There is nothing to create, you need to login to your database with phpMyAdmin and add the SQL Query named there on the link. How to, you will find in youtube or at least by searching in Google.

https://www.google.com/search?q=phpmyadmin+create+sql+query

 

If you cannot follow the tutorials, so I can do it for you as a paid service. In this case please contact me by PM.

[Ritesh]

below query is giving error "Commands out of sync; you can't run this command now"

SELECT `ps_product`.`id_product`, `ps_product`.`id_manufacturer`, `ps_product`.`id_category_default`, `ps_product`.`price`, `ps_product`.`active`, `ps_product_lang`.`name`, `ps_product_lang`.`description`, `ps_product_lang`.`link_rewrite`, `ps_image`.`sc_path`
FROM ps_product, ps_product_lang, ps_image
ORDER BY `ps_product`.`id_product` ASC

regards,

Ritesh

 

[selectshop.at]

Try this thread:

https://www.prestashop.com/forums/topic/329498-export-all-products-including-combinations/