· DataEase · Tutorials  · 2 min read

Bulk Delete Duplicate Products in Shopify

Finding and removing duplicate products manually can be extremely time-consuming. DataEase makes it easy: export your products, identify duplicates in Excel, mark the extras for deletion, and remove them in bulk with validation.

🎯 Goal

Find duplicate products, keep a single “canonical” record, and bulk-delete the rest using DataEase.

📋 Step-by-Step Instructions

1. Export Products (with Variant Identifiers)

In DataEase, go to New Export → Products. Include at minimum:

Product:

  • id
  • handle
  • title
  • vendor
  • status
  • createdAt

Variants:

  • variantId
  • variantSKU
  • barcode

Optional:

  • Media (with Group product media into single rows) if you want to review images

Tip: Use filters (e.g., by tag, vendor, collection, createdAt) to narrow the suspect set.

2. Identify Duplicates in Excel/Sheets

Open the exported file in Excel or Google Sheets. Common strategies to find duplicates:

Same Title + Vendor: Normalize casing/spaces and look for products with identical titles and vendors.

Same SKU set: Pivot by variantSKU or barcode to find products sharing the same variant identifiers.

Recently created copies: Sort by createdAt or by import batch tag to identify recently duplicated products.

Important: Keep exactly one product per duplicate group—the canonical one. Mark all others for deletion.

3. Prepare the Delete File

Keep only rows you want to remove and:

  • Set command = DELETE
  • Ensure the id column is present (required for deletion)

Save the file as .xlsx or .csv.

4. Import & Validate

  1. In DataEase, start New Import → Products
  2. Upload your edited file
  3. Map columns
  4. Run Validation

Review the Validation Status column and fix any issues.

5. Run the Import and Download the Results

After validation passes, click Run Import to delete the duplicate products from Shopify.

Once complete, download the results file and spot-check in Shopify Admin to confirm the duplicates were removed and the canonical products remain.

📝 Important Notes

  • Irreversible: Deleting a product removes its variants and media. Consider a backup export first
  • Orders aren’t affected: Past orders keep their line items even if the product is deleted
  • Safer alternative: If unsure, use ARCHIVED (status) instead of DELETE, so you can review later
  • Traffic/SEO: If deleted products had traffic, consider creating URL redirects from their handles to the canonical product (see Redirects guide)

💡 Minimal CSV Example

Delete by ID:

id,command
gid://shopify/Product/123,DELETE
gid://shopify/Product/456,DELETE

🎉 That’s it!

Your duplicate products are now removed in bulk.
If you run into any issues or have questions, feel free to contact our support team.

Share: