UPDATE `ps_product_lang` pl
SET description_short = name
WHERE trim(description_short)=”
AND
`id_product` in (select p.`id_product` from ps_product p where
p.id_category_default in (select id_category from ps_category where
id_parent in (13, 29)));

UPDATE `ps_product_lang` pl, ps_product p
SET pl.name = p.reference
WHERE
TBD

select name, reference,  description = name
from ps_product p
LEFT JOIN `ps_product_lang` pl ON (pl.`id_p
                                   AND roduct` = p.`id_product` AND pl.`id_lang` = 1 AND pl.`id_shop` = 2)
where
id_category_default in (select id_category from ps_category where id_parent in (13, 29) )
and trim(description)=”;

SELECT  description_short,name
FROM `ps_product_lang` pl
WHERE trim(description_short)=”
AND
`id_product` in (select p.`id_product` from ps_product p where
p.id_category_default in (select id_category from ps_category where
id_parent in (13, 29)));

 

Pour maxencre

google analytics

transfert automatique commandes  vers boutiquepro

copie depuis automatique des Récapitulatifs et Fiches techniques

 

moi : 2a01:e34:eca0:f540:c45b:6b2b:3,2a01:e34:eca0:f540:c45b:6b2b:3ee:ac76;

pierre : 2a01:e34:eca0:f540:b022:861d:5fb3:2197

A la mise en prod :

configurer Menu principal

puis html bidule