Skip to main content

Quick Query to the see all products that do not have images in magento2

use this query to see  all products that do not have images in magento2

SELECT sku FROM `catalog_product_entity` WHERE `entity_id` not in (SELECT `entity_id` FROM `catalog_product_entity_media_gallery_value` )

ignoring the "Not Visible Individually" products

 

 SELECT sku FROM `catalog_product_entity` WHERE `entity_id` not in (SELECT `entity_id` FROM `catalog_product_entity_media_gallery_value` )
and `entity_id` not in (select  `entity_id` from `catalog_product_entity_int` where value = 1 and attribute_id= (SELECT `attribute_id` FROM `eav_attribute` WHERE `attribute_code` = 'visibility'))

 

 

Tags