Clearing down test orders in Ubercart

Posted by matason on Friday, 23 October, 2009 - 22:10

Setting up and testing a Drupal 6 + Ubercart site with a payment service provider can result in a lot of test orders on the system so here's a quick procedure for clearing them down before handing the site over to the client.

Use at your own risk and ensure you have a back up of your database before you start!

Back up your database.
No really, back up your database, if you make a mistake here your data is gone bye-bye!

Okay, now we can begin.

We'll be using the TRUNCATE TABLE command which in most instances drops and re-creates the table with the original schema preserved.

These are the commands to enter at the MySQL command line:

USE `your_database`;
TRUNCATE TABLE uc_order_admin_comments;
TRUNCATE TABLE uc_order_comments;
TRUNCATE TABLE uc_order_line_items;
TRUNCATE TABLE uc_order_log;
TRUNCATE TABLE uc_order_products;
TRUNCATE TABLE uc_order_quotes;
TRUNCATE TABLE uc_orders;

And that's it for the clear down. I'd recommend entering a few more orders to make sure nothing got broke and then perform the clear down one last time.

Ubercart 6.x-2.0 was the current version at the time of writing.