Tag Archives: SQL

delete_test_orders

Delete test orders from Magento 1.5.x/1.4.x

So you have a Magento project, created a new theme, added products and categories, and made a few orders for testing of delivery and payment. You made sure that everything works fine and the client is ready to launch your site developed. But you still see weird orders in admin panel. Client says they must be removed and they can’t do that in admin panel. But how? You can only cancel that orders, but they will remain there with status “Cancelled”. Unfortunately, Magento doesn’t to remove them through admin panel, so you will not find any button “Delete Order”. This may frustrate you as a developer and your client. The fact that the ordering data is stored in different database tables (sales, warehouse, etc..)