I missed a function in catalog/includes/general.php that needs to be updated to correctly count products in a category and only its active sub-categories. Complete instructions are attached but only one has been added:


Find around line 383 in the function tep_count_products_in_category the line that sets $child_categories_query and add the "and status_categ = 1" to it so the line will now read:

$child_categories_query = tep_db_query("select categories_id from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$category_id . "' and status_categ = 1");


More...