Created
May 4, 2016 11:16
-
-
Save yariksheptykin/51adcaf6604e6eb2f300f710b880abab to your computer and use it in GitHub Desktop.
Deletes all orders in Magento 2 shop
This file contains 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
/** Empties tables containing information about orders. */ | |
START TRANSACTION; | |
DELETE FROM sales_order WHERE TRUE; | |
DELETE FROM sales_creditmemo_comment WHERE TRUE; | |
DELETE FROM sales_creditmemo_item WHERE TRUE; | |
DELETE FROM sales_creditmemo WHERE TRUE; | |
DELETE FROM sales_creditmemo_grid WHERE TRUE; | |
DELETE FROM sales_invoice_comment WHERE TRUE; | |
DELETE FROM sales_invoice_item WHERE TRUE; | |
DELETE FROM sales_invoice WHERE TRUE; | |
DELETE FROM sales_invoice_grid WHERE TRUE; | |
DELETE FROM quote_address_item WHERE TRUE; | |
DELETE FROM quote_item_option WHERE TRUE; | |
DELETE FROM quote WHERE TRUE; | |
DELETE FROM quote_address WHERE TRUE; | |
DELETE FROM quote_item WHERE TRUE; | |
DELETE FROM quote_payment WHERE TRUE; | |
DELETE FROM quote_shipping_rate WHERE TRUE; | |
DELETE FROM quote_id_mask WHERE TRUE; | |
DELETE FROM sales_shipment_comment WHERE TRUE; | |
DELETE FROM sales_shipment_item WHERE TRUE; | |
DELETE FROM sales_shipment_track WHERE TRUE; | |
DELETE FROM sales_shipment WHERE TRUE; | |
DELETE FROM sales_shipment_grid WHERE TRUE; | |
DELETE FROM sales_order_address WHERE TRUE; | |
DELETE FROM sales_order_item WHERE TRUE; | |
DELETE FROM sales_order_payment WHERE TRUE; | |
DELETE FROM sales_order_status_history WHERE TRUE; | |
DELETE FROM sales_order_grid WHERE TRUE; | |
DELETE FROM sales_order_tax WHERE TRUE; | |
/* ROLLBACK; */ | |
COMMIT; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment