WooCommerce – Delete Coupons by Minimum or Maximum Amount

Let’s learn how to find and delete all coupons with a specific minimum or a specific 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 Plugin - or - Read more

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 as columns.

Here we show you how to:

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.

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.

Easy!

Deleting all your coupons by minimum or maximum amount doesn’t have to be a headache. 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 Plugin - or - Read more

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu