Automatic or sql to turn off subcategories and sub-subcategories with 0 active items

[stxmona]

Hello
I was wondering if there is an automatic way to make subcategories and sub-subcategories with 0 active items to automatically turn off. Or if there is a SQL that would work for this.
Our site has fabric that is link into many subcategories and once it is sold out, I have to manually go in and toggle or delete the sub and sub-subcategories. It would be nice to be able to do this automatically.
Thanks for any help! Still loving ZenCart!
Mona
http://www.QuiltsInMontana.com

[RodG]

configuration->Layout_settings->Categories with 0 Products Status = 0

At least that is what I think you coud be looking for.

Cheers
RodG

[stxmona]

Thanks RodG for the reply .... my configuration IS set up like that (Categories with 0 Products Status = 0 ) however, it does not toggle the sub nor sub subcategories to off.

Any other ideas?
Mona
http://www.QuiltsInMontana.com

[RodG]

Any other ideas?
Mona
http://www.QuiltsInMontana.com

Sorry, no I don't.

Hopefully someone else with have some idea.

Cheers
RodG

[lhungil]

You may be able to add an observer (to listen for stock decrements)... Then do a SQL query to see if all products in the category are disabled (or have a quantity of 0)... Then disable the category if needed (and check the parent categories recursively). Not the most efficient, but might provide a starting place.

[Ajeh]

I have code to make this happen that I built into an upcoming future release ... https://github.com/zencart/zencart/pull/231/files

Let me get it translated for v1.5.4 and maybe from that you can address it for your v1.5.3 ... how hard can it be?