Resetting the Reports (sales and product)

i want to reset/clear the 3 reports generated in Reports section in admin panel that were generated during testing of the online shop(Products Viewed Report, sales, product purchased).

i figured that in order to reset Products Viewed Report, i can try following sql query from phpmyadmin How can i reset/clear the other 2 reports(sales, product purchased) through the same method(sql query from phpmyadmin).

Thanks...

anyone having solution to this post?
how to clear the reports(sales,purchase) in admin panel which have been entered during the testing of the shopping cart.

ah, i want this too. Anyone? And could it be considered as a future feature? It seems odd that we can't reset things.

Ta

I can imagine most of us on here would be interested to know how to do this correctly

Are any of the mods around that could help out on this?

Go to Sales/Orders and simply delete the orders you created during your testing.

Deleting the orders does not remove them from the reports, and abviosly customers dont want them on the live sites. Seem to be a bug oversite! As you can remove them from withing admin. I also tried deleting the test customer account.

Did anyone fiand an answer?

Cheers M

Mysqladmin
opn _order or _order (however it is listed in your database)
select "Browse" and delete test sales orders listed
also
you can edit the test sales orders as well