Disable all thumbnail images in your Magento store

Today we came across a Magento store that had around 20,000 products, each with only one image. Somehow almost all of the images had included a thumbnail of the same image. Obviously it would take a lifetime to manually remove all of the thumbnail images so we looked for an alternative.

Once of our previous posts shows you how to enable thumbnails for all products and then disable them for any product with more than one picture, however, in this case, none of the products had more than one image so we wanted to simply disable the thumbnail for all products using a SQL command.

UPDATE catalog_product_entity_media_gallery_value SET disabled = 1;

Nice and simple.