If the default value in the product data overwritten once in a store view, This can be done only by manual check mark set to reverse. For 3-4 Item no problem. For hundreds of anything but a fun and unfortunately can not be mapped using the import function.
But everything is a hook (or even no) has, is indeed represented in the database. Here helfen that catalog_product_entity Tables. Here are all variations on the product_id, the store_id and stored attribute_id. For the variants, for the “Use default value” should be reactivated, These are the entries to delete the store_id and “Hook” is again set the store_id 0 if possible should not be deleted …
For completeness, here are the SQL queries that must be run:
DELETE FROM `catalog_product_entity_varchar` WHERE store_id IN ( 1, 2 )
DELETE FROM `catalog_product_entity_int` WHERE store_id IN ( 1, 2 )
with me only these two tables were at least affected. Store the IDs are naturally adapt as needed.