[WordPress] 外掛分享： RT Delete Duplicate Products for WooCommerce

內容簡介

總結：Delete Duplicate Products for WooCommerce 是一個功能強大的工具，可幫助您識別並從您的 WooCommerce 商店中刪除重複產品。此外，該外掛還擁有現代化的 React 介面，使用 WordPress 最新的技術堆棧構建而成。

問題與答案：
1. Delete Duplicate Products for WooCommerce 是什麼功能？
- 這是一個幫助您識別和刪除 WooCommerce 商店中重複產品的強大工具。
2. Delete Duplicate Products for WooCommerce 的特點有哪些？
- 可透過產品標題、SKU或兩者來查找重複項目
- 採用現代化的 React 介面，使用 @wordpress/scripts 和 WordPress 組件構建
- 支持批量操作，一次選擇並刪除多個重複產品
- 具有安全功能，確認對話框可防止意外刪除
- 可查看產品詳細信息後再刪除
- 支持組別選擇，一鍵選擇整個重複組
- 資料庫查詢經過優化

3. Delete Duplicate Products for WooCommerce 如何操作？
- 進入到 WooCommerce > 刪除重複品
- 選擇您的檢測方法（標題、SKU或兩者）
- 點擊 "掃描重複品"
- 查看按相似度分組的重複產品
- 選擇要刪除的產品
- 確認刪除操作

4. Delete Duplicate Products for WooCommerce 的技術特點是什麼？
- 使用 @wordpress/scripts（WordPress 官方構建工具）
- 使用 WordPress 組件實現統一的 UI
- REST API 集成，包含正確的 nonce 驗證
- 正確處理產品變體
- 優化資料庫查詢
- 支援國際化功能

外掛標籤

開發者團隊

原文外掛簡介

RT Delete Duplicate Products for WooCommerce 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 — all from a modern React-powered admin interface inside your WooCommerce dashboard.
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.
Why Duplicate Products Hurt Your Store

Duplicate product URLs compete against each other in search engines, splitting ranking authority and suppressing both listings.
Customers landing on duplicated product pages see inconsistent pricing, stock levels, or descriptions — eroding trust.
Orphaned product meta, variation records, and postmeta rows from duplicates bloat your database and slow down admin queries.

Key Features
Three Detection Methods
Scan your entire product catalogue for duplicates using the method that fits your situation:

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

Grouped Duplicate View
Results are displayed as grouped sets — 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 — without leaving the page.
Bulk Selection and Deletion
Select 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.
Keep One, Delete the Rest
For any duplicate group, nominate one product to keep and automatically queue the rest for deletion — the safest and fastest way to resolve each group without manual cherry-picking.
Safe Deletion with Confirmation Guard
Every delete action requires an explicit confirmation step. A modal dialog asks you to confirm before anything is permanently removed — protecting you from accidental bulk deletions.
Permanent Deletion — Bypasses Trash
Products are force-deleted using WooCommerce’s own $product->delete( true ) — they are not moved to trash. All associated postmeta is removed at the same time. This keeps the database clean and the operation final.
Full Variable Product and Variation Support
When 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.
React-Powered Admin Interface
Built with @wordpress/scripts 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 — no page reloads. RTL layout is fully supported.
Secure REST API
All API endpoints under /wp-json/rtddpw/v1/ require the manage_woocommerce 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.
Who Is This Plugin For?

Store managers who have run product imports multiple times and ended up with hundreds of duplicate listings.
Developers and agencies migrating a store from another platform and needing to clean up the imported catalogue quickly.
Store owners whose WooCommerce admin is slow and suspect a bloated products table is the cause.
SEO-focused merchants who need a clean catalogue with no duplicate URLs competing against each other in search results.

How It Works

Go to WooCommerce → Delete Duplicates in your WordPress admin.
Choose your detection method: Title, SKU, or Both.
Click Scan for Duplicates — the plugin queries your database and returns grouped results instantly.
Review each group. View the name, SKU, price, stock status, creation date, and links for every product in the group.
Select the products you want to remove — individually, by group, or across all groups at once.
Click Delete Selected and confirm in the dialog.
The plugin permanently deletes selected products (and their variations if applicable) and shows a deletion summary.

Technical Details

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