Imagine you’re running a Christmas campaign using WooCommerce coupons. Your customers are happy, and they are shopping with you a lot. Everything is great with your campaign. However, you receive an email from a customer saying it’s great that the coupons will expire until February next year, so he will invite his friend to shop with you in January. Now, remember your campaign is only during Christmas season.
The problem is that, when you created the coupons, you didn’t pay attention to their expiration dates, so they’re scheduled to expire until February. You know that’s not good since you’ve planned to run another campaign for New Year, and you don’t want to ruin it of course. It’s not a good idea to have two campaigns overlapping like this.
Therefore, you have to quickly change all your coupons expiry dates; you need to restrict them. However, you have 300 coupons that need that change. How will you do it?
In this article we want to show you how easy it is to edit thousands of WooCommerce coupons’ expiry dates using the WP Sheet Editor Coupons Spreadsheet plugin.
Install the WP Sheet Editor Coupons Spreadsheet plugin
This plugin simplifies your life, as it gives you a beautiful spreadsheet containing all your coupons and their complete information. You can change any aspect of your coupons just by editing the cells you wish in the spreadsheet. Besides, the plugin contains a powerful Bulk Edit tool, which helps you apply changes to thousands of products at once with just a few clicks.
*You can skip this step if you have the plugin installed and activated.
Once installed and activated, the plugin will display all your coupons and their complete information in a spreadsheet.
OPTION 1: Edit coupons’ expiry dates individually in the spreadsheet
If you want to edit not thousands but just some coupons’ expiry date, then you just need to go to the Coupon expiry date column in the spreadsheet and change the date. If they’re scheduled to expire in a month and you want them to last less, then just select a nearer date or vice-versa.
OPTION 2: Edit thousands of coupons’ expiry dates at once with the Bulk Edit tool
With WP Sheet Editor you can also edit hundreds or thousands of your coupons using the Bulk Edit tool. It helps you apply hundreds of changes to thousands of coupons with a few clicks. So please, just click it on the plugin’s toolbar.
After opening the Bulk Edit tool, you need to use these values in order to change all your coupons expiration dates:
In the Bulk Edit tool, you need to set these values:
- Select the rows that you want to update: Edit all the rows from my current search (even non-visible rows).
- What field do you want to edit: Coupon expiry date
- Select type of edit: Set value
- Replace existing value with this value: Enter the new date
IMPORTANT: The date needs to have this format: YYYY-MM-DD
- Hit the Execute now button.
Now your coupons’ expiry dates will be changed successfully. Use the WP Sheet Editor Coupons spreadsheet to make this and many other changes to your WooCommerce coupons.