Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

clearing numbers in products viewed


Recommended Posts

Hello all - can anyone tell me where to delete the stats that show under the admin in reports for Products Viewed and Products Ordered -after several test orders and playing, the site is now ready to go live and I really would like to clear the current numbers listed in those 2 areas - I looked in the database and couldn't find anything...


where is this info?



Link to comment
Share on other sites

  • 2 weeks later...

Hi rubygirl,


yes it is in the database:


in the table products_description it's the field products_viewed



This will do it from the db-prompt: 8)


update products_description set products_viewed=0;





Link to comment
Share on other sites

  • 3 months later...
This will do it from the db-prompt:  


update products_description set products_viewed=0;


That worked perfectly. Thank you :D


I am trying to delete the Products Purchased info as well.

I have already deleted all of my test accounts Customers and Orders,

but under the tools menu in Admin - Tools - Items Purchased, it still shows 25 purchases.


Could anyone tell me how to set the products ordered back to 0 as well.

I'm not sure where this is in the database.


Any help is greatly appreciated, thanks.

Link to comment
Share on other sites

  • 8 months later...

Two different tables, thanks for the first one and I located the second one.


Products viewed

update products_description set products_viewed=0;


Products ordered

update products set products_ordered=0;


Best of luck,



Link to comment
Share on other sites


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

  • Create New...