Shopify CSV guide · reviewed August 20, 2026

Shopify CSV variant options missing? Check the dependencies first

Shopify’s current product CSV format uses Option1 name and Option1 value. If you update a variant-related field such as SKU or weight without those dependent columns, Shopify warns that it can create a default variant and delete existing variants. Review the dependencies before importing.

That behavior is documented in Shopify’s product CSV data dependencies. This guide explains the current format and a cautious preflight—not a guaranteed import result.

Which columns are required?

For a new product, Shopify says only Title is required. Adding variants also requires URL handle. Updating products requires both URL handle and Title. Variant-related fields add dependencies even when those are the only generally required columns.

Common current-format dependencies
When the CSV includes	Also review or include
`SKU` or `Weight value (grams)`	`Option1 name` and `Option1 value`
`Status`	A value of `active`, `draft`, or `archived`
`Price` or `Compare-at price`	A monetary number without a currency symbol
A product with variants	`URL handle` on the product and following variant rows

Current and older Shopify headers differ

The current documentation uses headers such as URL handle, Option1 name, Option1 value, SKU, and Price. Shopify says older templates can have different names and remain backward compatible, while recommending the current format for future compatibility.

Do not rename columns from memory. Start from a current export or Shopify’s sample, then verify the exact headers against the official column table.

Why an incomplete overwrite is risky

When “Overwrite products with matching handles” is selected, included columns can replace matching product data. Shopify states that a blank included non-required column can overwrite an existing value as blank, while an omitted column generally leaves that value unchanged.

Variant options are a specific exception to treat carefully: including a related field such as SKU without its option dependencies can remove the existing variant option and create a default variant. Changing option values can also create new variant IDs, which may affect third-party dependencies.

Preflight checklist before import

Confirm the file is UTF-8 and comma-delimited.
Keep Title and URL handle where your import type requires them.
Include Option1 name and Option1 value with variant-related changes.
Repeat the same URL handle on following variant rows for the same product.
Back up the catalog and test a small batch before a bulk overwrite.

Frequently asked questions

Does Shopify require a URL handle for every new product?

A new product without variants only requires Title. Shopify requires URL handle when adding variants, and both URL handle and Title when updating products.

Can I use an older Shopify CSV template?

Shopify says older column names remain backward compatible. It also recommends moving to the current format for the best experience and future compatibility.

Does a clean preflight guarantee the import?

No. It checks implemented CSV and Shopify rules, not your store configuration, apps, inventory locations, remote image availability, or every platform-side validation.

Sources and safe-import note

Primary sources: Shopify product CSV documentation and Shopify common import issues. Keep a current backup, review every warning, and test a small file in the intended store before a bulk import.