How to Delete Test Orders from Magento

Deleting your test orders currently requires running a script directly on your Database. Make sure you fully backup your database before doing anything! This script will delete all orders in the database and reset all order counters!

 

36 thoughts on “How to Delete Test Orders from Magento”

  1. Hey thanks for sharing this! huge help. I am learning about Magento now and am stoked about how powerful and feature rich it is, especially for how young of a platform it is. I will be checking out the rest of your blog thanks again! p.s. I came here from Noupe.com

    Rock on.

  2. Is this SQL Query still valid for Magento? new Log_Visitor tables got added in version 1.3.1.1, so I don’t this this query will still do it all 100%, it certainly removes the test orders in 1.3.2.2. Just don’t want it missing anything.

    Please take a little look.

    Thanks,

    Rob.

  3. Is their any way by which we delete a particular order and reset the counter for that particular order. so that the test orders don’t bother the order ID flow

  4. Here is the SQL for 4.x

    {syntaxhighlighter brush: sql}

    — Reset Magento TEST Data

    SET FOREIGN_KEY_CHECKS=0;

    — Reset dashboard search queries

    TRUNCATE catalogsearch_query;

    ALTER TABLE catalogsearch_query AUTO_INCREMENT=1;

    — Reset sales order info

    TRUNCATE sales_flat_creditmemo;

    TRUNCATE sales_flat_creditmemo_comment;

    TRUNCATE sales_flat_creditmemo_grid;

    TRUNCATE sales_flat_creditmemo_item;

    TRUNCATE sales_flat_invoice;

    TRUNCATE sales_flat_invoice_comment;

    TRUNCATE sales_flat_invoice_grid;

    TRUNCATE sales_flat_invoice_item;

    TRUNCATE sales_flat_order;

    TRUNCATE sales_flat_order_address;

    TRUNCATE sales_flat_order_grid;

    TRUNCATE sales_flat_order_item;

    TRUNCATE sales_flat_order_payment;

    TRUNCATE sales_flat_order_status_history;

    TRUNCATE sales_flat_quote;

    TRUNCATE sales_flat_quote_address;

    TRUNCATE sales_flat_quote_address_item;

    TRUNCATE sales_flat_quote_item;

    TRUNCATE sales_flat_quote_item_option;

    TRUNCATE sales_flat_quote_payment;

    TRUNCATE sales_flat_quote_shipping_rate;

    TRUNCATE sales_flat_shipment;

    TRUNCATE sales_flat_shipment_comment;

    TRUNCATE sales_flat_shipment_grid;

    TRUNCATE sales_flat_shipment_item;

    TRUNCATE sales_flat_shipment_track;

    TRUNCATE sales_invoiced_aggregated;

    TRUNCATE sales_invoiced_aggregated_order;

    TRUNCATE sales_order_aggregated_created;

    TRUNCATE sendfriend_log;

    TRUNCATE tag;

    TRUNCATE tag_relation;

    TRUNCATE tag_summary;

    TRUNCATE wishlist;

    TRUNCATE log_quote;

    TRUNCATE report_event;

    ALTER TABLE sales_flat_creditmemo AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_creditmemo_comment AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_creditmemo_grid AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_creditmemo_item AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_invoice AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_invoice_comment AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_invoice_grid AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_invoice_item AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_order AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_order_address AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_order_grid AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_order_item AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_order_payment AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_order_status_history AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_quote AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_quote_address AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_quote_address_item AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_quote_item AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_quote_item_option AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_quote_payment AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_quote_shipping_rate AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_shipment AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_shipment_comment AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_shipment_grid AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_shipment_item AUTO_INCREMENT=1;

    ALTER TABLE sales_flat_shipment_track AUTO_INCREMENT=1;

    ALTER TABLE sales_invoiced_aggregated AUTO_INCREMENT=1;

    ALTER TABLE sales_invoiced_aggregated_order AUTO_INCREMENT=1;

    ALTER TABLE sales_order_aggregated_created AUTO_INCREMENT=1;

    ALTER TABLE sendfriend_log AUTO_INCREMENT=1;

    ALTER TABLE tag AUTO_INCREMENT=1;

    ALTER TABLE tag_relation AUTO_INCREMENT=1;

    ALTER TABLE tag_summary AUTO_INCREMENT=1;

    ALTER TABLE wishlist AUTO_INCREMENT=1;

    ALTER TABLE log_quote AUTO_INCREMENT=1;

    ALTER TABLE report_event AUTO_INCREMENT=1;

    SET FOREIGN_KEY_CHECKS=1;

    {/syntaxhighlighter}

  5. Thanks Martin! Worked great for 1.4.1.1. I had to make a slight change to make it work in phpmyadmin for me. I just had to add “mgn_” in front of each of the databases to make it go through.

    for example…

    {syntaxhighlighter brush: sql}

    TRUNCATE mgn_sales_flat_creditmemo;

    TRUNCATE mgn_sales_flat_creditmemo_comment;

    TRUNCATE mgn_sales_flat_creditmemo_grid;

    {/syntaxhighlighter}

  6. Hello,

    I am trying to delete test orders from the dashboard in magento. I am very new with this program and I am not sure how to back up and reset the database. I’m using godaddy – sql database but I am not sure how to do it.

    I appreciate if someone can help me with this matter.

    Thanks so much in Advance,

    Tiffany.

Leave a Reply

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