Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How do you reset the stats for products viewed?


Guest

Recommended Posts

I am having a problem finding where the stats can be reset in admin, specifically the data that is viewed on the stats_products_viewed.php page.

 

Any help would be greatly appreciated!

Link to comment
Share on other sites

I could be wrong, but I think you have to do that in the database.

It's in the table products_description then products_viewed row.

Link to comment
Share on other sites

If you want to clear the products viewed (reset them to start over), then you go to the products_description and the products_viewed field is the counter. You can run an SQL command to set them all to 0(zero), which will reset your list.

 

I did this on my site once I was finished developing, so that I could see what was REALLY being viewed by my customers.

 

Hope that helps.

 

HankFrid

If I build it...they will come.

If I don't try to build it.....I will never know!

Link to comment
Share on other sites

  • 2 months later...

I am a novice at SQL so I had to search for how to actually perform the query mentioned previously. Thought I would post it here for others that wish to do this, but are also still learning:

 

UPDATE products_description SET products_viewed=0 WHERE products_viewed > '0';

 

Enjoy..

-MichaelC

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...