[RESOLVED] Set default values for storeviews attributes

Updated . Posted . Visible to the public.

short:
DELETE
FROM catalog_product_entity_decimal
WHERE attribute_id =567
AND store_id !=0;

DELETE
FROM catalog_product_entity_varchar
WHERE attribute_id IN (96, 106, 109, 493)
AND store_id !=0;

DELETE
FROM catalog_product_entity_int
WHERE attribute_id =273
AND store_id !=0;

DELETE
FROM catalog_product_entity_datetime
WHERE attribute_id=569
AND store_id!=0;

DELETE FROM catalog_product_entity_text WHERE attribute_id = 506 AND store_id != 0;

default values for 'special price'
DELETE
FROM catalog_product_entity_decimal
WHERE attribute_id =567
AND store_id !=0;

default values for 'name', images
DELETE
FROM catalog_product_entity_varchar
WHERE attribute_id IN (96, 106, 109, 493)
AND store_id !=0;

default values for 'status'
DELETE
FROM catalog_product_entity_int
WHERE attribute_id =273
AND store_id !=0;

default values for 'special price end date'
DELETE
FROM catalog_product_entity_datetime
WHERE attribute_id=569
AND store_id!=0;

default values for 'short_description'
DELETE FROM catalog_product_entity_text WHERE attribute_id = 506 AND store_id != 0;

Alan Vo
Last edit
Posted by Alan Vo to Alan Vo's deck (2014-02-28 01:09)