Toronto Web Developers

I don’t want to scour through the website and the CSV (and the client wouldn’t want to pay us to do that either), so I figured if I could just come up with a list of SKUs for products missing an image, I could hand it off to them so they could correct everything. This isn’t foolproof, but it does the job. This query will give you a list of SKUs where there is no record in the database for that product’s ‘image’ attribute (the main large product image).

SELECT `sku` FROM `catalog_product_entity` AS a LEFT JOIN `catalog_product_entity_varchar` AS b ON a.entity_id = b.entity_id AND b.attribute_id = 74 WHERE b.entity_id IS NULL