How to delete Test orders in Magento Admin

To delete all orders, you can try following SQL commands.

 If you have any prefix at your tables, you must put it at each line.

TRUNCATE TABLE `sales_flat_invoice_grid`;TRUNCATE TABLE `sales_flat_invoice_item`;TRUNCATE TABLE `sales_flat_order`;TRUNCATE TABLE `sales_flat_order_address`;TRUNCATE TABLE `sales_flat_order_grid`;TRUNCATE TABLE `sales_flat_order_item`;TRUNCATE TABLE `sales_flat_order_payment`;TRUNCATE TABLE `sales_flat_order_status_history`;TRUNCATE TABLE `sales_flat_shipment`;TRUNCATE TABLE `sales_flat_shipment_grid`;TRUNCATE TABLE `sales_flat_shipment_item`;TRUNCATE TABLE `sales_flat_shipment_track`;TRUNCATE TABLE `sales_payment_transaction`;