开发者

Delete all unused attribute options.

开发者 https://www.devze.com 2023-03-23 10:06 出处:网络
Attemping to delete all unused attribute options from my magento 1.4.2 store.What join am I missing? Edit: Am I deleting from the wrong table?

Attemping to delete all unused attribute options from my magento 1.4.2 store. What join am I missing?

Edit: Am I deleting from the wrong table?

delete eaov
from eav_attribute_option_value eaov
inner join eav_attribute_option eao on eaov.option_id = eao.option_id
inner join eav_attribute ea on ea.attribute_id = eao.attribu开发者_开发问答te_id
left join catalog_product_index_eav ce 
    on ce.attribute_id = ea.attribute_id  and ce.value = eaov.option_id
where ce.entity_id is null


Check the comment below for the proper answer.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号