Shopify CSV handles and variants: grouping and duplicate-handle pitfalls
In a Shopify product CSV, the Handle is how the importer knows multiple rows belong to the same product. Get handles wrong and you split one product into many—or merge unrelated SKUs under a single listing. This page stays close to how Shopify documents CSV structure in Using CSV files to import and export products.
What the handle is
Handles appear in storefront URLs and internal references. They should be stable for the life of a product unless you intentionally migrate SEO. During import, rows sharing a handle load as variants on one admin product.
Duplicate products after import
Duplicate listings usually mean the same physical item arrived under two different handles—often from a typo, invisible whitespace, or an accidental character from copy-paste. Normalize handles in a text tool that shows hidden characters before upload.
Variants that refuse to group
If Option columns disagree between rows—different option names, missing option values, or mixed casing conventions—the importer may still create a product, but you will see odd combinations or Missing variants in admin. Align Option1 Name across all rows for that handle, then do the same for Option2 and Option3. Related: variant options.
Updating vs creating
Importing with an existing handle updates that product when columns you include are meant to overwrite. Blank cells sometimes mean “do not change” and sometimes mean “clear,” depending on the field and workflow—always test on a duplicate dev store or a single SKU before bulk replacing live catalog data. Shopify’s import articles describe overwrite behavior for standard fields; do not assume blanks are neutral.
Handle strategy for large refreshes
Export first, edit in place, and keep a checksum column (internal note) if you automate transformations—so you can prove the handle did not drift between systems. See bulk update workflow.
FAQ
Are handles case-sensitive?
Treat them as case-sensitive in your process. Inconsistent casing between rows invites duplicate products when other tooling normalizes strings differently.
Can two products share a title but not a handle?
Yes. Title is display text; handle is identity for CSV joins.
What if I need to rename a handle?
Plan URL redirects and SEO updates separately. Renaming through CSV without a redirect strategy breaks inbound links to the old product URL.