Shopify import error · from WooCommerce
Shopify customer CSV import errors: phones, emails and countries from WooCommerce
The customer import stops, or skips rows, most often because of phone numbers. WooCommerce stores billing details as customers typed them at checkout; Shopify is strict about them.
Why it happens
Shopify needs every customer to have an email or a phone, wants phones in international format, and does not allow two customers with the same email or the same phone. Countries and provinces are codes (IT, US, CA), not names. WooCommerce billing phones are free text, like 333 123 4567, 0039 333…, or (555) 010-1234, and families or companies often share one number across several accounts.
Two things never come across by CSV: passwords, which WordPress stores hashed and Shopify cannot reuse, and proof of marketing consent, which the export does not carry.
How the free check finds it
The check reads the WooCommerce billing columns (billing_email, billing_phone, billing_country and the rest), validates every email and skips exact duplicates, naming the line of the first. Phones are converted to international format using the billing country; a number it cannot convert is moved to the customer note instead of breaking the import, and a phone already used by another customer is left empty and noted. Customers with neither an email nor a valid phone are listed, as are country values that are not two-letter codes. Marketing consent is set to “no” for everyone, because the export carries no proof of it.
These are the findings the check reports for this problem, each with the lines of your file where it found them:
- Changes silently
Phone not in international format
Shopify needs international phone numbers; the original is kept in the customer note.
What to do: Add the country code in Shopify.
- Changes silently
Same phone on two customers
Shopify requires unique phones; the second one is left empty and kept in the note.
What to do: Check whether they are the same person.
- Must fix
Invalid customer email
Shopify does not accept it, so the customer is skipped.
What to do: Fix the address and add the customer by hand.
- Must fix
Same email on two customers: one is not imported
Shopify needs unique emails, so the second record is left out of customers.csv. Anything only in that record is lost.
What to do: Merge the two records in WooCommerce before exporting, or add the missing details in Shopify after import.
- Must fix
Customer without email or phone
Shopify needs one of the two, so the customer is skipped.
What to do: Add an email or phone and create the customer by hand.
- Changes silently
Country not recognised
Shopify needs a two-letter country code, so the country is left empty.
What to do: Set the country in Shopify.
- Good to know
Customer passwords cannot be moved
No migration can move passwords to Shopify; customers choose a new one.
What to do: Send account invites from Shopify after the import.
- Good to know
Email marketing consent set to no
The export carries no proof of consent, so nobody is subscribed by default.
What to do: Import your newsletter list separately if you have consent records.
Fix it by hand
- Fix or merge the customers the check skips, using the line numbers in the report.
- After the import, send account invites from Shopify so customers can set a new password.
- Import newsletter subscribers separately, from the list where you hold their consent.
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.