Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How do I clear or Reset -Reports-Product Viewed


Guest

Recommended Posts

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.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...