{"id":270120,"date":"2026-01-07T16:15:04","date_gmt":"2026-01-07T16:15:04","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/rt-delete-duplicate-products-for-woocommerce\/"},"modified":"2026-05-13T14:49:29","modified_gmt":"2026-05-13T14:49:29","slug":"rt-delete-duplicate-products-for-woocommerce","status":"publish","type":"plugin","link":"https:\/\/it.wordpress.org\/plugins\/rt-delete-duplicate-products-for-woocommerce\/","author":23301688,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"3.0.0","stable_tag":"trunk","tested":"6.9.4","requires":"5.8","requires_php":"7.4","requires_plugins":null,"header_name":"RT Delete Duplicate Products for WooCommerce","header_author":"","header_description":"Identify and delete duplicate WooCommerce products efficiently with a modern React-based admin interface.","assets_banners_color":"877cad","last_updated":"2026-05-13 14:49:29","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"","header_author_uri":"","rating":0,"author_block_rating":0,"active_installs":20,"downloads":367,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":{"3.0.0":"

Major update with a fully rewritten architecture, new detection methods (SKU and Both), variable product support, and a rebuilt React interface. No configuration migration is required. Back up your database and test on a staging site before upgrading in production.<\/p>"},"ratings":[],"assets_icons":[],"assets_banners":{"banner-1544x500.png":{"filename":"banner-1544x500.png","revision":3531094,"resolution":"1544x500","location":"assets","locale":"","width":1544,"height":500},"banner-772x250.png":{"filename":"banner-772x250.png","revision":3531094,"resolution":"772x250","location":"assets","locale":"","width":1544,"height":500}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":[],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":3531094,"resolution":"1","location":"assets","locale":"","width":1737,"height":781}},"screenshots":{"1":"Detection Settings<\/strong> \u2014 Choose between Title, SKU, or Both detection methods and initiate a scan.","2":"Grouped Duplicates List<\/strong> \u2014 All duplicate groups with full product details: name, SKU, price, stock status, creation date, and action links.","3":"Product Selection<\/strong> \u2014 Select individual products or entire duplicate groups for bulk deletion.","4":"Confirmation Dialog<\/strong> \u2014 A safety modal that requires confirmation before permanently deleting selected products.","5":"Deletion Summary<\/strong> \u2014 Success report showing how many products were deleted and how many (if any) encountered errors."}},"plugin_section":[],"plugin_tags":[262801,262800,236386,286,262802],"plugin_category":[45],"plugin_contributors":[],"plugin_business_model":[],"class_list":["post-270120","plugin","type-plugin","status-publish","hentry","plugin_tags-clean-up-products","plugin_tags-delete-duplicates","plugin_tags-duplicate-products","plugin_tags-woocommerce","plugin_tags-woocommerce-cleanup","plugin_category-ecommerce","plugin_committers-raintech357"],"banners":{"banner":"https:\/\/ps.w.org\/rt-delete-duplicate-products-for-woocommerce\/assets\/banner-772x250.png?rev=3531094","banner_2x":"https:\/\/ps.w.org\/rt-delete-duplicate-products-for-woocommerce\/assets\/banner-1544x500.png?rev=3531094","banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/rt-delete-duplicate-products-for-woocommerce_877cad.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/rt-delete-duplicate-products-for-woocommerce\/assets\/screenshot-1.png?rev=3531094","caption":"Detection Settings<\/strong> \u2014 Choose between Title, SKU, or Both detection methods and initiate a scan."}],"raw_content":"\n

RT Delete Duplicate Products for WooCommerce<\/strong> is a fast, safe, and easy-to-use store cleanup tool that scans your WooCommerce catalogue for duplicate products and lets you permanently remove them in bulk \u2014 all from a modern React-powered admin interface inside your WooCommerce dashboard.<\/p>\n\n

Duplicate products accumulate through CSV imports, API syncs, migration scripts, and copy-paste mistakes. Left uncleaned, they damage your store's SEO rankings, confuse customers, and inflate your database. This plugin makes the cleanup process visual, controlled, and irreversible only when you say so.<\/p>\n\n

Why Duplicate Products Hurt Your Store<\/h4>\n\n
    \n
  • Duplicate product URLs compete against each other in search engines, splitting ranking authority and suppressing both listings.<\/li>\n
  • Customers landing on duplicated product pages see inconsistent pricing, stock levels, or descriptions \u2014 eroding trust.<\/li>\n
  • Orphaned product meta, variation records, and postmeta rows from duplicates bloat your database and slow down admin queries.<\/li>\n<\/ul>\n\n

    Key Features<\/h4>\n\n

    Three Detection Methods<\/strong>\nScan your entire product catalogue for duplicates using the method that fits your situation:<\/p>\n\n

      \n
    • By Title<\/strong> \u2014 finds all published products and product variations sharing an identical name.<\/li>\n
    • By SKU<\/strong> \u2014 queries the _sku<\/code> postmeta field and surfaces every product or variation sharing the same SKU. Empty SKUs are excluded automatically.<\/li>\n
    • By Both (Title + SKU)<\/strong> \u2014 runs both scans simultaneously, merges results into a single deduplicated list, so you see every duplicate regardless of how it was created.<\/li>\n<\/ul>\n\n

      Grouped Duplicate View<\/strong>\nResults are displayed as grouped sets \u2014 every duplicate group shows all products that share the same title or SKU together. For each product in a group you can see: product name, SKU, price, stock status, creation date, a direct edit link, and a frontend permalink. All the information you need to decide what to keep and what to delete \u2014 without leaving the page.<\/p>\n\n

      Bulk Selection and Deletion<\/strong>\nSelect individual products or an entire duplicate group in one click. Delete across multiple groups at once. The plugin reports exactly how many products were deleted and how many (if any) failed, so you always know the outcome.<\/p>\n\n

      Keep One, Delete the Rest<\/strong>\nFor any duplicate group, nominate one product to keep and automatically queue the rest for deletion \u2014 the safest and fastest way to resolve each group without manual cherry-picking.<\/p>\n\n

      Safe Deletion with Confirmation Guard<\/strong>\nEvery delete action requires an explicit confirmation step. A modal dialog asks you to confirm before anything is permanently removed \u2014 protecting you from accidental bulk deletions.<\/p>\n\n

      Permanent Deletion \u2014 Bypasses Trash<\/strong>\nProducts are force-deleted using WooCommerce's own $product->delete( true )<\/code> \u2014 they are not moved to trash. All associated postmeta is removed at the same time. This keeps the database clean and the operation final.<\/p>\n\n

      Full Variable Product and Variation Support<\/strong>\nWhen a variable product is deleted, the plugin first loops through and removes every child variation before deleting the parent. Variation products that are themselves duplicates can also be detected and deleted independently. No orphaned variation rows are left behind.<\/p>\n\n

      React-Powered Admin Interface<\/strong>\nBuilt with @wordpress\/scripts<\/code> and WordPress's own component library, the interface looks and feels native to WordPress 6.x. All scanning and deletion happens over a secure internal REST API \u2014 no page reloads. RTL layout is fully supported.<\/p>\n\n

      Secure REST API<\/strong>\nAll API endpoints under \/wp-json\/rtddpw\/v1\/<\/code> require the manage_woocommerce<\/code> capability. The scan endpoint validates the method parameter against an allowlist. The delete endpoint validates and sanitises every product ID before acting. Nonce verification is enforced throughout.<\/p>\n\n

      Who Is This Plugin For?<\/h4>\n\n
        \n
      • Store managers<\/strong> who have run product imports multiple times and ended up with hundreds of duplicate listings.<\/li>\n
      • Developers and agencies<\/strong> migrating a store from another platform and needing to clean up the imported catalogue quickly.<\/li>\n
      • Store owners<\/strong> whose WooCommerce admin is slow and suspect a bloated products table is the cause.<\/li>\n
      • SEO-focused merchants<\/strong> who need a clean catalogue with no duplicate URLs competing against each other in search results.<\/li>\n<\/ul>\n\n

        How It Works<\/h4>\n\n
          \n
        1. Go to WooCommerce \u2192 Delete Duplicates<\/strong> in your WordPress admin.<\/li>\n
        2. Choose your detection method: Title<\/strong>, SKU<\/strong>, or Both<\/strong>.<\/li>\n
        3. Click Scan for Duplicates<\/strong> \u2014 the plugin queries your database and returns grouped results instantly.<\/li>\n
        4. Review each group. View the name, SKU, price, stock status, creation date, and links for every product in the group.<\/li>\n
        5. Select the products you want to remove \u2014 individually, by group, or across all groups at once.<\/li>\n
        6. Click Delete Selected<\/strong> and confirm in the dialog.<\/li>\n
        7. The plugin permanently deletes selected products (and their variations if applicable) and shows a deletion summary.<\/li>\n<\/ol>\n\n

          Technical Details<\/h4>\n\n
            \n
          • Detection queries run directly against {prefix}_posts<\/code> and {prefix}_postmeta<\/code> using GROUP BY<\/code> and HAVING COUNT(*) > 1<\/code> \u2014 no full table scans.<\/li>\n
          • Scans cover post_type IN ('product', 'product_variation')<\/code> and post_status = 'publish'<\/code> only. Drafts, pending, private, and trashed products are excluded.<\/li>\n
          • Admin page is mounted under WooCommerce \u2192 Delete Duplicates<\/strong> and gated by the manage_woocommerce<\/code> capability.<\/li>\n
          • REST API namespace: rtddpw\/v1<\/code>. Endpoints: GET \/duplicates?method=title|sku|both<\/code> and POST \/delete<\/code>.<\/li>\n
          • Built with the @wordpress\/scripts<\/code> build toolchain; dependencies resolved via index.asset.php<\/code>.<\/li>\n
          • Singleton pattern ensures a single plugin instance throughout the request lifecycle.<\/li>\n
          • Internationalisation-ready \u2014 all user-facing strings use __()<\/code> and _n()<\/code> with text domain rt-delete-duplicate-products-for-woocommerce<\/code>.<\/li>\n
          • RTL stylesheet (index-rtl.css<\/code>) included and loaded automatically for right-to-left languages.<\/li>\n<\/ul>\n\n\n

            Automatic Installation<\/h4>\n\n
              \n
            1. Log in to your WordPress admin panel.<\/li>\n
            2. Navigate to Plugins \u2192 Add New<\/strong>.<\/li>\n
            3. Search for RT Delete Duplicate Products for WooCommerce<\/strong>.<\/li>\n
            4. Click Install Now<\/strong>, then Activate<\/strong>.<\/li>\n<\/ol>\n\n

              Manual Installation<\/h4>\n\n
                \n
              1. Download the plugin .zip file.<\/li>\n
              2. Go to Plugins \u2192 Add New \u2192 Upload Plugin<\/strong>.<\/li>\n
              3. Upload the .zip and click Install Now<\/strong>.<\/li>\n
              4. After installation, click Activate Plugin<\/strong>.<\/li>\n<\/ol>\n\n

                After Activation<\/h4>\n\n
                  \n
                1. Make sure WooCommerce<\/strong> is installed and active \u2014 the plugin will deactivate itself and display an admin notice if WooCommerce is missing.<\/li>\n
                2. Navigate to WooCommerce \u2192 Delete Duplicates<\/strong>.<\/li>\n
                3. Choose a detection method and scan your catalogue.<\/li>\n<\/ol>\n\n\n
                  \n

                  Does this plugin require WooCommerce?<\/h3><\/dt>\n

                  Yes. WooCommerce must be installed and active. The plugin checks for the WooCommerce<\/code> class both on activation and on every load. If WooCommerce is missing, the plugin deactivates itself and shows an admin notice.<\/p><\/dd>\n

                  What detection methods are available?<\/h3><\/dt>\n

                  Three methods are supported. Title<\/strong> finds products sharing the same product name. SKU<\/strong> finds products sharing the same _sku<\/code> meta value (blank SKUs are excluded). Both<\/strong> runs both scans and merges results, so you see every duplicate from either method in a single grouped list.<\/p><\/dd>\n

                  Does the plugin handle variable products and their variations?<\/h3><\/dt>\n

                  Yes. When a variable product is deleted, all of its child variations are deleted first, preventing orphaned records. Individual variation products can also be detected as duplicates in their own right and deleted independently.<\/p><\/dd>\n

                  Are deletions permanent? Can I undo them?<\/h3><\/dt>\n

                  Yes, deletions are permanent. The plugin uses WooCommerce force-delete ($product->delete( true )<\/code>), which bypasses the trash and removes all associated product metadata immediately. A confirmation dialog is always shown before any delete action. Always back up your database before running bulk deletions.<\/p><\/dd>\n

                  What product information is displayed for each duplicate?<\/h3><\/dt>\n

                  Each product in a group shows its name, SKU, price, stock status, creation date, a direct WordPress edit link, and the frontend product permalink \u2014 enough to compare duplicates side-by-side and decide which one to keep.<\/p><\/dd>\n

                  Can I keep one product and delete the rest of a group automatically?<\/h3><\/dt>\n

                  Yes. The Keep One, Delete the Rest<\/strong> option lets you nominate which product to keep, then automatically queues all others in that group for deletion.<\/p><\/dd>\n

                  Who can access the Delete Duplicates page?<\/h3><\/dt>\n

                  Only users with the manage_woocommerce<\/code> capability \u2014 typically WordPress Administrators and WooCommerce Managers. The REST API endpoints enforce the same capability check on every request.<\/p><\/dd>\n

                  Will scanning slow down my site?<\/h3><\/dt>\n

                  Detection queries use optimised SQL and run only when you click Scan \u2014 they are never triggered automatically or on page load. For very large catalogues (10,000+ products), the scan may take a few seconds but will not affect your store's frontend performance.<\/p><\/dd>\n

                  Does this plugin affect draft or trashed products?<\/h3><\/dt>\n

                  No. The duplicate detector filters for post_status = 'publish'<\/code> only. Drafts, pending, private, and trashed products are never included in scan results.<\/p><\/dd>\n

                  Is RTL language layout supported?<\/h3><\/dt>\n

                  Yes. A dedicated RTL stylesheet (index-rtl.css<\/code>) is included and loaded automatically for right-to-left languages.<\/p><\/dd>\n

                  Does this plugin work on WordPress Multisite?<\/h3><\/dt>\n

                  Yes. The plugin functions on Multisite installations when activated per-site.<\/p><\/dd>\n\n<\/dl>\n\n\n

                  3.0.0<\/h4>\n\n
                    \n
                  • Full architectural refactor using the singleton pattern for safe, predictable initialisation.<\/li>\n
                  • REST API updated to namespace rtddpw\/v1<\/code> with GET \/duplicates<\/code> and POST \/delete<\/code> endpoints.<\/li>\n
                  • All REST endpoints now require manage_woocommerce<\/code> capability with nonce verification.<\/li>\n
                  • Detection updated to scan both product<\/code> and product_variation<\/code> post types.<\/li>\n
                  • Variable product deletion now removes all child variations first, preventing orphaned variation rows.<\/li>\n
                  • Added \"Keep One, Delete the Rest\" workflow per duplicate group.<\/li>\n
                  • Product detail view expanded to include price, stock status, creation date, edit URL, and frontend permalink.<\/li>\n
                  • React admin UI rebuilt with @wordpress\/scripts<\/code> and WordPress component library.<\/li>\n
                  • RTL stylesheet added for right-to-left language support.<\/li>\n
                  • Full internationalisation implemented across all user-facing strings.<\/li>\n
                  • Improved validation and sanitisation on the REST delete endpoint.<\/li>\n<\/ul>\n\n

                    1.0.0<\/h4>\n\n
                      \n
                    • Initial release \u2014 basic duplicate detection by title, bulk deletion, and confirmation dialog.<\/li>\n<\/ul>","raw_excerpt":"Find and permanently delete duplicate WooCommerce products by title, SKU, or both \u2014 with bulk selection, group controls, and a built-in confirmation g …","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/it.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/270120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/it.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/it.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/it.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=270120"}],"author":[{"embeddable":true,"href":"https:\/\/it.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/raintech357"}],"wp:attachment":[{"href":"https:\/\/it.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=270120"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/it.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=270120"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/it.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=270120"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/it.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=270120"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/it.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=270120"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/it.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=270120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}