Delete all Magento orders

Lets say in your CE1.4+ or EE1.8+ you would like to remove all Magento orders from your DB and reset the order increment ID counter.
TRUNCATE TABLE `prefix_sales_flat_order`;
TRUNCATE TABLE `prefix_sales_order_tax`;
TRUNCATE TABLE `prefix_downloadable_link_purchased`;
There is no need to manually ALTER TABLE 'xyz' AUTO_INCREMENT=1; since TRUNCATE rebuilds the structure of the table and sets AUTO_INCREMENT=1 automatically.

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

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

Have fun!

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!