How to get sku list that hasn’t product images in magento?
Following is the SQL query by which you can 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 = ''";
Image attribute id is 74 and it has not any value in catalog_product_entity_varchar value field against 74 attribute_id field.
You can also make this list as csv file by just write very simple code.
<?php
header("Content-type:text/octect-stream");
header("Content-Disposition:attachment;filename=no-image.csv");
$conn = mysqli_connect("localhost","username","password","database"); // change this according to your database information
$SQL = "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.value = ''";
$R = mysqli_query($conn,$SQL);
echo "sku,image,small_image,thumbnail_image"."\n"; // print fields headings or names in csv file
while($Rs = mysqli_fetch_assoc($R)){
echo $Rs['sku'].",,,"."\n"; // print values in csv file
}
mysqli_free_result($R);
?>
In above code you will notice that I use 3 more fields other then sku it is because I will edit this csv file and write image name in image, small_image,thumbnail_image fileds and run profile from magento Data flow profiles to update products for images.
