ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Using ProductCart
  New Posts New Posts RSS Feed - How Many Active Products?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

How Many Active Products?

 Post Reply Post Reply
Author
Message
l.Breen View Drop Down
Newbie
Newbie


Joined: 15-November-2010
Location: Minneapolis
Status: Offline
Points: 10
Post Options Post Options   Thanks (0) Thanks(0)   Quote l.Breen Quote  Post ReplyReply Direct Link To This Post Topic: How Many Active Products?
    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
Back to Top
ProductCart View Drop Down
Admin Group
Admin Group

ProductCart Team

Joined: 01-October-2003
Status: Offline
Points: 135
Post Options Post Options   Thanks (0) Thanks(0)   Quote ProductCart Quote  Post ReplyReply Direct Link To This Post 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 shopping cart software
Back to Top
l.Breen View Drop Down
Newbie
Newbie


Joined: 15-November-2010
Location: Minneapolis
Status: Offline
Points: 10
Post Options Post Options   Thanks (0) Thanks(0)   Quote l.Breen Quote  Post ReplyReply Direct Link To This Post 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 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



Back to Top
ProductCart View Drop Down
Admin Group
Admin Group

ProductCart Team

Joined: 01-October-2003
Status: Offline
Points: 135
Post Options Post Options   Thanks (0) Thanks(0)   Quote ProductCart Quote  Post ReplyReply Direct Link To This Post 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 shopping cart software
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.062 seconds.