Skip to content

Instantly share code, notes, and snippets.

@larascasse
Created January 28, 2014 12:27
Show Gist options
  • Save larascasse/8666779 to your computer and use it in GitHub Desktop.
Save larascasse/8666779 to your computer and use it in GitHub Desktop.
Magento, restore all product attributes to default store
DELETE FROM catalog_product_bundle_option_value WHERE store_id <> 0;
DELETE FROM catalog_product_entity_datetime WHERE store_id <> 0;
DELETE FROM catalog_product_entity_decimal WHERE store_id <> 0;
DELETE FROM catalog_product_entity_gallery WHERE store_id <> 0;
DELETE FROM catalog_product_entity_int WHERE store_id <> 0;
DELETE FROM catalog_product_entity_media_gallery_value WHERE store_id <> 0;
DELETE FROM catalog_product_entity_text WHERE store_id <> 0;
DELETE FROM catalog_product_entity_varchar WHERE store_id <> 0;
DELETE FROM catalog_product_option_price WHERE store_id <> 0;
DELETE FROM catalog_product_option_title WHERE store_id <> 0;
DELETE FROM catalog_product_option_type_price WHERE store_id <> 0;
DELETE FROM catalog_product_option_type_title WHERE store_id <> 0;
DELETE FROM catalog_product_super_attribute_label WHERE store_id <> 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment