Guest User

Untitled

a guest
Jan 23rd, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. UPDATE sales_order SET state='complete', status='complete' WHERE status = 'processing'
  2. UPDATE sales_order_grid SET status='complete' WHERE status = 'processing'
  3.  
  4. INSERT INTO `sales_order_status_history` (`parent_id`, `is_customer_notified`, `is_visible_on_front`, `comment`, `status`, `created_at`, `entity_name`) VALUES (1, 0, 0, NULL, 'complete', NOW(), 'order');
  5.  
  6. mysql> UPDATE sales_order SET state='complete', status='complete' WHERE increment_id IN (000043719,000044003,000044117,...);
  7. Query OK, 15 rows affected (0.08 sec)
  8. Rows matched: 16 Changed: 15 Warnings: 0
  9.  
  10. mysql> UPDATE sales_order_grid SET status='complete' WHERE increment_id IN (000043719,000044003,000044117,...);
  11. Query OK, 15 rows affected (0.03 sec)
  12. Rows matched: 16 Changed: 15 Warnings: 0
Add Comment
Please, Sign In to add comment