Last active
August 19, 2021 14:41
-
-
Save reidblomquist/aa9df1581a7ee8c82910 to your computer and use it in GitHub Desktop.
Force cancel orders in Magento
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
The following SQL queries should set an orders status to canceled: | |
UPDATE sales_flat_order SET state = 'canceled', status = 'canceled' WHERE increment_id IN (order#1,order#2,etc); | |
UPDATE sales_flat_order_grid SET status = 'canceled' WHERE increment_id IN (order#1,order#2,etc); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
💡 no reason to leave dirty
sales_flat_order_item
, UPDATE it also accordingly