magento status Use Default Value for all products

Question

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?

Answer 1

Quick and dirty way.
Identify the 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.