Using ProductCart - How Many Active Products?

Print Page | Close Window

How Many Active Products?

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=5741
Printed Date: 06-July-2025 at 2:56am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: How Many Active Products?

Posted By: l.Breen
Subject: How Many Active Products?
Date Posted: 24-October-2013 at 12:32pm

Hi,
I would like to know how many active products I have.
Does anybody know where (or how) I might find that?
Thanks,
Luke
http://www.calhouncycle.com

Replies:

Posted By: ProductCart
Date Posted: 24-October-2013 at 1:32pm

Hi Luke,

You can look at the bottom of the stores troubleshooting page. It will tell you the number of products and categories in your store.

(pcadmin/pcTSUtility.asp)

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: l.Breen
Date Posted: 24-October-2013 at 4:40pm

Got it. Thanks
Is there anyway to see how many of the products are "active"?
Here is the info:

The total number of products is 4625.
This number represents the total record count from the "products" table. It includes inactive and http://www.earlyimpact.com/faqs/afmviewfaq.asp?faqid=379" rel="nofollow - deleted products and can be useful when troubleshooting performance issues
The total number of categories is 210.
This number represents the total record count from the "categories" table.

Thank You,

Luke

Posted By: ProductCart
Date Posted: 24-October-2013 at 4:48pm

Hi Luke,

Sure, try going to the page 'pcadmin/LocateProducts.asp', toggling the 'Include inactive products' checkbox should update the AJAX filter (in blue just above 'Category'), but if not, you can take the check out of 'Include inactive products', change 'Results per page' to 100 and each page returned will have 100, add those up and the number from the last page, (most likely under 100) and you should have your total.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software