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.
I hope you already have WSL2 installed and enabled. So, setting up Apache2 on WSL2…
Install NVM on Windows Node Js is a JavaScript runtime environment used widely in today’s…
You can easily reset WSL 2 users' password, by just following the following steps. Open…
DreamHost a web hosting company, founded in 1997. It is offering sort of hosting services,…
Menus in WordPress are highly versatile and can be easily modified to change in your…
Laravel is famous and robust PHP framework, widely used in different type of projects. While…
View Comments
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.