How to detect duplicate products in a product catalogue csv
- Step 1Export the product catalogue CSV — Download from your PIM, ERP, or supplier.
- Step 2Drop into CSV Duplicate Finder — Select the SKU or Barcode column as the key.
- Step 3Review flagged duplicates — Compare the duplicate rows to identify which has the correct data.
- Step 4Resolve and import — Remove incorrect duplicates and import the clean catalogue.
Frequently asked questions
Can I check for duplicates on both SKU and barcode at once?+
Yes. Select both columns to flag rows that are duplicate on either or both fields.
What if I want to keep the most recent duplicate row?+
Sort by date column descending first, then the first occurrence of each SKU in the flagged file will be the newest.
Does this work for Shopify product exports with variants?+
Yes. Select the Variant SKU column to check variant-level duplicates.
Privacy first
Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.