You have created 100 coupons you’ll give to the first 100 customers during a season like Easter, Christmas or Mothers’ Day. However, you realize your coupons run out faster than you had thought.
So, you want to duplicate those 100 coupons you created to give the opportunity to 100 more customers. This will be a great sale opportunity. However, with WooCommerce you can only duplicate coupons individually. And that’s a problem because you need them right now!
We know how stressful that is, so we want to show you that duplicating hundreds of WooCommerce coupons has never been easier. We’ll do it in just three simple steps.
Step 1: Install the WP Sheet Editor Coupons spreadsheet
This plugin helps you apply changes to thousands of WooCommerce coupons quickly as it allows you to do it in a beautiful spreadsheet.
*Skip this step if you have the plugin installed.
You can download the plugin here:Read more about it
In the plugin, you’ll find a spreadsheet 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.
- Duplicate – This is the button we’ll use in this tutorial; it helps you create hundreds of copies of one coupon.
- Locate cell – Here you can enter a specific cell content and it will take you right to that cell.
Step 2: Open the Duplicate tool
As we told you in the first step, to duplicate your coupons, hit the Duplicate tool on the toolbar.
This button will open the popup you need to create hundreds of coupons out of one.
Step 3: Duplicate your coupon
To duplicate the coupon, you need to use these fields:
- Duplicate this item – Here you need to select the coupon you want to duplicate.
- How many copies do you want? – Here you need to select the number of coupons you want to create out of the one you’ve selected in the previous item. You can create as many copies as you wish.
- Execute – You need to use this button to apply the changes.
Finally, you’ll see the result: your copies will appear in the spreadsheet:
As you can see, with the WP Sheet Editor Coupons spreadsheet, it’s just a matter of some clicks to create hundreds of copies out of a coupon.