Is it possible to Hide Products with no images?

[lecarlb]

Hello,

As the subject suggests, I would like to hide products with no image or products with a placeholder image such as no_image.gif. I think it'll be good for both SEO and UX.

I'm aware that I could make those products inactive but it will be tedious with many products.

Thanks in advance.

[burt]

update products set products_status = 0 where products_image = 'no_image.gif'

[lecarlb]

update products set products_status = 0 where products_image = 'no_image.gif'

@burt where would that line be placed? Or is it a hook?

Thanks.

[Dan Cole]

I think he means for you to run it against your database using phpMyAdmin.

Dan

[lecarlb]

I think he means for you to run it against your database using phpMyAdmin.

Dan

Thanks, I didn't think of that.