---
title: How to Clean Up Duplicate and Orphaned Reviews in ReviewX
description: "When migrating reviews from third-party platforms, importing multi-vendor CSV spreadsheets, or running automated storefront testing, duplicate reviews and orphaned comment entries can accumulate in your WordPress database. Redundant reviews distort product aggregate rating statistics, confuse potential buyers, and violate Google…"
url: "https://reviewx.io/docs/how-to-clean-up-duplicate-and-orphaned-reviews-in-reviewx/"
updated: "2026-10-05"
category: Configuration
---

# How to Clean Up Duplicate and Orphaned Reviews in ReviewX

When migrating reviews from third-party platforms, importing multi-vendor CSV spreadsheets, or running automated storefront testing, duplicate reviews and orphaned comment entries can accumulate in your WordPress database. Redundant reviews distort product aggregate rating statistics, confuse potential buyers, and violate Google Rich Snippets structured data guidelines. **ReviewX** features a native **Duplicate Review Cleanup Scanner** in `wp-admin` to detect and resolve duplicate records automatically.

  ![ReviewX Duplicate and Orphaned Review Cleanup Scanner Tool](https://reviewx.io/wp-content/uploads/2026/10/rvx_duplicate_reviews_cleanup_annotated.png)

Preserve Primary Customer Testimonials

The cleanup scanner groups duplicates by matching author email, comment content, and product ID. It retains the original, verified primary review while safely purging redundant duplicates without data loss.

## Step-by-Step: Scanning and Removing Duplicate Reviews

1. Navigate to `wp-admin → ReviewX → Tools` (`admin.php?page=reviewx_tools`).
2. Click on the **Duplicate reviews** tab at the top of the interface.
3. Click the **Scan duplicate reviews** button (marked with **Badge 1**) to analyze your store database.
4. Review the diagnostic metrics:
   - **Scanned Posts:** Total number of WooCommerce products, pages, and custom post types analyzed.
   - **Duplicate Groups:** Number of clusters containing identical or redundant reviews.
   - **Cleanable Reviews:** Exact count of redundant review entries eligible for immediate removal.
5. Inspect the detected duplicate groups table (marked with **Badge 2**):
   - **Post Title:** The target WooCommerce product.
   - **Reviewer:** The customer author name and email.
   - **Feedback Preview:** Excerpt of the review body text.
   - **Keep Review:** The primary original review ID that will be preserved.
6. Click **Remove duplicates** to purge redundant records and recalculate product rating averages.

## Preventing Future Duplicate Review Issues

| Preventative Setting | Location in ReviewX | Protective Action |
| --- | --- | --- |
| **Single Review Per Customer** | `ReviewX → Reviews → Review settings` | Disable *Multiple reviews per customer* so buyers can submit only one review per item. |
| **Verified Purchasers Only** | `ReviewX → Reviews → Review settings` | Restrict submission to verified buyers who purchased the product in completed orders. |
| **Cloud Data Sync** | `ReviewX → Tools → Data sync` | Trigger a manual sync after bulk imports to ensure WordPress and ReviewX SaaS caches remain aligned. |
