Skip to content

Instantly share code, notes, and snippets.

@yariksheptykin
Created May 4, 2016 11:16
Show Gist options
  • Save yariksheptykin/51adcaf6604e6eb2f300f710b880abab to your computer and use it in GitHub Desktop.
Save yariksheptykin/51adcaf6604e6eb2f300f710b880abab to your computer and use it in GitHub Desktop.
Deletes all orders in Magento 2 shop
/** 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