OSCommerce Product Manager

OSCommerce Product Manager for Windows

FS#219 - Show number of products next to category name in tree.

Attached to Project: OSCommerce Product Manager
Opened by Mario A. Valdez-Ramirez (mvaldez) - Thursday, 07 July 2005, 13:04 GMT-5
Last edited by Mario A. Valdez-Ramirez (mvaldez) - Wednesday, 07 December 2005, 04:18 GMT-5
Task Type New feature
Category Backend / Core
Status Assigned
Assigned To Mario A. Valdez-Ramirez (mvaldez)
Operating System All
Severity Medium
Priority High
Reported Version any
Due in Version Undecided
Due Date Undecided
Percent Complete 0%
Votes 0
Private No


Show the number of products inside a category next to the category name in the category tree.
This task depends upon

Comment by Mario A. Valdez-Ramirez (mvaldez) - Wednesday, 07 December 2005, 04:18 GMT-5

Vincent De Bergh told us:

"My comment is that in actual version ( The statusBar doesn't show the number of records for a main category with subcategories. Maybe a solution to this bug could be to execute in the serverside script a similar function as
> "tep_count_products_in_category" present in ./includes/functions/general.php (l.447)"

And we answered:

I've checked that function. I think I might do the same server-side if it is the only solution. I think I can use a simple SQL join to get all that information without using recursive calls (like tep_count_products_in_category do). Then the OSCPMWin application could assign each count to each category record.

So, we have some ideas, let's test them!