Woo to Shopify Check

Shopify import error · from WooCommerce

WooCommerce variations imported into Shopify as separate products, or not at all

After a WooCommerce to Shopify import, a T-shirt that had six sizes shows up as six products, or as one product without sizes. The link between the variations and their parent product was lost on the way.

Why it happens

In a WooCommerce export every variation is a row of its own, of type “variation”, and its Parent column points to the variable product, either as id:123 or as the parent’s SKU. Shopify’s CSV works the other way round: all variants of a product share the same URL handle. If the conversion does not follow the Parent reference, each variation becomes a product of its own.

The reference breaks in a few common ways: the parent is not in the file (the export was filtered by category, or the parent was deleted), two variable products share the same SKU so the Parent column is ambiguous, or the file was edited and the Parent column emptied.

How the free check finds it

The check resolves every Parent reference, both id:N and SKU. When a SKU matches several variable products it attaches the variation to the closest one above it and warns you; when the Parent column is empty it tries to match the product name and warns you that it did. Variations whose parent is missing are grouped into one Draft product so nothing is lost, and that product is flagged as an error so you review it before publishing. Variable products with no usable variation and disabled variations are reported 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

    Variations without their parent

    The parent product is missing or not variable, so the variations are grouped into a Draft product.

    What to do: Check its title, description and images before publishing.

  2. Changes silently

    Variation matches more than one parent

    Its parent SKU matches several variable products; it is attached to the closest one, which may be wrong.

    What to do: Make parent SKUs unique in WooCommerce and export again.

  3. Changes silently

    Variation attached by name

    The variation has no parent reference, so it is matched to a product by its name.

    What to do: Check that the variation belongs to that product.

  4. Must fix

    Variable product without variations

    There is nothing to sell, so it is imported as Draft with one default variant.

    What to do: Create the variants in Shopify.

  5. Good to know

    Disabled variation

    It is disabled in WooCommerce, so it is not imported.

    What to do: Add it in Shopify if you still sell it.

Fix it by hand

  1. Export again from WooCommerce > Products > Export without any category or type filter, so every parent is in the file.
  2. Make parent SKUs unique in WooCommerce.
  3. Review every Draft product built from orphan variations: its title, description and images come from the variations, not from the original parent.
  4. Recreate disabled variations in Shopify only if you still sell them.

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