I am tidying up old sites from an EE installation (1.12)

I need to clear the orders from the site as well, static blocks and pages have been easy enough to sort with SQL.

I want to do the same to remove the Orders but I have no idea where to start with how the SQL would be created.

I've tried a bunch of plugins but they seem to not want to work with the old EE version we have.

How do I then remove all orders based on a store? The order IDs should all begin with a 4 letter code (say USEN) which is unique for the store.

2 Answers 2


Try to delete rows from sales_flat_order (please note that you should not truncate, but use delete query)

delete from sales_flat_order

It should also delete child rows in related tables (sales_flat_order_item, sales_flat_invoice, etc..)

try it, it should work.

  • Thanks! Learned something new :) (Havent checked all tables, but i guess FK are set correct everywhere)
    – sv3n
    Jul 26, 2017 at 11:16
  • Note: works, but sales_flat_quote (and related) are not deleted
    – sv3n
    Jul 26, 2017 at 11:31

delete orders by your store_id

$orders = Mage::getModel('sales/order')->getCollection()
 ->addFieldToFilter('store_id', $yourStoreId);

before deleting order you should delete invoice, shipment, creditmemo, Payments and quote and then delete order.

foreach ($orders as $order) {
    //delete invoices
    $invoices = $order->getInvoiceCollection();
    foreach ($invoices as $invoice) {
    //invoice items will be deleted as well
    //delete invoices
    $shipments = $order->getShipmentsCollection();
    foreach ($shipments as $shipment) {
    //shipment items will be deleted as well
    //delete credit notes
    $creditMemos = $order->getCreditmemosCollection();
    foreach ($creditMemos as $creditMemo) {
    //credit note items will be deleted as well
    //delete payment references
    $payments = $order->getPaymentsCollection();
    foreach ($payments as $payment) {
    //delete quote
    $quote = Mage::getModel('sales/quote')->load($order->getQuoteId());  
    if ($quote->getId()) {
    foreach ($quote->getAllItems() as $item) {
    //delete the order. items will be deleted as well. So does addresses.

Credit to Marius for this answer Delete all orders older than specific date by db query

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.