Woo to Shopify Check

Shopify import error · from WooCommerce

Shopify CSV import merged two products into one: duplicate URL handle

You imported your WooCommerce products and one Shopify product now carries the variants or images of another, or a product is simply missing. The usual cause is two products that ended up with the same URL handle.

Why it happens

Shopify’s product CSV has no product ID column: it groups rows into products by the URL handle (the Handle column in older templates). Every row with the same handle is read as one more variant or image of the same product. WooCommerce has no such rule for names: two products called “Classic T-shirt” live side by side, each with its own ID and its own slug, classic-t-shirt and classic-t-shirt-2.

When handles are built from product names, as most spreadsheet recipes and many export tools do, both products get classic-t-shirt and Shopify merges them. The second product’s prices, SKUs and images end up on the first one, or the import complains about options because the combined variants do not line up.

How the free check finds it

The check builds every handle the way WordPress builds slugs (accents removed, “&” turned into “and”, everything else into hyphens) and keeps a register of the handles already taken. When a second product would take the same handle, it gets -2, -3 the way WordPress de-duplicates slugs, and the row is flagged with both titles. If your export has no Slug column, the report also tells you that old product URLs were rebuilt from names, so you can spot-check them before importing the redirects.

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

  1. Changes silently

    Two products would share one URL

    Shopify URLs must be unique, so one of them gets a numbered URL.

    What to do: Rename one of the products if that URL matters to you.

  2. Changes silently

    Old URLs rebuilt from product names

    The export has no slug column, so the old product URLs for the redirects are rebuilt from names the way WordPress does it.

    What to do: Spot-check three old product URLs. If your permalinks differ, export with the slug column and check again.

Fix it by hand

  1. Open problems.csv from the free check and filter the code column on HANDLE_COLLISION: each line names both products.
  2. Decide which product keeps the clean URL (usually the one with more traffic or backlinks) and rename the other, in WooCommerce or directly in the URL handle column.
  3. Before importing, make sure no handle appears on rows with different titles: in Shopify’s CSV that always means one product.
  4. If you already imported, delete the merged product in Shopify and import the two products again with their separate handles.

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