Page 1 of 1

Is it possible to Hide Products with no images?

Posted: Fri Oct 27, 2023 3:25 am
by 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.

Re: Is it possible to Hide Products with no images?

Posted: Fri Oct 27, 2023 9:46 am
by burt
update products set products_status = 0 where products_image = 'no_image.gif'

Re: Is it possible to Hide Products with no images?

Posted: Mon Oct 30, 2023 3:15 am
by lecarlb
burt wrote: Fri Oct 27, 2023 9:46 am 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.

Re: Is it possible to Hide Products with no images?

Posted: Mon Oct 30, 2023 12:28 pm
by Dan Cole
I think he means for you to run it against your database using phpMyAdmin.

Dan

Re: Is it possible to Hide Products with no images?

Posted: Mon Oct 30, 2023 12:36 pm
by lecarlb
Dan Cole wrote: Mon Oct 30, 2023 12:28 pm I think he means for you to run it against your database using phpMyAdmin.

Dan
Thanks, I didn't think of that.