Edit History

Quote

SELECT 
p.id_product AS 'ID produit', 
pa.reference AS 'Référence du produit',
CONCAT (agl.name,':',ag.group_type,':',ag.position) AS 'Attribut (Nom:Type:Position)*',
CONCAT (al.name,':',a.position) AS 'Valeur (Valeur:Position)*',
pa.supplier_reference AS 'Référence fournisseur',
p.reference AS 'Référence',
pa.ean13 AS 'EAN_13',
pa.upc AS 'UPC',
pa.wholesale_price AS 'Prix d_achat',
pa.price AS 'Impact sur le prix',
pa.ecotax  AS 'Eco-participation',
pa.quantity AS 'Quantité', 
pa.minimal_quantity AS 'Quantité minimale',
pa.low_stock_threshold AS 'Niveau de stock bas',
pa.low_stock_alert AS 'Email quand la quantité est en dessous de ce niveau',
pa.unit_price_impact AS 'Impact sur le poids',
'' AS 'Valeurs par défaut (0 = Non, 1 = Oui)',
pa.available_date AS 'Date de disponibilité de la déclinaison'

FROM ps_product p 
LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) 
LEFT JOIN ps_product_attribute_combination pac ON pac.id_product_attribute = pa.id_product_attribute 
LEFT JOIN ps_attribute a ON a.id_attribute = pac.id_attribute 
LEFT JOIN ps_stock_available sa ON pac.id_product_attribute = sa.id_product_attribute        
LEFT JOIN ps_attribute_group ag ON ag.id_attribute_group = a.id_attribute_group 
LEFT JOIN ps_attribute_lang al ON a.id_attribute = al.id_attribute 
LEFT JOIN ps_attribute_group_lang agl ON ag.id_attribute_group = agl.id_attribute_group

WHERE   al.id_lang = 1 AND agl.id_lang = 1
ORDER BY p.id_product

à essayer 😉