Richard Castera

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.

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.

Well check this, a total solution for deleting Magento order “Delete Any Order”

https://www.yireo.com/software/delete-any-order

Excellent!
It works!

Mag. ver. 1.3.2.4

thanks for the tips, its helpful.

Thank you so much. Worked great.

works greet¡¡ thx 4 sharing, but how to export only product, category and attributes in sql mode?

thx

Thank you very much! This has helped me sort out a huge bug in a client's shop.

thanks! works perfectly

the table "sales_order_tax" should also be cleaned, otherwise you get duplicate tax reported in your backend reports and on the sales order detail page.

Can you please explain how to delete a single order(with increment_id available)?

Spankin' Fantabulous! Much thanks.

You da man! Couldn't get any easier than that.

thanks boss its amazing, helped me a lot...

Wow wonderful, worked like a charm on 1.3.3
Thank you so much!

Hi does this work for 1.4x?

Manage Magento Orders by Orderbook Extension. visit
http://www.magentocommerce.com/magento-connect/Modulesoft+Solutions/exte...

Since Magento changed to using flat sales order tables (1.4x) this doesn't work anymore

Can you update ur SQL please

Thanks, some one had posted it on magento forum, and also put the source site name which is your's thanks.

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

Here is the SQL for 4.x

-- 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;

Thanks Martin!!!!

I just used your updated SQL for Magento 1.4.1.1.

It worked perfectly!

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...

TRUNCATE `mgn_sales_flat_creditmemo`;

TRUNCATE `mgn_sales_flat_creditmemo_comment`;

TRUNCATE `mgn_sales_flat_creditmemo_grid`;

Thanks Martin, worked like a charm.

I Got Great Idea after seeing fantastic table concept for sales and order table ...

Thanks

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.