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.
You have really interesting blog, keep up posting such informative posts!
Normally I’m against killing but this article slaughtered my ignoarnce.
Thanks for your appreciation
I hate my life but at least this makes it baerable.
Aloha man! Where can I find additional blogs on this topic?
Good blog post. You always write a riveting article. I would like to uncover more such in future.