将所有产品设置为使用所有商店的默认值

Question

I have a Magento 1.5.0.1 install with 3 different store views. At some point along the way two of the stores dont use the default values for product attributes. I am trying to find a way to make all products use default values for all stores, that way the client only has to update things in one place. I found this article but it seems like it only applies to specifically called products. Can anyone explain how to employ that code in my situation? Or suggest new code?

Answer 1

The only way I could get this to work was via MySQL:

DELETE FROM `catalog_product_entity_text` where store_id != 0;
DELETE FROM `catalog_product_entity_datetime` where store_id != 0;
DELETE FROM `catalog_product_entity_decimal` where store_id != 0;
DELETE FROM `catalog_product_entity_int` where store_id != 0;
DELETE FROM `catalog_product_entity_varchar` where store_id != 0;

The above will reset all products to use default values for all attributes.