Reseting Reports Info back to Zero

[mpapier]

I have been testing my store for a while and am getting ready to go live. I'd like to reset all the information that has been collected in the Reports sections. IE Best Viewed Products, Products Purchased, etc.

 

Is there a way to do this?

 

Thanks!

[Nullachtfuffzehn]

You got to go to the database with phpMyadmin and reset them manually.

[mpapier]

You got to go to the database with phpMyadmin and reset them manually.

 

Do you know what query I run and on what table?

[Nullachtfuffzehn]

Yes I do.

 

To reset the ordered products:

 

update products set products_ordered = 0

 

reset the views

 

update products_descriptions set products_viewed = 0

 

and so on...

 

This question has appeared so often recently, that I'm considering to write a contrib for the admin section to achieve this goal.

[mpapier]

Yes I do.

 

To reset the ordered products:

 

update products set products_ordered = 0

 

reset the views

 

update products_descriptions set products_viewed = 0

 

and so on...

 

This question has appeared so often recently, that I'm considering to write a contrib for the admin section to achieve this goal.

 

That worked perfectly! Thank you!