``` SELECT p.entity_id ,p.attribute_set_id ,e.attribute_id ,p.type_id ,p.sku ,p.has_options ,p.required_options ,a.attribute_code ,e.value ,v.value FROM catalog_product_entity AS p LEFT JOIN catalog_product_entity_int AS e ON p.entity_id = e.entity_id LEFT JOIN eav_attribute AS a ON e.attribute_id = a.attribute_id LEFT JOIN eav_attribute_option_value AS v ON e.value = v.option_id AND v.store_id = 1 ``` ```mysql SELECT p.entity_id ,p.attribute_set_id ,e.attribute_id ,p.type_id ,p.sku ,p.has_options ,p.required_options ,a.attribute_code ,e.value ,v.value FROM catalog_product_entity AS p LEFT JOIN catalog_product_entity_int AS e ON p.entity_id = e.entity_id LEFT JOIN eav_attribute AS a ON e.attribute_id = a.attribute_id LEFT JOIN eav_attribute_option_value AS v ON e.value = v.option_id AND v.store_id = 1 where p.sku = 'JKW046B-S' AND v.value IS NOT NULL; ``` 15.10.24 SELECT p.entity_id ,p.attribute_set_id ,e.attribute_id ,p.type_id ,p.sku ,p.has_options ,p.required_options ,a.attribute_code ,e.value ,v.value FROM catalog_product_entity AS p LEFT JOIN catalog_product_entity_int AS e ON p.entity_id = e.entity_id LEFT JOIN eav_attribute AS a ON e.attribute_id = a.attribute_id LEFT JOIN eav_attribute_option_value AS v ON e.value = v.option_id AND v.store_id = 1 where p.sku like '%-S' and v.value is not null AND a.attribute_code = 'size1' AND v.value != 'S' #and p.sku like 'MBR005%';; 15.10.24 how to update magento attributes update catalog_product_entity_int set value = 3 where value_id = {} ; 15.10.24 SELECT p.entity_id ,p.sku ,p.attribute_set_id ,e.value_id ,v.value FROM catalog_product_entity as p LEFT JOIN catalog_product_entity_int AS e ON p.entity_id = e.entity_id LEFT JOIN eav_attribute_option_value AS v ON e.value = v.option_id AND v.store_id = 1 where p.attribute_set_id != 35 AND p.sku like '%-%' and e.attribute_id = 138; 15.10.24

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024