Imagine you have a lot of failed orders in WooCommerce. Now you know that the orders won’t generate any revenue. They are simply taking up an important space and causing your server to take a little more time to load the orders.
Well, we want to show you how to remove them all at the same time. Of course, removing failed orders is not the only thing you’ll be able to do. You can do these other status changes:
- Change Pending payment into Canceled
- Change Processing into On hold
- Change Canceled into Trash
- And many more changes.
You should keep in mind that when you try to do it with WooCommerce, the server may have errors because it will try to delete them all at the same time.
In contrast, the tool we’ll show you applies changes massively, but it does it in batches. This way, the server will have no problem removing thousands of orders.
We’re talking about the WooCommerce Orders Spreadsheet plugin. This tool completely simplifies the way you manage your orders since it shows them in a spreadsheet and contains powerful tools for advanced searches and massive edits.
Once installed and activated, go to Sheet Editor > Edit orders to open the spreadsheet.
Now, just follow these simple steps to change status for thousands of orders.
1- Open the “Bulk Edit” tool
The Bulk Edit tool helps you apply massive edits in just some minutes. You can delete thousands of orders, change their products, change their dates, etc.
Open it by clicking on Bulk Edit on the toolbar.
2- Select the orders you’ll edit
It’s almost sure you won’t want to change all of your orders’ status. But don’t worry because you can easily filter them to find exactly the ones you want to edit. In this case, we’ll select the Failed orders only.
For that, you need to open the search tool by choosing the I want to search rows to update option in the Select the rows that you want to update dropdown.
Now, you need to select Failed in the Status field and click on Run search to filter all the failed orders.
3- Change the filtered orders’ status
After filtering all the failed orders, you need to select these values in the Bulk Edit tool to change the status from Failed to Delete completely:
- Select the rows that you want to update: I want to search rows to update
- What field do you want to edit: Status
- Select type of edit: Set value
- Replace existing value with this value: Delete completely
- Click on Execute now
That’s how you can easily and quickly delete thousands of orders. It doesn’t overload your server because it applies the changes in batches. Of course, this is not the only status change you can apply. You can save a lot of time finding and editing thousands of orders with the WooCommerce Orders Spreadsheet plugin.