First off let me say I am not a Prestashop developer and I acquired several Prestashop sites which we´ve now moved over to another platform so this tutorial is how to Export products with quantity to CSV file in Prestashop using the SQL Manager.
Why your doing this is because the exporting of products from Prestashop 1.5.* is pretty woeful and although you can use the export function on the Products pages, this will only let you export one page at a time. Fine if you have a few hundred products, but typically the sites I see have several thousand products and exporting page by page is a major pain in the fingers.
So, First off this tutorial is for version 1.5.* of Prestashop. (Export products with quantity to CSV file in Prestashop 1.5.x)
Secondly, the SQL Manager can be found on the Advanced Parameters menu. So: Advanced Parameters -> SQL Manager
Once you have the SQL Manager in view you need to click the Add new button. This will start the new SQL Manager wizard.
Next give the SQL command a name, Export All should be okay. Then copy and paste the code below into the request box.
SELECT p.id_product, p.active, pl.name, GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR “,”) as categories, p.reference, p.price, p.id_tax_rules_group, p.wholesale_price, p.reference, p.supplier_reference, p.id_supplier, p.id_manufacturer,man.name, p.upc, p.ecotax, p.weight, qp.quantity, pl.name, 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, qp.quantity FROM ps_product p LEFT JOIN ps_stock_available qp ON (p.id_product = qp.id_product) 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) LEFT JOIN ps_manufacturer man ON (man.name = p.id_manufacturer) WHERE pl.id_lang = 1 AND cl.id_lang = 1 AND p.id_shop_default = 1 AND c.id_shop_default = 1 GROUP BY p.id_product
Now click the save button
To use this sql query either click the name to run this within the browser and show results in the browser or click the export button to run the command and save the results as a CSV file.
That´s it you should have a full on CSV file