only show categories with active products??

[dkennelly]

Hi All,

I need to set up a store with loads of categories but most will be empty for now - anyone know how I can use the categories box to display only categories with active products?

Any help appreciated,

thanks, daithi.

[winstanley_john]

Change the SQL query that returns a list of categories to only return categories that contain at least one active product.

 

includes/boxes/categories.php

[dkennelly]

trying, but can't figure it out...

any ideas?

[♥bruyndoncx]

although you can change the code to join categories with products, I don't think it is wise to do this as it puts a heavy burden on your system.

I would install the enable/disable categories contribution which is a pretty easy install and it will not affect performance that much.

[Guest]

There is a function already in categories.php that counts products in each category that will not place any extra burden on the system with more joined queries - if the count is 0 then don't display the link.

 

Find:

  while ($categories = tep_db_fetch_array($categories_query))  {
   if ($level{$categories['parent_id']} == "") { $level{$categories['parent_id']} = 0; }
   $level{$categories['categories_id']} = $level{$categories['parent_id']} + 1;

// Add category link to $categories_string
   for ($a=1; $a<$level{$categories['categories_id']}; $a++) {
     $categories_string .= "  ";
   }

 

Change to:

  while ($categories = tep_db_fetch_array($categories_query))  {
   if ($level{$categories['parent_id']} == "") { $level{$categories['parent_id']} = 0; }
   $level{$categories['categories_id']} = $level{$categories['parent_id']} + 1;

     $products_in_category = tep_count_products_in_category($categories['categories_id']);
     if ($products_in_category > 0) {

// Add category link to $categories_string
   for ($a=1; $a<$level{$categories['categories_id']}; $a++) {
     $categories_string .= "  ";
   }

 

 

Find:

      else { tep_show_category($categories['categories_id'], $cPath_new, $COLLAPSABLE); }

   }

 }

}
?>

 

Change to:

      else { tep_show_category($categories['categories_id'], $cPath_new, $COLLAPSABLE); }

   }

 }

}

}
?>

 

I just tested it and it works like a charm :D

[♥bruyndoncx]

Hi tony

 

Good catch - just wondering if this also works if you don't show the product count ?

[Guest]

Yes, it works both ways.

I wrapped the display cat name function in the IF statement away from the display count test.

 

:D

[niknakgroup]

hello, sorry to revive an old thread, but this may just be the answer to my prayers. I'm trying to run a sub-store with a manufacturer filter applied across the entire store. Anybody got a clue how I could add a manufacturer requirement into this category count, and therefore not show a category if no products by the relevant manufacturer in it??

 

Also, just for the record, I have been through both my includes/boxes/categories.php and the file which comes with the stock download, and I cant find the portion of code above - any ideas where this is?

 

Thanks in advance!