4 replies [Last post]
gooddesignusa's picture
Offline
Joined: 04/13/2009
Juice: 41
Was this information Helpful?

Ok so I'm about to hand over an UC site to a client. Well I've been doing a lot of testing. Which resulted in LOTS of dummy users with lots of orders. So my question is... How can I clean up all the orders and reports. I've already racked up at least 6g's in sales reports. So obviously I would love to be able to reset that before giving it to him. I've already started going through and deleting the user accounts. That was easy enough to delete mass users. Wish there was another "View Orders" page that was more like the user or content list page. Allowing me to check multiple orders and delete them all at once.

I'm curious if I can clear a table or something in the DB to reset the orders/reports. I remember someone talking about changing the order number inside the DB. I'm Still kinda new to drupal / ubercart so I havn't really looked / messed around inside the DB besides clearing the watchdog table to clean up the Recent Logs page. I'm sure others have ran into this dilemma before.

Thanks a lot.

gooddesignusa's picture
Offline
Joined: 04/13/2009
Juice: 41
use search... duh

Yeah after re wording my search I found my answer. It didn't mention anything about reports but when I cleared out the orders it cleaned the reports. Found this thread: http://www.ubercart.org/forum/support/7688/removing_orders_database

In case you don't want to read through it. Open phpMyAdmin. Go to the tables below and Empty them.

1) uc_orders
2) uc_order_comments
3) uc_order_admin_comments
4) uc_order_log
5) uc_order_products
6) uc_order_line_items

and Ryan said "DONT clean out uc_order_statuses"

After doing that everything seems to be nice. Smiling

rennsix's picture
Offline
Uber Donor
Joined: 09/11/2008
Juice: 89
Thanks

Very useful post for developers who want to ring out the system before going "live". Thanks guys

-Colin

Danny_Joris's picture
Offline
Joined: 05/09/2009
Juice: 199
_

I will try this sollution, but wouldn't it be much easier to have a button for this somewhere? I feel that manipulating the database directly should never be an option. Maybe a reset button that only can be used by user-1 for example?

Cheers,
Danny

kristen's picture
Offline
Joined: 06/07/2011
Juice: 3
Ubercart Views

This is an old thread but high up on google so he's the best way to deal with orders currently:

http://drupalmodules.com/module/ubercart-views

Cheers,
Kristen