WooCommerce Duplicate SKU Cleanup

Symptoms

• Exports show the same SKU on multiple products or variations.
• Inventory, fulfillment, support, or catalog tools cannot reliably identify the product a SKU represents.
• Product cloning, supplier imports, or variation setup created repeated temporary SKUs.

Most Common Causes

• SKUs are often copied during product cloning, inherited from parent products, or imported from supplier files without conflict checks.
• A business may use one SKU for a family of products internally while a feed or inventory tool expects one sellable item per identifier.
• Bulk edits can fix one duplicate while breaking variation, stock, or feed relationships.

How To Confirm The Cause

• Export product and variation rows with product ID, variation ID, SKU, product type, stock status, parent product, URL, category, and last modified date.
• Group duplicates by business meaning: accidental clone, parent fallback, supplier conflict, bundle, retired product, or deliberate shared identifier.
• Identify which external systems consume SKU values before changing them.

Fixes

• Create a SKU policy for simple products, variations, bundles, retired products, and supplier-managed catalogs.
• Resolve accidental duplicates one group at a time and preserve a mapping from old SKU to new SKU for support or fulfillment.
• Avoid deleting products as a cleanup shortcut unless redirects, order history, and reporting impact are approved.

How To Verify The Fix

• Re-export after cleanup and confirm each active sellable item has the intended SKU behavior.
• Test product pages, variation selection, cart, checkout, stock display, and feed output for changed products.
• Notify support, fulfillment, and campaign owners when SKU changes affect active workflows.

When To Contact Support

Escalate when SKUs are used by ERP, warehouse, accounting, marketplace, subscription, or fulfillment systems.