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