Products W/o Images

How do I search for products without images (4.2x) ?

Unfortunately there is no such a feature. But you can export products with the Product code, Language and Image URL fields only. Then open file in Excel and sort data by the Image URL column. As a result, you will receive product codes of all products without images at the top

[quote name=‘eComLabs’ timestamp=‘1408608332’ post=‘190157’]

Unfortunately there is no such a feature. But you can export products with the Product code, Language and Image URL fields only. Then open file in Excel and sort data by the Image URL column. As a result, you will receive product codes of all products without images at the top

[/quote]



Of course, I did not think of it :-) Thank you.

[quote name=‘gabbo’ timestamp=‘1408633482’ post=‘190209’]

Of course, I did not think of it :-) Thank you.

[/quote]



You are welcome! Let me know if you have any other questions

If you use phpMyAdmin, or can connect to your database, this query will return a list of all products without image records:

SELECT product_id,product_code FROM cscart_products t1
LEFT OUTER JOIN cscart_images_links t2
ON t1.product_id = t2.object_id
WHERE t2.object_id is null