Export Combinations with EANs

[1sweetman]

Hi

Thank you in advance to anyone who can help

I am using this query to export combinations but I would like to export EANs for the combinations but am struggling.

Can anyone update this please??

 

SELECT p.id_product, pa.reference, pl.name, GROUP_CONCAT(DISTINCT(pal.name) SEPARATOR ", ") as combination, p.price, pq.quantity FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_stock_available pq ON (p.id_product = pq.id_product AND pa.id_product_attribute = pq.id_product_attribute) LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_attribute_lang pal ON (pac.id_attribute = pal.id_attribute) WHERE pl.id_lang = 1 AND pal.id_lang = 1 GROUP BY pa.reference ORDER BY p.id_product, pac.id_attribute

 

Again thanks in advance

[Constantino]

Hi, do you need the code only or you don't mind using a third-party tool? I can recommend a prestashop manager for export, it has combination-related group of fields for export including EANs https://www.prestashopmanager.com/useful-articles/how-to/how-to-export-prestashop-attribute-combinations/