It is possible that WooCommerce product pages might display incorrect count of reviews. For example, it could happen after transferring reviews to a new site or after changing reviews data directly in the database on your WordPress site. There are two ways to update and correct the count of reviews.

Update Reviews Count by Submitting a New Review

One way to update the count of reviews and the average product rating is to manually submit a new review for the WooCommerce product. Here are the steps to follow:

  1. Navigate to the page of WooCommerce product with incorrect reviews count (on the frontend of your website).
  2. Submit a dummy review directly on the product page. Approve it, if necessary.
  3. The reviews count and the average rating should now be updated.
  4. Delete the dummy review you created on the step 2.

Note: if you enabled Reviews can only be left by "verified owners" checkbox in WooCommerce settings (on Products tab), you might need to temporary disable it to be able to submit a review on the step 2.


Update Reviews Count by Editing Product Meta in Database

Another way to update the count of reviews and the average product rating is to make changes directly in the database (e.g, via phpMyAdmin or other tool). This is not a recommended approach because direct edits in the database are dangerous and associated with a high risk of breaking down the website.

If you accept all the risks and still would like to update reviews count directly in the database, follow the steps below. Please make a full backup of the database and the website beforehand.

  1. Connect to the database and find wp_postmeta table. The table name includes a prefix wp. It is a site-specific prefix that can be different on your website.
  2. In wp_postmeta table, select a row according to these criteria:
    • post_id = ID of the product with incorrect reviews count
    • meta_key = _wc_review_count
  3. Update meta_value column in this row with the correct count of reviews.
  4. In wp_postmeta table, select a row according to these criteria:
    • post_id = ID of the product with incorrect average rating
    • meta_key = _wc_average_rating
  5. Update meta_value column in this row with the correct average rating of the product.