Number of Products
 

If a user submits a product and it needs to be moderated, the count of products reflects it even if it hasn't been approved as of yet. Any way to fix this?

The stats simply show the correct total products number whether approved or not.

Is there an easy way to change this so it only counts the approved products? Many of my users are getting confused when a category shows that there is 1 product, but click only to see none (since the 1 is in the approval queue). I'm guessing I would add something like:

WHERE approved=1

to the mySQL call, but I'm not sure where the count is being done.

Thanks,
Cary

Yes exactly you add something like that to the call and it would be in the pp-inc.php file or index.php file if your running an older version in the function get_statscache

I tried:

to function get_statscache, but it didn't seem to do anything. I have caching off, so I don't think that matters. Any ideas?

That would make a difference for sure as long as your reloading the cache

I'm looking to have the number of approved products in the category listings -- that code just seems to change the total approved products statistics at the bottom of the page.

edit your catrow function in pp-inc.php

Hmm...not sure where I should be looking in it. It's not a mySQL call is it?

Yes its the mysql query update_catcache however there is no specific way to do this since the number of products are pulled from the categories table.