Kai Köpke kkoepke
peterjaap
/ removeTestDataResetEntitySeries.sql
Last active
May 30, 2019 02:48
Remove orders, invoices, shipments, creditmemos, customers and quotes from Magento
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
| # Empty relevant tables | |
| DELETE FROM sales_flat_creditmemo; | |
| DELETE FROM sales_flat_invoice; | |
| DELETE FROM sales_flat_order; | |
| DELETE FROM sales_flat_quote; | |
| DELETE FROM sales_flat_shipment; | |
| DELETE FROM customer_entity; | |
| # Reset increment_ids | |
| # Beware of store_ids when using multiple stores |