Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

banner views and product views


geremyh

Recommended Posts

Posted

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.

  • 2 weeks later...
Posted

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.

Archived

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

×
×
  • Create New...