Export csv products, categories and subcategories Prestashop 1.6

Script export csv

Script export csv

In the following article we share you a csv script export that will help you, as it said, to export the products, categories and subcategories you have in your online shop and other details you need in a csv file, through your dashboard in Prestashop 1.6.

How it works:

  • open the dashboard in Prestashop 1.6
  • enter in Advanced Parameters / SQL Manager
  • add a query from the right part, clicking the “+” sign
  • in the new query you have to add a name for it (e.g. “export products and categories”)
  • copy the SQL part from below and add it to that query (big box below the name)
  • click on Save

After clicking “Save” you’ll be redirected to the initial SQL Manager page. You’ll have a new row with this query that you’ve created. To do the export of the data just simply click on the button “Export” from the right.


The tables in the database must start with “ps_” for this script (database prefix).
If the database has a different prefix, you will need to replace “ps_” with the database prefix.

Below you find this SQL csv export script for the query:

SELECT p.id_product, p.active, pl.name, GROUP_CONCAT(DISTINCT(cl.name)
SEPARATOR “,”) as categories, p.price, p.id_tax_rules_group,
p.wholesale_price, p.reference, p.supplier_reference, p.id_supplier,
p.id_manufacturer, p.upc, p.ecotax, p.weight, p.quantity,
pl.description_short, pl.description, pl.meta_title, pl.meta_keywords,
pl.meta_description, pl.link_rewrite, pl.available_now,
pl.available_later, p.available_for_order, p.date_add, p.show_price,
p.online_only, p.condition, p.id_shop_default
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_product_tag pt ON (p.id_product = pt.id_product)

GROUP BY p.id_product

For any questions or clarifications regarding this script or other Prestashop-related topics, we are waiting for your messages through our contact page!