Deleting orders in Magento

Using this blog as reference guide – perhaps slightly easier than bookmarking topics, and in case the internet eats the posts.

Per this thread, to delete an order, do the following:

SET @orderId = '100000001';


DELETE FROM sales_flat_order
    WHERE increment_id = @orderId;
DELETE FROM sales_flat_quote
    WHERE reserved_order_id = @orderId; 

This works in Magento Community v and Magento Enterprise It deleted all mention of the order from the dashboard/reports.

Leave a Reply

Your email address will not be published. Required fields are marked *