Resetting the Reports (sales and product)

Quote

Post by ssjal » Wed Jan 13, 2010 2:41 pm

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

Code: Select all

UPDATE product SET viewed = '0';
How can i reset/clear the other 2 reports(sales, product purchased) through the same method(sql query from phpmyadmin).

Thanks...
ssjal
New member
Posts
90
Joined
Thu Sep 17, 2009 4:45 pm
Top

Re: Resetting the Reports (sales and product)

Quote

Post by ssjal » Thu Jan 14, 2010 3:24 am

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.
ssjal
New member
Posts
90
Joined
Thu Sep 17, 2009 4:45 pm
Top

Re: Resetting the Reports (sales and product)

Quote

Post by eyeseesound » Wed Feb 24, 2010 8:45 am

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
eyeseesound
New member
Posts
43
Joined
Tue Aug 18, 2009 4:42 am
Top

Re: Resetting the Reports (sales and product)

Quote

Post by deeve » Sun Feb 28, 2010 12:15 am

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?
deeve
Active Member
Posts
283
Joined
Tue Oct 20, 2009 4:31 pm
Top

Re: Resetting the Reports (sales and product)

Quote

Post by sverno » Sat Mar 06, 2010 2:00 am

Go to Sales/Orders and simply delete the orders you created during your testing.
sverno
Newbie
Posts
4
Joined
Sat Jan 23, 2010 6:38 am
Top

Re: Resetting the Reports (sales and product)

Quote

Post by narkedesign » Thu Mar 15, 2012 10:59 pm

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
narkedesign
Newbie
Posts
6
Joined
Tue Nov 08, 2011 8:11 pm
Top

Re: Resetting the Reports (sales and product)

Quote

Post by Gnikool » Tue Mar 20, 2012 2:00 am

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
Gnikool
Newbie
Posts
2
Joined
Tue Mar 20, 2012 1:57 am
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: Majestic-12 [Bot] and 29 guests