How do you Reset the Count

I’m using the Category List module to feature our most viewed products. Is there a way to reset this count every month so new products will have a chance to catch up with older products?

8 answers

Profile photo of Derrick Young 0.00 $tone February 7, 2010
Public

Hi mahoganybooks

Please open your Database, find report_event table , find event_type_id = 1 (catalog_product_view) and delete it

I found event_type_id, however i’m not sure that there is anything in it. When I search it for "1" it doesn’t return anything. Do I delete the whole thing listed as event_type_id?

Do you mean report_event_types? Because I see catalog_product_view there.?

#5
Profile photo of Derrick Young 0.00 $tone February 9, 2010
Public

I am trying to reset the number of times a product has been viewed on my website. I was told that I need to open my database, find report_event table , find event_type_id = 1 (catalog_product_view) and delete it. The problem is that I found it but it is saying that nothing is in it.

If I delete it anyway do you know if this will adversely affect my website? Or will it do as said and reset the number of times products have been viewed in count? Will that table be re-generated on its own or do I need to recreate it?

I am a novice at this and need a little more detail than what is being provided and the userguide doesn’t go over this scenario. Please help because my site is showing some very outdated products because there is no mechanism to reset the count built into the extension. You all should really think about updating it with that functionality.

Again any more indepth assitance would be much appreciated.

Thanks,

#7

This question is now closed

Written By

Comments