How to hidethe category if all product in category out of stock.

[vishalsingh119]

Hi guys,

 

i am facing an issue ,i have one category that have two disable or out of stock product.so i want to hide category automatically not by admin pannel.How to disable the category if all product in category disable.if any product have stock then category visible.

 

so tell me some msqul query or php script

[musicmaster]

You could use a mysql trigger that with each product deletion/disabling/out-of-stock checks whether the categories involved now have zero products and then switches it off. You would need a second trigger that in order to switch it on again when products become available.

[vishalsingh119]

Hi,

 

i tried your post name-

 Prestools Suite: Mass Edit, Order Edit And Much More

 

but sorry its not working,kindly send me the mysql trigger code or php code so that i directly apply on it.

 

 

thanks in advanced

[vishalsingh119]

You could use a mysql trigger that with each product deletion/disabling/out-of-stock checks whether the categories involved now have zero products and then switches it off. You would need a second trigger that in order to switch it on again when products become available.

I tried the mysql trigger but they are not working,better if you have some php customization code.so guide me for that,so i change in php file