WooCommerce – Delete Coupons by Minimum or Maximum Amount

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.

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.

WP Sheet Editor Coupons spreadsheet view of coupon amounts

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.

Open WP Sheet Editor bulk edit tool

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.

search for coupons by minimum amount with search tool

Now you need to tick the Enable advanced filters checkbox and select these values:

filter WooCommerce coupons by minimum amount

  • 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:

delete WooCommerce coupons by minimum amount

  • 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.

use the plugin's bulk edit tool to filter coupons by amount

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.

filter your woocommerce coupons through the bulk edit tool

Now you need to tick the Enable advanced filters checkbox and select these values:

filter WooCommerce coupons by maximum amount

  • 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:

remove woocomerce coupons by maximum amount

  • 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.

use the plugin's bulk edit tool to filter coupons by amount

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.

filter your woocommerce coupons through the bulk edit tool

Then you need to tick the Enable advanced filters checkbox and enter these values:

filter WooCommerce coupons by minimum and maximum amount

  • 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:

remove woocomerce coupons by maximum amount

  • 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.

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.