Skip to content

Instantly share code, notes, and snippets.

@jwohlfeil

jwohlfeil/Mage - Mass Exclude:Unexclude Images.sql

Created February 14, 2017 12:39
Show Gist options
  • Save jwohlfeil/2dc0c76161cff7008bd525598b73ad06 to your computer and use it in GitHub Desktop.
Save jwohlfeil/2dc0c76161cff7008bd525598b73ad06 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Mage - Mass Exclude:Unexclude Images.sql
By default, Magento will check the 'Exclude' box for you on all imported images, making them not show up as a thumbnail under the main product image on the product view.
# Mass Unexclude
UPDATE`catalog_product_entity_media_gallery_value` SET `disabled` = '0' WHERE `disabled` = '1';
# Mass Exclude
UPDATE`catalog_product_entity_media_gallery_value` SET `disabled` = '1' WHERE `disabled` = '0';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment