17
Aug
MySql query for sku that has not product images in magento.
Following is the MySql query to get list of sku that hasn’t product images.
SELECT `sku` FROM `catalog_product_entity` AS pe LEFT JOIN `catalog_product_entity_varchar` AS pev ON pe.entity_id = pev.entity_id AND pev.attribute_id =74 WHERE pev.value = ''"
I have attribute_id is 74 for image, change it if you have different and you can find it in eav_attribute table.
1,625 responses to "MySql query for sku that has not product images in magento."
Now I know who the brainy one is, I’ll keep looking for your posts.