Monday, 22 April 2019 09:02

How to Enable WooCommerce Product Reviews (Comments)?

If the reviews tab is missing on the single product page, this tutorial may also be beneficial to enable customer reviews for the products with the comment status turned off.

One of the most important elements on a product page is user generated content. This can take the form of pictures, reviews, star ratings, etc. All of this is called social proof. Social proof is a huge factor in someone else's purchase decision. Getting someone to buy a product from a random website is very hard. If you have a few reviews, that eases people's fears and they'll be more likely to buy. This tutorial will show you how to globally turn on reviews (comments) at once for every product using a single SQL query in phpMyAdmin.

Step 1. Configure Discussion Settings in WordPress

WooCommerce product reviews are handled the same way as comments in WordPress. This is because products are a custom post type and can receive comments if enabled. When a review is added to a product, it may be held for moderation or immediately become live depending on the WordPress comment settings.

Comment settings can be configured in the WordPress admin by visiting the Discussion Settings page:

Settings > Discussion

It is important to mention that the “Allow people to post comments on new articles” field should be checked if you want comments enabled by default for new posts and products.

How to Enable WooCommerce Product Reviews (Comments)

Step 2. Enable Reviews (Comments) in WooCommerce Settings

The next step is to enable product reviews in WooCommerce. This will add a reviews tab on the single product page for the customer reviews and product ratings.

WooCommece > Settings > Products (tab)

The following options are available:

Enable reviews:

  • Enable product reviews
  • Show “verified owner” label on customer reviews
  • Reviews can only be left by “verified owners”

Product ratings:

  • Enable star ratings on reviews
  • Star ratings should be required, not optional

How to Enable WooCommerce Product Reviews (Comments)

Step 3. Use phpMyAdmin to Enable Reviews (Comments) for All Products

This step will require access to phpMyAdmin. The hosting account cPanel will usually allow access. Once you have logged in:

  1. Select the WordPress database from the sidebar on the left.
  2. Click the SQL tab.
  3. Copy and paste the following code into the RUN SQL query/queries box.
  4. If you used a database prefix other than “wp_” then you will need to change wp_posts to match the database table name on the left sidebar.
  5. Click Go on the bottom right of the box to run the query.

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

How to Enable WooCommerce Product Reviews (Comments)

Final Thoughts

If you are unfamiliar or uncomfortable using phpMyAdmin, another solution is to use the One Click Close Comments plugin. It uses an AJAX-powered color code indicator (red means closed and green means open) on the post/product admin screens to update the comment status. You will still have to click each product one at a time, but the plugin is handy to visually determine which products have comments closed or open.

How to Enable WooCommerce Product Reviews (Comments)

If you want to close reviews (comments) for all products:

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

If you want to require a user to be logged in to review products:

UPDATE wp_posts SET comment_status = 'registered_only' WHERE post_type = 'product';

Don’t forget to backup your database first before making any changes to it!

Read 4840 times Last modified on Monday, 22 April 2019 09:58


  • Comment Link Tony Nguyen Friday, 27 September 2019 16:56 posted by Tony Nguyen

    @gene stewart: It seems like you are forget step #1: Select the WordPress database from the sidebar on the left.

  • Comment Link gene stewart Friday, 27 September 2019 02:31 posted by gene stewart

    After inserting the code UPDATE wp_posts SET comment_status = 'open' WHERE post_type = 'product'; and running Go, the return message was no dbase.

    We have no comment tabs showing on our product pages. We do have general discussion on a single page age via WP setting.
    WC settings are as you suggested.
    Your thoughts/help plz?

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.


Looking for a FREE WooCommerce Theme?

WooVina is an intuitive & flexible, free WordPress theme offering deep integration with WooCommerce. 100% Love It Guarantee!