I have created so many testing orders in the Ubercart during the development. So before i migrate the site to production, i have to clear all the testing orders. This could be done by deleting the order one by one through the View orders page.

But i got more than 100 testing orders and obviously the above method is not clever enough.

So i created the following delete_all_orders.php in the <drupal_root> folder
delete_all_orders.php

<?php
  include_once './includes/bootstrap.inc';
  drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
  
  global $user;
  
  if ($user->uid == 1) {
    $result = db_query("select * from uc_orders");
    while($row = db_fetch_object($result)){
      //# uncomment below to view an order and exit
      //# usefull to write a query to only delete certain orders
      //print_r($row);
      //exit;
      print "deleting order $row->order_id\n";
      uc_order_delete($row->order_id); // comment this out for testing
    }
  } else {
    print "Only Administrater could deleter orders.";
  }
?>

Now you can delete all the orders using the administrator account to access the following URL.

• http://<drupal_root>/delete_all_orders.php

Done =)

Reference: delete all orders