Find and repair duplicate product listings

Two listings with similar names may be duplicates, or they may represent genuinely different products. Deleting one quickly can break a link or remove the record needed to understand an older order.

Investigate identity before cleaning the catalogue. The goal is one clear representation of each intended offer, not simply a lower record count.

Define what makes two records the same

Compare the physical product, variant, unit, specification and fulfilment arrangement. Matching titles or photographs alone are not enough.

A single piece and a pair may use the same image while being different offers. An older material version may look similar but need its own history.

Write down the basis for calling a record a duplicate rather than relying on a visual impression.

Check stable references

Inspect internal identifiers, supplier references and any supported stock codes. Look for repeated identifiers attached to different records or one item split across several unrelated balances.

Do not assume the public title is the matching key. Titles can change and different items can share a generic name.

If the data came from an import, review the source mapping and repeat-run behaviour. An importer may create new records when the intended operation was an update.

Trace connected records before changing anything

Identify links to orders, inventory, categories, campaigns and external catalogues where applicable. Use authorised read access and avoid exposing customer information in the cleanup report.

A duplicate that has never been used may be simpler to retire than one connected to historical orders. Do not treat both cases as equivalent.

Keep a recovery record appropriate to the change. A screenshot of the public page is not a complete backup of its relationships.

Choose the canonical offer

Decide which record should remain the current public destination and why. It should contain the correct specification, options and supported connections.

Do not choose only the newest record if the older one carries important order or stock relationships. The platform's supported merge or retirement process may determine the safe approach.

If no safe merge exists, document an archival or redirect strategy with the responsible technical owner rather than improvising a destructive edit.

Reconcile stock separately

Two duplicate listings do not mean twice the physical stock exists. Check whether each record has a separate balance and whether commitments have been made against both.

Do not combine quantities automatically without a physical and transactional reconciliation. That can preserve or amplify the original error.

Use the inventory guide to distinguish available stock from held quantities and to document corrections.

Repair public destinations

Check active links from campaigns, categories and guides. If a record is retired, use the platform's supported destination handling and verify the result.

Do not silently redirect an old offer to a materially different product. The destination should be honest about what the customer is seeing.

Update saved replies and product references used by helpers so the duplicate does not continue receiving new enquiries.

Test after the correction

Inspect the current public page, variant selection and relevant stock behaviour through an authorised test process. Check that historical records remain understandable.

Compare counts with the intended result, but do not rely on counts alone. One removed duplicate and one accidentally removed genuine product can cancel each other numerically.

Record unresolved exceptions instead of claiming the catalogue is clean when some relationships remain unknown.

Prevent recurrence

Fix the cause: unstable import keys, unclear product creation rules or several people independently adding the same item.

Create a quick check before a new record is added. Search the existing range by reference and product identity, not only the proposed title.

Use catalogue preparation for complete new records. Duplicate cleanup succeeds when the current offer is clear and the history still makes sense—not when similar-looking rows have been deleted as quickly as possible.

Keep a rollback record of the old references and their destinations. If a customer or fulfilment worker later reports a missing item, that record lets you investigate the specific change instead of reconstructing it from memory.