Ecommerce · catalog identity

Find variant collisions.

Open a local CSV and catch duplicate SKUs, barcodes and product-option combinations before a marketplace import turns them into ambiguous inventory.

15 MB / 100,000 rowsNo API or uploadRules checked 3 October 2026

How to find duplicate SKUs in a product CSV

  1. Open a CSV file from your device, or paste the CSV text.
  2. Press Check collisions.
  3. Read the list of duplicate SKUs, barcodes and option combinations, then download the report.

Why collisions cause trouble

Two variants sharing a SKU can make a marketplace import overwrite one product with another, merge inventory counts or reject a whole file. Duplicate barcodes confuse scanners and listing feeds in the same way. Identical option combinations on one product, such as two rows for Blue and Small, create variants nobody can tell apart. Catching them before import is far cheaper than cleaning up stock afterwards.

Identifiers are compared after trimming and collapsing whitespace, so BLUE-S and blue-s count as a collision. When product handle and option columns are present, option combinations are checked within each product. The tool cannot tell whether a SKU is unique across your whole business, whether a barcode was actually issued to you or whether a marketplace will accept a particular identifier.

Your catalogue stays private

The checker runs in your browser, inside an isolated frame on this page that has no network access. Your file is read and written back by your own device, so it is not uploaded to TNAADO or anyone else, and nothing is stored. The advertising on this page sits outside the frame and cannot see what you choose. A product list is commercially sensitive, so it is read as text on your device only.

What this finds

Identifiers are compared after trimming and collapsing whitespace, so BLUE-S and blue-s collide. When a product handle and option columns are present, the tool also checks duplicate option combinations within the same product. It does not decide whether a SKU is globally unique across your business, whether a barcode was issued to you, or whether a marketplace accepts a particular identifier.

Sources: Shopify product CSV Help describes handles, variants and barcode fields; GS1 identification standards explain that GTINs identify trade items. These are format and collision checks, not marketplace certification.

Frequently asked questions

Does a clean report mean the import will work?

No. It cannot see existing records in your store, inventory locations, or marketplace-specific rules. Use the platform’s own import preview.

Is the file uploaded?

No. Parsing and report generation happen locally in this browser tab.

Collision check only

A pass is not proof that an identifier is authentic, registered to you, or accepted by any marketplace.

Advertisement
Advertisement