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.
Once installed and activated, open the plugin by going to Sheet Editor > Edit Coupons, and you’ll see a spreadsheet with all your coupons and their complete information.
Now just follow these simple steps:
1- 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.
2- Exclude specific products from all coupons
In order to exclude products, you need to know which their ID is. For this you can go to Products in wp-admin and see the ID of the product you want to edit.
Once you know the ID, select these values to exclude the product from all 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 Product Ids
- Select type of edit: Set value
- Replace existing value with this value: Enter the product ID you’ll exclude from the coupons.
- 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.