Convert WooCommerce Customers to Xero Contacts: Free Customer Sync Tool

🥦

Convert Complete

Xero Contacts Import CSV Format
valid rows

Transform WooCommerce customer list into Xero contacts format with regional support

No API required
Browser-based processing
Run on Google Cloud Platform

Download Sample Customers

Example WooCommerce customer export

Download Sample

Tool Rating

4.9 / 5 (41 votes)

How It Works

1

Export Customers

Export customer list from WooCommerce or derive from orders

2

Upload & Convert

Upload customer CSV and download Xero-ready file

3

Import to Xero

Go to Xero > Business > Contacts > Import and upload the file

4

Import Invoices

Now import orders - contacts will link automatically

WooCommerce Customers to Xero Contacts

Optional but Recommended

Xero automatically creates contacts when importing invoices, so pre-importing customers is optional. However, importing customers first gives you more control over contact data and prevents duplicate contacts from slight name variations.

Benefits of Pre-Import

- Consistent names: Title Case formatting prevents duplicates - Complete data: Full addresses and phone numbers - Account numbers: Track customer IDs across systems - Better reporting: Clean customer list before invoices

Your Data is Safe

Bank-Level Security

256-bit SSL encryption. Same standards as major financial institutions.

No Data Storage

Files are processed directly in browser. No calls to our servers.

GDPR Compliant

Full EU data protection compliance. Your privacy rights protected.

ISO/IEC 27001 Certified GDPR Compliant Swiss Privacy CCPA Compliant

Field Mapping

How Woocommerce Customers fields map to Xero Contact

Woocommerce Customers Source Value Xero Contact Target Value Note
email john@example.com → EmailAddress john@example.com Primary email address
first_name John → FirstName John First name
last_name Doe → LastName Doe Last name
customer_id 42 → AccountNumber CUST-001 Customer account number/ID
address_1 123 Main St → AddressLine1 Street address line 1
address_2 Suite 100 → AddressLine2 Street address line 2
city New York → City City name
state NY → Region State/province/region
postcode 10001 → PostalCode Postal/ZIP code
country US → Country Country code
phone +1-555-123-4567 → PhoneNumber +1-555-123-4567 Primary phone number

Why Use This Tool?

Title Case Formatting

Formats names consistently to prevent Xero duplicate contacts (e.g., 'john smith' → 'John Smith')

Account Number Tracking

Uses WooCommerce customer IDs as Xero account numbers for cross-reference

Full Address Support

Maps complete billing addresses to Xero address fields

Email & Phone

Preserves contact information for customer communication

Company Handling

Uses company name for B2B customers when personal name is missing

Auto-Update on Re-Import

Xero updates existing contacts if email matches - safe to re-import

Data Transformation

Each WooCommerce customer becomes one Xero contact record

Input WooCommerce Customer

One row per customer from WooCommerce customer export

Key columns: email, first_name, last_name, phone, address_1
1:1 — One input row creates one output row
Output Xero Contact 1 rows per input

One contact record with full details

Contact Record Contact details with optional account number
ContactName formatted as Title Case for consistency

Common Contact Import Errors

Issues you might encounter when importing Customers Export data to Contact - and how we solve them

Duplicate Contact Name

Xero auto-creates contacts but may create duplicates with slight name variations

ContactName: 'john smith' vs 'John Smith'
Xero creates both as separate contacts

Use consistent name formatting (Title Case recommended)

Tool automatically applies Title Case formatting

Frequently Asked Questions

No, Xero auto-creates contacts from invoice imports. However, pre-importing gives you cleaner data with consistent naming (Title Case), full addresses, and customer IDs. It prevents duplicates like 'john smith' vs 'John Smith' appearing as separate contacts.
Xero creates separate contacts for names that don't match exactly. 'John Smith' and 'john smith' become two contacts. Our tool uses Title Case formatting ('John Smith') to prevent this issue.
Yes! If the email address matches an existing contact, Xero updates it instead of creating a duplicate. This makes it safe to re-import customer lists to update addresses or phone numbers.
Xero requires email or at least a contact name. Guest checkouts without emails should use a generic email (e.g., guest@yourstore.com) or be combined into a single 'Guest Customer' contact.

Woocommerce → Xero Data Ecosystem

All available data flows from Woocommerce to Xero

Woocommerce Customers Export WooCommerce customer/user data (one row per customer)
→
Xero Contact Customer or supplier contact records
first_name + last_name → ContactName email → EmailAddress first_name → FirstName
Customer sync, supplier management Current tool
Woocommerce Orders Export WooCommerce order data with line items (one row per product)
→
Xero Sales Invoice Sales invoices for accounts receivable (B2B, payment terms)
billing_first_name + billing_last_name → ContactName order_number → InvoiceNumber order_date → InvoiceDate
B2B sales, invoiced orders, payment terms
Woocommerce Products Export WooCommerce product catalog data (one row per product)
→
Xero Inventory Item Products and services for inventory tracking
SKU → ItemCode Name → ItemName Description → Description
Product catalog sync, inventory management