You know it. Coupons are a great way of having lots of new customers and turn those occasional customers into loyal ones.
However, sometimes it may happen that you create a bunch of coupons and according to your numbers, you need to change their discount amounts in order not to lose income. Or maybe you want to increase their discount amounts so that customers decide to shop with you when they see how much they can save.
Whatever the case, changing the discount amounts in 300 coupons may be a really hard task if you have to open them one by one. That’s why in this short article, we’ll show you how to quickly and easily edit your coupons’ discount amounts.
For this quick tutorial, we’ll use the WP Sheet Editor Coupons Spreadsheet plugin.
Step 1: Install the WP Sheet Editor Coupons Spreadsheet plugin
Besides making everything easier through having every field of your coupons at hand, it contains a powerful Bulk Edit tool, which helps you apply changes on hundreds of coupons at once.
*Skip this step if you have the plugin installed and activated.
You can download the plugin here:Read more about it
This plugin will show all your products in a beautiful spreadsheet.
It contains 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.
The spreadsheet shows you the coupon amounts in the Coupon amount column.
Step 2: Search the coupons you want to edit
To edit the coupon amounts, you need to open the Bulk Edit tool, so please click it on the toolbar. This is a powerful tool because it helps you edit thousands of coupons with just a few clicks.
After that, you need to select the I want to search rows to update option in the Select the rows that you want to update field. This opens a search tool to filter your coupons in several ways we explain to you here.
The Search tool contains the following fields:
- Contains keyword – Use this field if you want to look for all coupons containing a specific keyword.
- Status – Here you can select between published and draft coupons.
- Enable advanced filters – This checkbox opens advanced filters to search for your coupons.
You decide which coupons to edit using the search form. Leave it empty to edit all the coupons. The Run search button will filter your coupons and take you back to the Bulk Edit tool.
Step 3: Change the coupon amounts in the coupons you’ve filtered
- Select the rows that you want to update: I want to search rows to update.
- What field do you want to edit: Coupon amount
- Select type of edit: Set value
- Replace existing value with this value: Enter the new amount
- Click on Execute now
After that, you’ll see that your coupon amounts have been successfully changed.
Applying this and many other changes is a piece of cake with the WP Sheet Editor Coupons Spreadsheet plugin.