Hide 'out-Of-Stock' Products

[zklid]

Hi, is possible to hide 'Out-of-stock' products with a query in the prestashop database?

And I can do the same for products without photos?
Can someone help me

[-=peter=-]

Yes you can turn them off. You can also modify the code to hide them, but I got some problems, with it.

Don't forget to backup your db!

To deactivate products with quantity <=0 and simple stock management you can exec:

update ps_product p, ps_product_shop ps, (select id_product, sum(sa.quantity) qty

                    from ps_stock_available sa where sa.id_product_attribute<>0

                    group by (sa.id_product)) zqty

  set p.active=0, ps.active=0

where p.id_product=zqty.id_product and ps.id_product=zqty.id_product and zqty.qty<=0;

commit --maybe..