Created
April 13, 2011 08:13
-
-
Save dannycroft/917176 to your computer and use it in GitHub Desktop.
Magento Enterprise 1.9.0.0 - Cleans out all the orders that may have accumulated during the development process
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
TRUNCATE TABLE sales_flat_order; | |
TRUNCATE TABLE sales_order_tax; | |
TRUNCATE TABLE downloadable_link_purchased; | |
DELETE FROM eav_entity_store WHERE entity_type_id IN (SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code IN ('order', 'invoice', 'creditmemo', 'shipment')); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment