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...

New member

Posts

Joined
Thu Sep 17, 2009 4:45 pm

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.

New member

Posts

Joined
Thu Sep 17, 2009 4:45 pm

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

New member

Posts

Joined
Tue Aug 18, 2009 4:42 am

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?

Active Member

Posts

Joined
Tue Oct 20, 2009 4:31 pm

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

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

Newbie

Posts

Joined
Sat Jan 23, 2010 6:38 am

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

Newbie

Posts

Joined
Tue Nov 08, 2011 8:11 pm

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

Newbie

Posts

Joined
Tue Mar 20, 2012 1:57 am
Who is online

Users browsing this forum: No registered users and 65 guests