Shopify CSV updates: catch mixed variant fields before an import

A Shopify product CSV can look structurally fine while one variant row quietly differs from the rest.

A useful pre-import review is to group rows by Handle, then inspect key variant fields across the group. If a field is filled on some variant rows and blank on others, stop and decide whether that difference is intentional before importing.

A small example

Handle,Title,Option1 Value,Variant SKU,Variant Inventory Tracker
cloud-tote,Cloud Tote,Blue,CT-BLU,shopify
cloud-tote,Cloud Tote,Red,,shopify

The blank SKU might be deliberate. It might also be an edit that was lost while preparing the update. The point is not to declare the row invalid; it is to make the difference visible before a full catalog import.

The same check is useful for these fields when they are included in the CSV:

• Option1 Value, Option2 Value, and Option3 Value
• Variant SKU
• Variant Weight
• Variant Inventory Tracker

Shopify's product CSV guidance is the source of truth for the columns and import workflow. For an update, work from a current export, keep an untouched copy, and test a small import before a full catalog change:

• https://help.shopify.com/en/manual/products/import-export/using-csv
• https://help.shopify.com/en/manual/products/import-export/import-products

I added this as a browser-local review in Catalog Preflight. It names the affected rows, keeps selected CSV files in the browser, and treats every result as a review prompt rather than an import guarantee.

Try the local checker here: https://catalog-preflight.pages.dev/shopify-csv-preflight-checker