Shopify import error · from WooCommerce
Shopify CSV import: duplicate SKUs or missing SKUs from WooCommerce
Shopify accepts a product file where two variants share a SKU, or where variants have none. The trouble starts afterwards, in the apps that rely on SKUs.
Why it happens
WooCommerce normally refuses duplicate SKUs in its admin, but duplicates still reach the export: products imported by a supplier plugin, variations created by “Any” attributes, products duplicated and never edited. Shopify itself does not require SKUs to be unique, so the import goes through silently.
Inventory sync, ERPs, marketplace feeds and many fulfilment apps match on SKU. With two variants on the same SKU, stock and orders can land on the wrong one; with no SKU, those apps cannot match the variant at all.
How the free check finds it
The check registers every SKU it meets across products and variations. A SKU seen before is flagged with the line where it first appeared; a variant without a SKU is reported as informational, since many small stores do not use them. When an “Any” variation is expanded into several variants, the SKU stays on the first copy only, so the expansion never creates duplicates of its own.
These are the findings the check reports for this problem, each with the lines of your file where it found them:
- Changes silently
Same SKU used twice
Two products or variants share one SKU. Inventory and order apps match on SKU, so stock and orders can land on the wrong one.
What to do: Make every SKU unique.
- Good to know
Variant without SKU
It imports, but inventory, order and marketplace apps match products on SKU.
What to do: Add SKUs in Shopify if you use those apps.
Fix it by hand
- Use the line numbers in the report to find both rows of each duplicate and decide which variant keeps the SKU.
- Give the other one a new SKU, in WooCommerce or in the Shopify CSV, before importing.
- If you use inventory, ERP or marketplace apps, add SKUs to the variants reported without one.
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.