ProductCart Shopping Cart Software Forums : Product count per category https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 16:14:02 +0000 Mon, 29 Jan 2007 08:12:56 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=606 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Product count per category : Thanks for taking the time, I&#039;ll...]]> https://forum.productcart.com/product-count-per-category_topic606_post1806.html#1806 Author: ClarkSmith
Subject: 606
Posted: 29-January-2007 at 8:12am

Thanks for taking the time, I'll give that a shot.]]> Mon, 29 Jan 2007 08:12:56 +0000 https://forum.productcart.com/product-count-per-category_topic606_post1806.html#1806 <![CDATA[Product count per category : Perform a select statement that...]]> https://forum.productcart.com/product-count-per-category_topic606_post1789.html#1789 Author: NWilliams
Subject: 606
Posted: 28-January-2007 at 9:39pm

Perform a select statement that would return all products in a category and use the Recordset.Recordcount property to retrieve the number of results in the recordset.

You should be able to poke around in some of the source and copy and paste code that would do the trick with minor editing.


To do what you're wanting, I would edit the GenerateNavigation.asp file to just not add the category to the navigation code if there are no products in its category or subcategories.  Rather complex, but I think it'd be the most user-friendly solution so long as you don't list subcategories from the view of a parent category.


Edited by NWilliams - 28-January-2007 at 9:41pm]]> Sun, 28 Jan 2007 21:39:36 +0000 https://forum.productcart.com/product-count-per-category_topic606_post1789.html#1789 <![CDATA[Product count per category : Can anyone offer a snippet of...]]> https://forum.productcart.com/product-count-per-category_topic606_post1756.html#1756 Author: ClarkSmith
Subject: 606
Posted: 20-January-2007 at 12:30pm

Can anyone offer a snippet of code that would allow counts of products per category? I use categories heavily but don't have products for every category yet. So a user may dig four or five steps deep only to find there is nothing there. The count needs to be able to show total products in all subcategories as well in order to prevent people from clicking deeply into a category structure only to find nothing. It would look like this:

Bathroom Floors

Clean (3 products)
Protect (1 product)
Transform (No products yet available)

Structurally it would be thinking like this:
Bathrooms (8 products inside)
Floors (4 products inside)
Clean (3 products)
Cleaner 1
Cleaner 2
Cleaner 3
Protect (1 product)
Protector 1
Transform (0 products)
Sinks (4 products inside)
Cleaners (4 products)
Cleaner 1
Cleaner 2
Cleaner 3
Cleaner 4

Thanks in advance for any help!

]]> Sat, 20 Jan 2007 12:30:22 +0000 https://forum.productcart.com/product-count-per-category_topic606_post1756.html#1756