In this guide, we will show you how to disable WooCommerce product reviews in bulk.
This is very useful if you don’t want to disable product reviews permanently for all products.
You will be able to disable product reviews on specific products, or filter specific product groups and disable product reviews by keyword, product category, vendor, etc.
This is something you can’t do in WooCommerce, because it doesn’t allow you to filter and edit products in bulk.
Therefore, we will show you how to disable product review submissions using WP Sheet Editor – WooCommerce Products plugin.
This plugin allows you to edit hundreds or thousands of WooCommerce products using a spreadsheet interface that increases your productivity.
This plugin contains advanced search, bulk changes, export and import tools.
You can skip this step if you already have the plugin installed and activated.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
Once you install the plugin and activate your license, you need to follow the steps below in order to bulk disable the product reviews for multiple WooCommerce products.
Open the products spreadsheet
To open the products spreadsheet, go to WP Sheet Editor > Edit products. You’ll see all your WooCommerce products displayed on the spreadsheet.
Option 1 – Disable product reviews individually using the spreadsheet
If you wanted to disable product reviews on multiple products using the normal WooCommerce editor, you would have to open and edit the products one by one. This would take too much time.
Fortunately, if you use the spreadsheet, just go to the Enable reviews column and uncheck the checkbox on all the products you want to disable reviews on.
You can even autofill the cells below, as if you were using Excel, Google Sheets, or any other spreadsheet editor.
Once you have disabled the product reviews on all the products you want, you have to click on Save to apply the changes.
Option 2 – Disable product reviews in bulk
WP Sheet Editor allows you to edit all the products in your store, the products resulting from a specific search (keyword, category, seller, price, date, attribute, etc.), or all the products you select manually in the spreadsheet.
In this example, we will show you how to filter your products by keyword, category, and vendor. The great thing is that you can combine all these search criteria to make a more specific search.
To do this, you need to start by opening the Search tool.
Now select the following values in order to search for products containing the “tee” keyword in the title, the “clothing” category, and a specific vendor:
- Contains keyword: Enter the desired keyword here.
- Enter product categories: Enter the desired category here.
- Tick the Enable advanced filters checkbox and select these values:
- Field: Vendor
- Operator: =
- Value: Enter the vendor’s username here.
- Click on Run search.
After running the search, you will see all the products matching the search terms displayed on the spreadsheet.
Now you need to open the Bulk Edit tool.
Finally, select these values to bulk disable reviews on all the filtered products:
- Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
- What field do you want to edit: Enable reviews
- Select type of edit: Set value
- Replace existing value with this value: Leave this checkbox disabled.
- Select the Edit only parent products option.
- Click on Execute Now.
Start saving lots of hours!
WP Sheet Editor helps you save lots of hours because it helps you apply changes to lots of products at once.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features