I want to reset my Best Viewed Products counter

[aviator-shop]

I want to reset my Best Viewed Products counter. How can I do that?

[diy]

I am quoting myself bt to tell you my opinion I would not play around with the database, I have messed up 2 or 3 TEST databases, and it depends on how many products you have.

 

If you have say 50 it might be easy to set the last value to 0 but if you have 500 yoy may mess things up!!

 

Products views is a part of table products description in the database

 

 INSERT INTO `products_description` (`products_id`, `language_id`, `products_name`, `products_description`, `products_url`, `products_viewed`)

 

So you should redump your products description with the last value set to zero

 

again products ordered is a part of products table

 

INSERT INTO `products` (`products_id`, `products_quantity`, `products_model`, `products_image`, `products_price`, `products_date_added`, `products_last_modified`, `products_date_available`, `products_weight`, `products_status`, `products_tax_class_id`, `manufacturers_id`, `products_ordered`)

 

So again you should redump the info of the table with the last value set to zero

 

if you have time to spare try it first on a TEST database and backup the original one