I did a bulk action, to enable and disable all products for a storeview in my product overview.
But now all the products are not using the default value anymore for status. Is there way to check the "Use Default Value" back again?
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.Sign up to join this community
Quick and dirty way.
status attribute id.
SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'status' AND entity_type_id = (SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code = 'catalog_product' )
with the value you get from the above query run this (I got 273):
DELETE FROM catalog_product_entity_int WHERE attribute_id = 273 AND store_id <> 0
This will delete the records for status attribute for all other store views except the default values.
Make sure you reindex when you are done.
And back up the db before trying it.