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?

[DivaVocals]

how hard can it be?

Not very ... with YOU on the case!!

[RodG]

how hard can it be?

<2 years later>
"Almost got it".....

Cheers
RodG :)

[Ajeh]

Bzzzz ... times up!

These are the changes needed for v1.5.4 to make the Empty Categories or Categories with just Products with status set off to not show ...

Add via the Tools ... Install SQL Patches ...

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Categories with Inactive Products Status', 'CATEGORIES_PRODUCTS_INACTIVE_HIDE', '0', 'Hide Categories with Inactive Products?<br />0= off<br />1= on', 19, 30, 'zen_cfg_select_option(array(\'0\', \'1\'), ', now());

that will be in the Configuration ... Layout Settings ...

[RodG]

Bzzzz ... times up!

Can anyone say "over achiever". <grin>