How to get all created products?

Question

Prestashop

You need to get all the goods (as in the catalog in the admin panel). Found how to receive only active products.

Answer 1

SELECT a.*, b.* , m.name AS manufacturer_name, s.name AS supplier_name
            FROM ps_product a 
            LEFT JOIN ps_product_lang b ON (b.id_product = a.id_product AND b.id_lang = 4 AND b.id_shop = 1) 
            LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = a.id_manufacturer)
            LEFT JOIN ps_supplier s ON (s.id_supplier = a.id_supplier)
            LEFT JOIN ps_stock_available sav ON (sav.id_product = a.id_product AND sav.id_product_attribute = 0 AND sav.id_shop = 1 AND sav.id_shop_group = 0 ) 
            JOIN ps_product_shop sa ON (a.id_product = sa.id_product AND sa.id_shop = a.id_shop_default) 
            LEFT JOIN ps_category_lang cl ON (sa.id_category_default = cl.id_category AND b.id_lang = cl.id_lang AND cl.id_shop = a.id_shop_default) 
            LEFT JOIN ps_shop shop ON (shop.id_shop = a.id_shop_default) 
            LEFT JOIN ps_image_shop image_shop ON (image_shop.id_product = a.id_product AND image_shop.cover = 1 AND image_shop.id_shop = a.id_shop_default) 
            LEFT JOIN ps_image i ON (i.id_image = image_shop.id_image) LEFT JOIN ps_product_download pd ON (pd.id_product = a.id_product AND pd.active = 1) 
            WHERE 1 ORDER BY a.id_product ASC