Updating a whole lot of order statuses manually can be tedious! The Order, Coupon, Subscription Export Import for WooCommerce helps to update the order status in bulk. The plugin also lets you update the custom order statuses created by third-party plugins.
Begin by, downloading, installing and activating the plugin. From the WordPress admin panel, navigate to the WebToffee Import Export (Pro) menu.
- Click on Import and specify the post type as Order.
- Select your import method and Import from location.
- On the mapping screen, edit the Order Status field and specify the status value you want to update the data. Here, we will be updating the status as pending. Click on Apply.
The WooCommerce order statuses along with their values in the column: status are listed here:
| Order statuses | Values in column: status |
| Pending Payment | pending |
| Processing | processing |
| On hold | on-hold |
| Completed | completed |
| Cancelled | cancelled |
| Refunded | refunded |
| Failed | failed |
| Draft | draft |
- In the next step, use the advanced options and click on Import to finish.
For a detailed step-wise procedure, refer to How to import WooCommerce Orders.
On successful import, you can see that all the order status will get bulk updated with the new value(pending) as shown below.
