There are certain products to which, for different reasons, we do not want to apply discounts. And that’s normal. Everyone decides on how to manage their WooCommerce store. Therefore, in this tutorial we want to show you how to exclude a product from all the coupons you may have in WooCommerce.
For that we are going to use the WP Sheet Editor Coupons Spreadsheet plugin. It is a very easy to use plugin that completely simplifies the way we handle our coupons; we can apply changes to hundreds or thousands of coupons in a few seconds.
We’ll use the product My Watch as an example for this tutorial to show you that you can exclude main products an variations using IDs, Titles, or SKUs.
Now just follow these simple steps:
1- Open the Coupons spreadsheet
Once you install and activate the plugin, open the spreadsheet by going to Sheet Editor > Edit Coupons, and you’ll see a spreadsheet with all your coupons and their complete information.
2- Open the Bulk Edit tool
The Bulk Edit tool allows you to apply changes to thousands of products at once, so you need to open it. It’s located on the toolbar; just click on it.
3- Exclude specific products from all coupons
After opening the Bulk Edit tool, you need to select these values to exclude specific products from all your coupons.
- 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: Exclude Products
- Select type of edit: Set value
- Replace existing value with this value: Enter any product IDs, Titles, or SKUs. If you enter more than one, separate the IDs, Titles, or SKUs using commas. In this example, we’re excluding the main product and its variations using different SKUs.
- Click on Execute now
As you can see, it’s really simple to exclude specific products from all coupons with the WP Sheet Editor Coupons Spreadsheet plugin.