The Scenario
The WooCommerce migration project is wrapping up. The products are live. The store is configured. But the handoff note from the migration consultant says: "3,000 customer records still need to be created in Shopify — export is in the Excel workbook."
You open the workbook. First name, last name, email, phone. 3,000 rows.
You've done a product import. Customer imports are different. The Shopify CSV format for customers is not the same as for products. And after an hour of reading the import template documentation, the consultant is gone and the question is now yours to solve.
The bad version:
- Download Shopify's customer CSV template, map the workbook columns to the template fields.
- Discover that the CSV template wants address sub-fields that the WooCommerce export doesn't have, leaving half the import columns blank.
- Upload anyway, get an import report with 400 errors, none of them with enough detail to fix quickly.
The store is live. Customers need to be in the system before the loyalty program launch next week.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the customer data and creates each Shopify customer record via the API — no CSV template alignment required.
Read my WooCommerce Customers Excel export and create a Shopify customer for each row, writing the new Shopify customer ID back into column F
What You Get
- A Shopify customer record created for each row, with the assigned customer ID written back into column F.
- Rows that fail — typically duplicate emails — get an error message in column F instead of a silent skip.
- All customers appear in the Shopify admin immediately, ready for tag assignment and loyalty program enrollment.
What If the Data Is Not Quite Ready
Some phone numbers are in international format without the country code
Read my WooCommerce Customers Excel export and create a Shopify customer for each row — normalize phone numbers in column D to E.164 format assuming +1 country code if not present — write the customer ID into column F
Duplicate email addresses exist in the workbook and should be de-duplicated before importing
Read my WooCommerce Customers Excel export and create a Shopify customer for each row where column F is blank — skip any row where the email in column C already exists as a Shopify customer — write 'created' or 'duplicate' and the customer ID into column F
Customers from the B2B segment need a 'wholesale' tag applied on creation
Read my WooCommerce Customers Excel export and create a Shopify customer for each row — if column G says 'wholesale', apply the tag 'wholesale' — write the customer ID into column F
Normalize phones, skip duplicates, apply tier tag, confirm with IDs
For each row in my WooCommerce Customers Excel export where column F is blank, create a Shopify customer using first name (A), last name (B), email (C), phone (D, normalize to E.164) — apply tag from column G if not blank — skip rows where column C already exists in Shopify — write 'created' or 'duplicate' and customer ID into column F
Handling normalization, deduplication, and tagging in one pass means the import is clean without a pre-processing step.
Try It
Get the 7-day free trial of SheetXAI and open the WooCommerce customer export workbook sitting in the migration folder, then ask SheetXAI to create the Shopify records before the loyalty program launch. Future customer migrations from any platform will use the same pattern. Also worth reading: how to bulk update customer tags after the import, or the hub overview for all Shopify workflows.