{"id":1621,"date":"2021-03-10T10:00:21","date_gmt":"2021-03-10T10:00:21","guid":{"rendered":"https:\/\/meetanshi.com\/blog\/unhide-all-product-images-on-product-page-in-magento-2\/"},"modified":"2025-05-22T10:52:51","modified_gmt":"2025-05-22T05:22:51","slug":"unhide-all-product-images-on-product-page-in-magento-2","status":"publish","type":"post","link":"https:\/\/meetanshi.com\/blog\/unhide-all-product-images-on-product-page-in-magento-2\/","title":{"rendered":"How to Unhide All Product Images on Product Page in Magento 2"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/meetanshi.com\/magento-2-migration-service.html\" target=\"_blank\" rel=\"noreferrer noopener\">Magento 2 migration<\/a>&nbsp;is a complex process and not all the time you can end up with smooth migration and a fully functional Magento 2 store.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sometimes, it may happen that while migrating the product, images, and its data, there comes an issue in the product image which is not displayed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">All the product images remain hidden in the migrated store. This may impact the sales in the store. Product images are critical for potentials customers to understand the layout and appearance of the product.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">According to&nbsp;<a href=\"https:\/\/www.statista.com\/statistics\/823862\/number-product-photos-needed-shopping-online-any-product\/\" target=\"_blank\" rel=\"noreferrer noopener\">Statista<\/a>, consumers expected five photos for any product while shopping online. Such numbers prove that no Magento 2 store owners can afford the hidden product images.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Hence, check out the solution to&nbsp;<em><strong>unhide all product images on product page in Magento 2<\/strong><\/em>. With this quick solution, you will not need to unhide product images one by one.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Method to Unhide All Product Images on Product Page in Magento 2<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Simply change the product image visibility using the following query in the database.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">UPDATE `catalog_product_entity_media_gallery_value` SET `disabled` = '0' WHERE `disabled` = '1';<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">It will replace every 0 with 1, which means it unhides all product images in the hidden state.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">That\u2019s all!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Feel free to share the solution with Magento Community via social media.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thank You.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Magento 2 migration&nbsp;is a complex process and not all the time you can end up with smooth migration and a fully functional Magento 2 store&#8230;.<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-1621","post","type-post","status-publish","format-standard","hentry","category-magento"],"acf":[],"_links":{"self":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/comments?post=1621"}],"version-history":[{"count":3,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1621\/revisions"}],"predecessor-version":[{"id":14453,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1621\/revisions\/14453"}],"wp:attachment":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/media?parent=1621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/categories?post=1621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/tags?post=1621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}