How to automatically turn off sold out categories

[joew36]

We have a site that liquidates products for others. So, our inventory changes daily and items sell out all the time. Products automatically turn off when sold out, but how would I go about setting up a procedure (chron, php, mysql) to turn off sold out categories?

[mc12345678]

We have a site that liquidates products for others. So, our inventory changes daily and items sell out all the time. Products automatically turn off when sold out, but how would I go about setting up a procedure (chron, php, mysql) to turn off sold out categories?

Well, I just realized that perhaps this may/may not work for you (ZC 1.3.9) but the following post showed how to do it for a ZC 1.5.4 site. It may still work for 1.3.9. The thread is full of various attempts to obtain the desired goal, but at least it's something.

https://www.zen-cart.com/showthread....47#post1265047

[frank18]

Well, I just realized that perhaps this may/may not work for you (ZC 1.3.9) but the following post showed how to do it for a ZC 1.5.4 site. It may still work for 1.3.9. The thread is full of various attempts to obtain the desired goal, but at least it's something.

https://www.zen-cart.com/showthread....47#post1265047

Don't think it will work since in our case the function

zen_count_products_in_category()

is looking for inactive products but not for products which are sold out (stock = 0) but still active.So IMHO one would first need to set a sold out product to inactive.

[mc12345678]

We have a site that liquidates products for others. So, our inventory changes daily and items sell out all the time. Products automatically turn off when sold out, but how would I go about setting up a procedure (chron, php, mysql) to turn off sold out categories?

Don't think it will work since in our case the function

zen_count_products_in_category()

is looking for inactive products but not for products which are sold out (stock = 0) but still active.So IMHO one would first need to set a sold out product to inactive.

Bolded above indicates that the products are turned off/inactive, therefore meetiing the rewuirement that is humbly suggested. Unless this additional post is related to a different issue/situation than posted by the OP.

[joew36]

Thanks, I did not see that when I searched for an answer. I'm actually off for a couple days but will check this out next week. Thanks.