Woo to Shopify Check

Shopify import error · from WooCommerce

Shopify CSV import: duplicate or empty option values on variants

Shopify refuses a product when two of its variants have exactly the same option values, or when a variant has no value for one of the options. Both happen often with WooCommerce exports, mostly because of “Any” variations.

Why it happens

In Shopify every variant is defined by its option values: “M / Blue” can exist only once per product, and every variant needs a value for every option the product has. WooCommerce is looser. A variation can be set to “Any Size”, which the export writes as an empty attribute value, and two variations can end up with the same attributes after edits, duplications or a plugin import.

An “Any” variation covers every value of the attribute at once. Shopify has no equivalent, so it has to become one variant per value; and if another variation already covers one of those values, the copies collide.

How the free check finds it

The check reads each variation’s attribute values. Where a value is empty it falls back to the values listed on the parent product and expands the variation into one variant per value, keeping the SKU on the first copy and leaving stock untracked on the others, since Shopify needs one SKU and one stock count per variant. Explicit variations are placed first, so an expanded copy never takes the place of a real variation. If two explicit variations share the same combination, the second is flagged as an error with the line of the first; an empty value with nothing on the parent to fall back on is an error too.

These are the findings the check reports for this problem, each with the lines of your file where it found them:

  1. Must fix

    Duplicate variant combination

    Shopify rejects the whole product when two variants have the same options.

    What to do: Delete the duplicate variation.

  2. Must fix

    Variant option without a value

    Shopify rejects variants with an empty option value.

    What to do: Set the value in WooCommerce or in the file.

  3. Changes silently

    “Any” variation expanded

    Shopify has no “any value” variant, so it becomes one variant per value; the SKU stays on the first and stock is not tracked on the copies.

    What to do: Set SKU and stock for each variant in Shopify.

Fix it by hand

  1. In WooCommerce, open each product the check flags and find the variation on the reported line.
  2. Delete duplicate variations, or change one attribute value so that every combination is unique.
  3. Replace “Any” variations with explicit ones where each value needs its own SKU, price or stock.
  4. After the import, set SKU and stock on the expanded variants in Shopify.

Find this in your own export, free

Upload your WooCommerce product export (and customers, if you like). In about a minute you see every row this affects, with line numbers, before anything touches Shopify. No account, no access to your store.

Run the free check See an example report

Other import errors

All Shopify import errors