WooCommerce Bulk Enable or Disable Product Review Feature

exist WooCommerce A product review system in a store can boost user trust, increase conversions, or it can lead to spam. Want to batch enable or disable the comment function? Follow this article to get it done quickly, without having to modify them one by one.

I. Why batch manage comment function?

Here are common scenarios:

• Batch close comments: prevent spam comments, fake comments, or wholesale stores that don't require user interaction
• Batch Enable Reviews: Improve Conversion Rates, Increase User Interaction, Incentivize Positive Reviews
• Adjustments to comment policy: originally turned off by default, but would like to see it turned on subsequently; or changed from "on" to "comments from purchased users only"

Batch setupcommentariesStatus can be managed in a unified way to improve the quality of website content and user experience.

Method 1: Use WP Sheet Editor to batch modify comment status (recommended)

1. Install and enable the plug-in

• Plugin Name:WooCommerce Bulk Edit Products- WP Sheet Editor
• leave for WordPress Backend → Plugins → Add Plugin, Search and Enable

2. Access to the merchandise table view

• Click on the "Backstage left menu".WP Sheet Editor → Edit Product"
• The plugin loads an Excel-like product editing form page

3. Steps to enable the product comment control field in WP Sheet Editor

Step 1: Enable "Comments" field columns

• Click on the upper right corner "Column Management(Columns manager)

• Find it in the "Disabled" list. "Comment." Fields (as shown)
• Drag the field to the "Enabled" area on the left, or click the "→" button on the right.

• Click on the green button "Application Settings" below

This step will make your "Comments" field appear in the form.

Step 2: Identify field types

can now be seen in the table named "Comments" column with the field value:

open (Pro) Indicates that comments are enabled for this product

(Pro) Indicates that the product has commenting disabled or the status is unknown, but the field is read-only

take note of: The (Pro) character you currently see indicates that the field belongs to the premium feature version of WP Sheet Editor and is not editable in the free version. If you want to change the comment status directly from the form (e.g. from open to closed), you need to upgrade to the Pro version.

Method 2: Batch modification using SQL statements (for technical users)

If you are familiar with database operations, you can also directly add thecomprehensive databaseExecute SQL commands to make batch changes.

Enable comments for all products:

UPDATE wp_posts
SET comment_status = 'open'
WHERE post_type = 'product'.

Disable all product comments:

UPDATE wp_posts
SET comment_status = 'closed'
WHERE post_type = 'product'.

Caveats:

• Backup database before execution
• You may need to clear your cache for the changes to take effect

Fourth, method three: the use of plug-ins to control site-wide comments

You can also use the plugin below if you want to control the comment switch uniformly across the store:

1. Disable Comments

• You can disable all comments on articles, pages, products, etc.
• Ideal for sites that don't plan to use a commenting system

2. Customer Reviews for WooCommerce

• Better suited for enabling comments and adding advanced features (e.g., purchase-only user comments, email alerts for comments, etc.)
• Support for automatic review and filtering mechanisms

V. Practical recommendations and operational norms

• Keep history when closing comments
• New product releases uniformly set comment rules
• Use with anti-spam plug-ins for extra peace of mind (e.g. Akismet(Antispam Bee)
• Reviews can be selectively reserved by product category

VI. Conclusion

WooCommerce Enabling or disabling the review function in batch can quickly unify the user interaction strategy for your products. Using either WP Sheet Editor or SQL tools, batch adjustments can be easily accomplished, avoiding repetitive manual operations and improving your customer review conversion and content quality.

Contact Us
Can't read the tutorial? Contact us for a free answer! Free help for personal, small business sites!	Customer Service
① Tel: 020-2206-9892
② QQ咨询：1025174874
(iii) E-mail: [email protected]
④ Working hours: Monday to Friday, 9:30-18:30, holidays off