clearing numbers in products viewed

[rubygirl]

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?

 

thanks

[italobiker]

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;

 

 

 

italobiker

[rubygirl]

thanks!

[mustangmatt]

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.

[apha]

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,

 

APHA