[solved] Hide out ofstock items

[Freds]

Hello I need help to get out of stock items to be automatically hidden.

 

The mysql thing did not work it complained about to old mysql version so it has to be a noter way.

 

Give me offer and a about when it might be done.

 

Prestashop version 1.5.4.1

 

/

Fredrik

[Kogkalidis]

You can make something with display attribute in css combine it with php in way like this: if product_quantity>0 then display block else display hidden.. Fix it somehow and I think you've got it!

[Alex Simonchik BelVG]

Hi Freds,

 

did you try change PS config that deny order products that already out of stock?

I mean this feature: http://clip2net.com/clip/m226647/1372745607-clip-55kb.png

 

Regards

[vekia]

i suppose that he want to hide the products which aren't in stock, not only "block" ordering

 

The mysql thing did not work

you're talking about triggers (tutorial: hide out of stock products) ???

 

You can also run cron job - run php script with sql query:

UPDATE ps_product_shop SET active=0 WHERE id_product IN (SELECT id_product FROM ps_stock_available WHERE quantity=0);
UPDATE ps_product_shop SET active=1 WHERE id_product IN (SELECT id_product FROM ps_stock_available WHERE quantity>0);

[Freds]

Thank you it is now Solved

[vekia]

can you say something more about solution that you use?

it will be really helpful for other merchants with similar question.

 

i marked this thread as [solved]

 

regards