Skip to content

Instantly share code, notes, and snippets.

@dinhkhanh

dinhkhanh/magento-delete-order-phpmyadmin.sql

Created December 30, 2014 14:49
Show Gist options
  • Save dinhkhanh/33c10b01f610de525514 to your computer and use it in GitHub Desktop.
Save dinhkhanh/33c10b01f610de525514 to your computer and use it in GitHub Desktop.
Download ZIP
Magento delete order phpmyadmin
Raw
magento-delete-order-phpmyadmin.sql
SET @increamentID = 'XXXXXXXXX';
SET FOREIGN_KEY_CHECKS = 1;
DELETE FROM sales_flat_order
WHERE increment_id = @increamentID;
DELETE FROM sales_flat_quote
WHERE reserved_order_id = @increamentID;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment