woocommerce Change the order status in batches with the order IDs

Job ID: 31483426

Budget: $30 – $250 USD

The function is
1. Provide an interface for entering multiple order numbers

2. Change the order status in batches with the order ID above

Order status "received", "arrived"
I will use the plug-in to add, the above order status

Because of the order ID, there are about 1,000 orders,
please use unique SQL query with the WPDB
global $wpdb
It will be you have good suggestions, please tell me

Although the functions and requirements are not complicated, but because the order volume is large, please use an efficient method of filtering orders, otherwise the website will crash, because the host used by the other party is not efficient
Related categories: PHP SQL WordPress MySQL WooCommerce