Let’s face it. Sometimes our coupon campaigns just don’t work as we plan. Customers don’t seize the opportunity and let our discounts expire.
No matter how discouraging that can be, we should not be discouraged and continue trying to attract customers. For example, we can start planning another campaign after evaluating what didn’t work.
So we may need to remove those coupons from our WooCommerce store. Yet, it can be really difficult to know which of those coupons are still available and which of them have expired and can be deleted, especially if you have hundreds of thousands of coupons to be checked. You’ll not check one by one; that could take you hours and hours.
That’s why we’ll show you how easy it is to delete all expired coupons quickly using the WP Sheet Editor Coupons Spreadsheet plugin.
Step 1: Install WP Sheet Editor
With this plugin you can edit hundreds of coupons at once in a spreadsheet.
*Skip this step if you have the plugin installed and activated.
You can download the plugin here:Read more about it
Once you install, activate and open the plugin, you’ll find a spreadsheet containing all your coupons and their complete information.
In the plugin you’ll find a toolbar with the following tools:
- Add new – This button helps you create new coupons in the spreadsheet.
- Search – With this tool, you can search specific coupons using different search terms.
- Bulk Edit – This is a powerful tool that helps you apply changes to thousands of coupons at once.
- Locate cell – Here you can enter a specific cell content and it will take you right to that cell.
Step 2: Filter all expired coupons
To search the coupons you want to edit, you need to open the Bulk Edit tool. It is located in the toolbar, so just click it to open it.
Once you open the tool, you need to select the I want to search rows to update in the Select the rows that you want to update. This button will open a search tool that will allow you to filter your coupons.
Once in the Search tool, you need to tick the Enable advanced filters checkbox and use these values to search your expired coupons:
- Field key: Coupon expiry date
- Operator: =
- Enter the expiry date in the Value field.
IMPORTANT: You need to enter the date without any spaces or signs. The format for it must be YYYYMMDD.
After that, hit the Run search button, which will take you back to the Bulk Edit.
Step 3: Delete the coupons you’ve selected
In the Bulk Edit tool, you need to set these values in the fields in order to change delete the coupons:
- Select the rows that you want to update: I want to search rows to update
- What field do you want to edit: Status
- Select the type of edit: Set value
- Replace existing value with this value: Delete completely or Trash
- Click on Execute now
This and many other changes are easily applied to your coupons with the WP Sheet Editor Coupons Spreadsheet plugin. Get it now and start saving lots of hours.