Page 1 of 1
Resetting the Reports (sales and product)
Posted: Wed Jan 13, 2010 2:41 pm
by ssjal
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...
Re: Resetting the Reports (sales and product)
Posted: Thu Jan 14, 2010 3:24 am
by ssjal
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.
Re: Resetting the Reports (sales and product)
Posted: Wed Feb 24, 2010 8:45 am
by eyeseesound
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
Re: Resetting the Reports (sales and product)
Posted: Sun Feb 28, 2010 12:15 am
by deeve
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?
Re: Resetting the Reports (sales and product)
Posted: Sat Mar 06, 2010 2:00 am
by sverno
Go to Sales/Orders and simply delete the orders you created during your testing.
Re: Resetting the Reports (sales and product)
Posted: Thu Mar 15, 2012 10:59 pm
by narkedesign
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
Re: Resetting the Reports (sales and product)
Posted: Tue Mar 20, 2012 2:00 am
by Gnikool
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