WooCommerce – How to Delete Coupons by Usage Count in Seconds

In this quick tutorial, we want to show you how to quickly filter all your WooCommerce coupons by usage count and how to delete them all. It’s important because sometimes we want to delete all unused coupons or all coupons that have been used more than 100 times.

If we try to do that with WooCommerce, we’ll have to spend a considerable time trying to edit them all. But with the WooCommerce Coupons Spreadsheet plugin, we’ll be able to do it in seconds.

This plugin contains a great bulk edit tool that allows us to edit thousands of coupons at once. Also, you can edit values on the spreadsheet as you do in Excel or Google Sheets.

You can download the plugin here:

Download Plugin - or - Read more

Once installed and activated, open the spreadsheet by going to WP Sheet Editor > Edit Coupons.

Now just follow these simple steps.

1- Open the Bulk Edit tool

The Bulk Edit tool allows you to edit thousands of coupons at once avoiding server errors. It applies the changes in batches to give your server some rest.

Open it with one click on the toolbar.

2- Filter the coupons by usage count

After opening the Bulk Edit tool, you need to filter the coupons by usage count. For that, open the Search tool by selecting I want to search rows to update in the Select the rows that you want to update dropdown.

You can search for all unused coupons by ticking the Enable advanced filters checkbox and selecting these values:

  • Field key: usage count (usage_count)
  • Operator: =
  • Value: 0
  • Click on Run search to filter them.

Important (optional)

You can also search for all coupons used more than 100 times or coupons used less than 50 times, for example. For that just select these values:

  • Field key: usage count (usage_count)
  • Operator: You can select < or >
  • Value: Enter the number of times the coupon must have been used.
  • Click on Run search to filter them.

3- Delete the filtered coupons

Once you filter all the coupons by usage count, 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.

Done!

You can easily filter all the coupons by a specific usage count and delete them in seconds. It’s really simple and it just takes some clicks. Of course, you can apply many other changes to your coupons such as edit descriptions, titles, discount amounts, etc.

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