How to hide categories with no active products?

[mikeel100]

I'm in the same boat...the link above to solve this issue is for v1.3. I have version 1.5.1.

I've been trying for weeks to figure out how to hide all subcategories where category counts are 0 of ### active. I have searched in the developers tool kit and looked in the database for anything related to category counts but have came up empty.

I know you can click on the green/red buttons to change the categories. I'm looking for a way to automate it. I have over 7000 products in my store and it's very time consuming to manually go through each category/subcategory to find all of the categories that are 0 of ### active and deactivate them. I don't want to leave them on because that will not give the shopper a very good experience when they click on a category and nothing is there.

I have posted this issue here http://www.zen-cart.com/showthread.p...s-are-inactive but it's not a very active feed.

Where are category counts calculated and stored so that they will display on the admin/categories pages? That is the key I need to finish building my sql statement for taking care of this issue.

If anyone can help, I'd appreciate it.