Delete Magento test orders

Lets say in your CE1.4+ or EE1.8+ you would like to delete test orders before you go live so those do not affect reports.
You have placed 100000001 and 100000002 as your test.
SELECT `entity_id` FROM `prefix_sales_flat_order` WHERE `increment_id` IN ('100000001', '100000002');
| entity_id |
|         5 |
|         8 |
2 rows in set (0.00 sec)
DELETE FROM `prefix_sales_flat_order` WHERE `entity_id` IN (5, 8);
DELETE FROM `prefix_sales_order_tax` WHERE `order_id` IN (5, 8);
DELETE FROM `prefix_downloadable_link_purchased` WHERE `order_id` IN (5, 8);
Go to Admin -> Reports -> Refresh Statistics, select all items and run Refresh Lifetime Statistics.

Please note do perform such actions on test deployment and have backups prior of doing such actions!

Delete all Magento orders
Delete specific Magento RMA
Delete all Magento RMA


We Love Our Customers

    Team of US based Certified Magento Engineers will work directly with you (no middle-men) to make sure MagePhobia provides best quality technical services. Some of our Magento Engineers are ex-Magento employees who built Magento for several years and know Magento inside-out.
    MagePhobia provides affordable
Magento Services with one of the best quality on the market.
    Our US based Technical Support is provided exclusively by our Certified Magento Developers and System Administrators, and is available 24/7 via ticketing, chat, and phone.
    MagePhobia offers short and long-term contracts as well as 'per job' basis contracts. We refund in case of unsatisfactory results which, we believe, will not occur ever.

We are all-in for customer satisfaction!