geremyh Posted November 23, 2013 Posted November 23, 2013 Firstly I love the product and the fabulous community support. I would like to modify my product views in admin to zero out everyday. I would also like my banner views to zero out everyday. Can you show me how to do that? I've been going into the db and editing it but I'm hoping there is some other way. I have some knowledge in editing the code and phpMyAdmin access. running osC 2.3.1 with a template installed.
geremyh Posted December 3, 2013 Author Posted December 3, 2013 for anyone looking into this.The answer is to create an sql file (i named my zero_views.sql) then import it to the database. Open notepad and copy paste the following UPDATE `hikerssql`.`banners_history` SET `banners_shown` = '0'; UPDATE `hikerssql`.`products_description` SET `products_viewed` = '0' that's all and then when you import (or enter manually in the sql window) it will zero out all views. I use this as a quicker way to see my number of visitors and google analytics tracks more indepth information. What i was looking for was a button in my admin page that would do this.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.