Reset bestseller, most viewed statistics

[newtech]

I just opened a store that I have done tons of order testing. I want to be able to rest all the statistical info. In other words, reset the most viewed products, best seller statistics, most ordered, etc. I see nothing in the database. Where can this info possibly be if it is not in the database.

 

There must be a way to reset this. But how?????

[Guest]

I just opened a store that I have done tons of order testing. I want to be able to rest all the statistical info. In other words, reset the most viewed products, best seller statistics, most ordered, etc. I see nothing in the database. Where can this info possibly be if it is not in the database.

 

There must be a way to reset this. But how?????

 

There is no mechanism inside osCommerce to reset that statistical data. But it *is* in the database. You'd need to be able to do update queries to the database in another program (phpMyAdmin comes to mind, but you can do it from the command line also).

[newtech]

There is no mechanism inside osCommerce to reset that statistical data. But it *is* in the database. You'd need to be able to do update queries to the database in another program (phpMyAdmin comes to mind, but you can do it from the command line also).

I use phpMyAdmin, but I don't see any table for these items. Can you put me in the right direction? And what tables are related. I have seen in the past with some databases if you delete items in one table, it affects another table.

[JTL]

Use the ResetCounts Contribution.

 

J