PREFLIGHT CHECK

Shopify Variant CSV Checker

Check that rows updating SKU, barcode, weight or inventory include the required Option1 name/value context before import.

Check CSV

🔒 Analysis runs in your browser; the file itself is not sent to BlueprintLab.

What this tool checks

  • Rows updating variant fields
  • Presence of Option1 name/value
  • Blank Option1 context

What it cannot determine

This unofficial checker covers only rules that can be verified in the browser. Live account settings, remote server state and later service-side validation remain authoritative.

How to use this tool

Check that rows updating SKU, barcode, weight or inventory also include the required Option1 name/value context.

  1. Use Try sample to inspect the included sample.
  2. Set + Choose a CSV file Tap/click to choose. Drag and drop also works on desktop..
  3. Use Check CSV to process the input.
  4. Compare the result with your source data and return to the input to make corrections.
+ Choose a CSV file Tap/click to choose. Drag and drop also works on desktop.
.csv,text/csv

Input and settings example

URL handle,Title,Option1 name,Option1 value,SKU,Weight value (grams)
sample-shirt,Sample Shirt,Size,M,SHIRT-M,250

A SKU-only edit can affect the variant structure

In Shopify product CSVs, variant-related fields such as SKU and weight depend on Option1 name/value when updating existing products. Importing variant data without the option context can remove existing variants or replace them with a default variant.

This checker finds rows where variant-related values are present but the Option1 context is missing or incomplete.

New simple products and updates are different

A new simple product can be created with a default variant and no explicit custom option. That is why completely missing Option1 context is a warning rather than a universal error. A half-filled name/value pair is treated as a structural error.

Making every missing Option1 an error would create false positives for valid new simple products.

Which columns count as variant-related?

The checker looks at SKU, Barcode, Price, Inventory quantity, Weight value (grams), and their legacy Shopify equivalents. Only rows containing those values are evaluated for the dependency.

Product-level edits such as Description or Vendor alone do not trigger this rule.

Safer update workflow

For an existing product SKU update, export the current product CSV and keep URL handle plus option columns intact while changing only the intended variant fields.

Test on a small set first, especially when external apps depend on variant IDs.