Created
August 21, 2014 16:36
-
-
Save kowalikus/4f96452fb1a7f7460090 to your computer and use it in GitHub Desktop.
Magento clean orders customer
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SET FOREIGN_KEY_CHECKS=0; | |
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_payment_transaction`; | |
TRUNCATE `sales_order_aggregated_created`; | |
TRUNCATE `sendfriend_log`; | |
TRUNCATE `tag`; | |
TRUNCATE `tag_relation`; | |
TRUNCATE `tag_summary`; | |
TRUNCATE `wishlist`; | |
TRUNCATE `log_quote`; | |
TRUNCATE `report_event`; | |
TRUNCATE customer_address_entity; | |
TRUNCATE customer_address_entity_datetime; | |
TRUNCATE customer_address_entity_decimal; | |
TRUNCATE customer_address_entity_int; | |
TRUNCATE customer_address_entity_text; | |
TRUNCATE customer_address_entity_varchar; | |
TRUNCATE customer_entity; | |
TRUNCATE customer_entity_datetime; | |
TRUNCATE customer_entity_decimal; | |
TRUNCATE customer_entity_int; | |
TRUNCATE customer_entity_text; | |
TRUNCATE customer_entity_varchar; | |
TRUNCATE log_customer; | |
TRUNCATE log_visitor; | |
TRUNCATE log_visitor_info; | |
TRUNCATE log_url; | |
TRUNCATE log_url_info; | |
SET FOREIGN_KEY_CHECKS=1; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment