Download the product catalog - 1.7.8.1

[FLTNRMDIA]

Hello,
I want to export my product catalog with its information: ID, Internal reference, EAN, Price, stock and categories.

Is there a native feature to retrieve this information, either through Prestashop or through the website database? 
Our version of prestashop is the following: 1.7.8.1

Thank you in advance for all your answers and advice

[Alexandre Carette]

Hello,

you can do that by an SQL query

SELECT 
p.id_product, 
p.id_category_default as cat_default,

GROUP_CONCAT(DISTINCT(c.id_category) SEPARATOR ",") as categories, 
pl.name, 
p.reference,
m.name AS Brand,
p.available_for_order

FROM ps_product p
LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product)
LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product)
LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category)
LEFT JOIN ps_category c ON (cp.id_category = c.id_category)
LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer)

LEFT JOIN ps_category_lang cl2 ON cl2.id_category = p.id_category_default


WHERE 1
GROUP BY p.id_product

 

[FLTNRMDIA]

Merci beaucoup, c'est exactement ce que je cherchais, c'est parfait ! Merci beaucoup !

[Knowband Plugins]

Even you can export the data from the Admin product page. Kindly check the below screenshot : https://nimb.ws/JmRS8Y