Today I had to update order numbers which were processed already, but not updated in Magento. Here is how I changed the order status directly in the database based on the increment_id.
The first query will update the state and status on the table sales_order.
|
1 2 3 |
mysql> UPDATE sales_order SET state='complete', status='complete' WHERE increment_id IN (000043719,000044003,000044117,...); Query OK, 15 rows affected (0.08 sec) Rows matched: 16 Changed: 15 Warnings: 0 |
The second one will update the status in the grid view in Sales > Orders.
|
1 2 3 |
mysql> UPDATE sales_order_grid SET status='complete' WHERE increment_id IN (000043719,000044003,000044117,...); Query OK, 15 rows affected (0.03 sec) Rows matched: 16 Changed: 15 Warnings: 0 |