How to Use This Tool
Audit a SKU master locally with exact or normalized comparison. Check a CSV SKU column for blanks and duplicate values, preserving source row numbers and offering trim-and-case normalization before import.
The work this page finishes
Catalog imports can accept visually different whitespace or capitalization while downstream inventory systems normalize them into the same SKU. Keeping source order beside the computed artifact lets a user repair only the failed entries and reproduce the same batch later.
Deterministic workflow
Parse the first CSV column, preserve source row numbers, apply the selected exact or trim-and-case key and report the first occurrence of every duplicate. A run is capped at 5,000 items and 2 MB, preventing an accidental oversized paste while preserving successful rows when another row fails.
Why a dedicated interface helps
Correct the source master rather than deleting rows blindly; two duplicate SKU rows may represent products that need distinct identifiers. A purpose-built form exposes every assumption and returns the same ordered structure on every run, which is more practical than reconciling shifting conversational output.
Assumptions
- SKU is the first CSV column.
- The chosen normalization matches the destination system.
- Row numbers start at one for the supplied data.
Keep an untouched copy for comparison after import; the browser performs the work locally, but local software and extensions are not controlled by this page.
Limitations and review boundary
It does not understand marketplace-specific variant inheritance, barcode identity, Unicode confusables or business rules outside the selected normalization. The implementation neither follows user-entered links nor evaluates their contents, and it displays material as plain text rather than active HTML.
Verification and provenance
Fixtures derived from the displayed rule and RFC 4180 — Common Format and MIME Type for CSV Files were reviewed on 2026-08-26; they include normal, empty or invalid, and partial-failure behavior. The fixture returns two unique SKUs, one normalized duplicate and one blank row.
Sources & assumptions
Tool Spec v2 · verified 2026-08-26. Platform rules and fees can change; the editable inputs remain authoritative for your account.
Official references
- RFC 4180 — Common Format and MIME Type for CSV Files (checked 2026-08-26)
Model assumptions
- SKU is the first CSV column.
- The chosen normalization matches the destination system.
- Row numbers start at one for the supplied data.
- It does not understand marketplace-specific variant inheritance, barcode identity, Unicode confusables or business rules outside the selected normalization.
