Let’s learn how to find and delete WooCommerce coupons by minimum or maximum amount. It’s really important because if you wanted to delete all coupons with a 10-dollar minimum amount, you’d have to do it manually, and it would take you some considerable time.
However, with the WooCommerce Coupons Spreadsheet, you can filter and edit thousands of coupons at once using a spreadsheet containing a powerful bulk edit tool.
You can download the plugin here:
Download WooCommerce Coupons Spreadsheet Plugin - or - Check the features
Video Guide
Text Guide
After installing and activating the spreadsheet, go to WP Sheet Editor > Edit Coupons to open it. You’ll see all your coupons displayed on it and their complete information in columns.
Now we will show you different ways to filter and remove your coupons:
1) Search and delete coupons by minimum amount
A) Open the Bulk Edit tool
With this tool, you can edit thousands of coupons at once, so you need to open it with one click on Bulk Edit on the toolbar.
B) Filter your coupons by minimum amount
To filter all coupons by minimum or maximum amount, you need to open the Search tool by selecting the I want to search rows to update in the Select the rows that you want to update dropdown.
Now you need to tick the Enable advanced filters checkbox and select these values:
- Field key: minimum amount (minimum_amount)
- Operator: You can select a specific amount (=), less than or equal to (<=), greater than or equal to (=>).
- Value: Enter the amount
- Click on Run search.
C) Delete the filtered coupons
Once you filter all the coupons by minimum amount, you need to select these values to delete them all at once:
- 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 to delete all the selected coupons.
2) Find and delete coupons by maximum amount
A) Open the Bulk Edit tool
With this tool, you can edit thousands of coupons at once, so you need to open it with one click on Bulk Edit on the toolbar.
B) Filter your coupons by maximum amount
To filter all coupons by minimum or maximum amount, you need to open the Search tool by selecting the I want to search rows to update in the Select the rows that you want to update dropdown.
Now you need to tick the Enable advanced filters checkbox and select these values:
- Field key: maximum amount (maximum_amount)
- Operator: You can select a specific amount (=), less than or equal to (<=), greater than or equal to (=>).
- Value: Enter the amount
- Click on Run search.
C) Delete the filtered coupons
Once you filter all the coupons by maximum amount, you need to select these values to delete them all at once:
- 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 to delete all the selected coupons.
3) Filter and remove coupons by minimum and maximum amount
Delete WooCommerce coupons by minimum or maximum amount is not the only thing you can do, as you can combine searches and delete WooCommerce coupons by minimum and maximum amount.
A) Open the Bulk Edit tool
With this tool, you not only have the option to edit, but you also have the option to filter the coupons to be edited, so you need to open it with one click on Bulk Edit on the toolbar.
B) Filter your coupons by minimum and maximum amount
To filter all coupons by minimum and maximum amount, you need to open the Search tool by selecting the I want to search rows to update in the Select the rows that you want to update dropdown.
Then you need to tick the Enable advanced filters checkbox and enter these values:
- Field key: minimum amount (minimum_amount)
- Operator: You can select a specific amount (=), less than or equal to (<=), greater than (>), greater than or equal to (=>).
- Value: Enter the amount
- Add new filter
- Field key: maximum amount (maximum_amount)
- Operator: You can select a specific amount (=), less than (<), less than or equal to (<=), greater than or equal to (=>).
- Value: Enter the amount
- Click on Run search.
C) Delete the filtered coupons
After filtering all the coupons by minimum and maximum amount, you need to select these values to remove them all at once:
- 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 to delete all the selected coupons.
Easy!
As you can see, you can delete WooCommerce coupons by minimum or maximum amount without spending a lot of time. You can do it quickly with the WooCommerce Coupons Spreadsheet plugin.
Of course, you can apply many other bulk changes using our spreadsheet. You can go to our blog and find hundreds of tutorials.
You can download the plugin here:
Download WooCommerce Coupons Spreadsheet Plugin - or - Check the features