“Use default value” reactivate in the product data

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 …

One comment on ““Use default value” reactivate in the product data”

  1. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *