How do I clear or Reset -Reports-Product Viewed

[Guest]

Under the Admin in reports there is a section for products viewed. How do I reset or clear this?

[fdcusa]

Greetings,

 

You will need to execute a SQL UPDATE query to do so. This example will reset a specific product_id to 0 views:

 

UPDATE `products_description` SET `products_viewed` = 0 WHERE `products_id` = 562

 

If you wanted to clear ALL views:

 

UPDATE `products_description` SET `products_viewed` = 0

 

Note: This is syntax from phpMyAdmin, if using something else on your host, it may differ (the quotes around table/field names).

 

I suppose an addin could be written to have a 'Reset' button to the right of each, but I'm early in the osCommerce game and still learning it's design.

 

Hope that helps.