Bulk Change order Status (SQL)

  • Resolved roslindale

    (@roslindale)


    2 years, 5 months ago

    Hi,

    I’m looking for a way to bulk change the order status on 20,000 orders to COMPLETED. I tried this SQL Query, but it didn’t work (Returned “0” Rows)

    update wp_posts set post_status = ‘wc-completed’ where post_type = ‘shop_order’ and post_status =’wc-processing’ ;

    Any help would be appreciated!

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Bulk Change order Status (SQL)’ is closed to new replies.