Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save oreales/32853e174af23cde561e43f1a4a0b15a to your computer and use it in GitHub Desktop.
Save oreales/32853e174af23cde561e43f1a4a0b15a to your computer and use it in GitHub Desktop.
#SELECT que nos da las labels de productos configurables que no estan usando el valor por defecto (traducciones) establecido para este atributo / store view en el admin.
SELECT * FROM catalog_product_super_attribute_label as sal
LEFT JOIN catalog_product_super_attribute as sa USING (product_super_attribute_id)
LEFT JOIN eav_attribute_label as al ON (sal.store_id = al.store_id AND sa.attribute_id = al.attribute_id)
WHERE sal.store_id != 0
AND sal.value != al.value;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment