jfreeman Posted March 30, 2014 Share Posted March 30, 2014 I'm looking for a way to disable products without a product image. I don't want products up on my site that say "Image Coming Soon" or the like. Any suggestions? I'm currently still on v1.5 Also, Store Manager for PrestaShop by emagicone also does not have this feature. Link to comment Share on other sites More sharing options...
vekia Posted March 30, 2014 Share Posted March 30, 2014 run this simple SQL query: UPDATE ps_product_shop SET active=0 WHERE id_product not in (SELECT id_product FROM ps_image) effect: disabled produtcts without images: Link to comment Share on other sites More sharing options...
jfreeman Posted March 31, 2014 Author Share Posted March 31, 2014 (edited) Thank you so much Vekia for your assistance. I ran the query and it did not tag the items without images as I checked products without images and they were not tagged. It appears that this query found 125 products without images. I am using PrestaShop Store Manager from eMagicone and it found 1,735 products without images. I appreciate your help very much and wondered if you might help me further. Once again - thank you - Jeff Edited March 31, 2014 by jfreeman (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts