Skip to content

Instantly share code, notes, and snippets.

@reidblomquist

reidblomquist/gist:aa9df1581a7ee8c82910

Last active August 19, 2021 14:41
Show Gist options
  • Star 3 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save reidblomquist/aa9df1581a7ee8c82910 to your computer and use it in GitHub Desktop.
Save reidblomquist/aa9df1581a7ee8c82910 to your computer and use it in GitHub Desktop.
Download ZIP
Force cancel orders in Magento
Raw
gistfile1.txt
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);
@ctubio
Copy link

ctubio commented Apr 12, 2018 •
edited

💡 no reason to leave dirty sales_flat_order_item, UPDATE it also accordingly

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment