ghiggi Posted December 1, 2003 Share Posted December 1, 2003 Under Reports/Products Viewed, I can I reset the numbers back to 0? I have been testing my new website and some of the numbers are pretty high. I'm now ready to go live and I want to get accurate results. Thanks for any help, ghiggi Link to comment Share on other sites More sharing options...
moonstone Posted December 5, 2003 Share Posted December 5, 2003 Goto contributions and search for empty. There are quite a few good contributions which will clear your database of sample entries and reset all counters. To name a few: 1. Empty Database 2. Empty Store SQL file Hope this helps... Link to comment Share on other sites More sharing options...
ghiggi Posted December 6, 2003 Author Share Posted December 6, 2003 Thanks for the help, moonstone. I looked at a couple of the contributions you sited. However, it seems they delete/reset more than I want. I did however find the variable that I was looking for. products_viewed in the products_description table. But what would the proper command be to reset just that variable and not the whole table? I know I could edit each item individually now that I know where the variable is, but with hundreds of products, this could be time consuming. ghiggi Link to comment Share on other sites More sharing options...
Guest Posted December 6, 2003 Share Posted December 6, 2003 update products_description set products_viewed = 0 where 1; Hth, Matt Link to comment Share on other sites More sharing options...
ghiggi Posted December 6, 2003 Author Share Posted December 6, 2003 That did it, Thanks, ghiggi Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.