One solution could be to delete the entries directly in the Database.
In the table catalog_product_entity_varchar
you can find all images with the associated store_id
. If there is no entry with a specific store_id
, Magento will use the value with the store_id
0 (Default StoreView)
With this Query you see all Images which are set in a StoreView
SELECT
attributes.entity_id, attributes.store_id, attributes.value, eav.attribute_code
FROM
catalog_product_entity_varchar attributes
JOIN eav_attribute eav ON attributes.attribute_id = eav.attribute_id
WHERE
eav.attribute_code IN ("image", "small_image", "thumbnail")
AND attributes.store_id > 0
What the Query does is, it selects all default image attributes image
, small_image
and thumbnail
with a store_id bigger then 0.
I used the eav_attribute
table to select all entries with the attribute codes, because sometime the IDs are different.
The Result looks like this (in your case its a bigger list):
entity_id store_id value attribute_code
86 6 /i/a/iamge1.png image
86 6 /i/a/iamge2.png small_image
86 6 /i/a/iamge2.png thumbnail
Now we can test if this works like expected. If we choose a Product ID (entity_id) and change the images in the adminpanel to Use Default Value
and execute the Query again, the entries are removed from the table
So, we can convert this select Query into a delete Query
DELETE FROM
attributes.entity_id, attributes.store_id, attributes.value, eav.attribute_code
FROM
catalog_product_entity_varchar attributes
JOIN eav_attribute eav ON attributes.attribute_id = eav.attribute_id
WHERE
eav.attribute_code IN ("image", "small_image", "thumbnail")
AND attributes.store_id > 0
Before executing the delete query on your production system, you should test it on a test system.
In the case you want to change it for a specific StoreView, just change the WHERE
clause to
AND attributes.store_id = 12 //Your StoreView ID
Best Answer
With the default ImportExport CSV format you can set store specific values for single attributes if and only if you also import the default values.
Example:
Here the
meta_title
attribute will be saved with a specific value for store2, while thename
attribute will be saved as "Use default" in store2. Also the default values will be overwritten for all given columns.