eBay to Xero Contacts — Sync Buyers to Xero CRM

🥦

Convert Complete

Xero Contact CSV Format
valid rows

Build your Xero customer database from eBay order history. Extract unique buyers with shipping addresses, emails, and account references.

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

Download Sample

Sample eBay orders export CSV

Download

Tool Rating

4.6 / 5 (189 votes)

How It Works

1

Export eBay Orders

Seller Hub → Orders → Export to CSV (include as much history as needed)

2

Select Deduplication

Choose how to identify unique customers - username is most accurate

3

Preview Contacts

Review deduplicated contacts, check for any issues

4

Import to Xero

Upload via Contacts → All Contacts → Import

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 Ebay_Seller Orders fields map to Xero Contact

Ebay_Seller Orders Source Value Xero Contact Target Value Note
Buyer name John Smith → Name John Smith Contact name (required)
Buyer email john@example.com → EmailAddress john@example.com Primary email
Buyer phone +1-555-123-4567 → PhoneNumber +1-555-123-4567 Phone (may be masked)
Buyer username john_buyer123 → AccountNumber john_buyer123 eBay user ID as reference
Ship to address 1 123 Main Street → SAAddressLine1 123 Main Street Shipping address
Ship to city New York → SACity New York Shipping city
Ship to state NY → SARegion NY Shipping state/region
Ship to zip 10001 → SAPostalCode 10001 Shipping postal code
Ship to country US → SACountry US Shipping country

Data Transformation

Multiple orders from same buyer become single contact

Input eBay Orders

Order records with buyer info

Key columns: Buyer username, Buyer email, Buyer name
N:1 — Multiple input rows aggregate to one output row
Output Xero Contact 1 per unique buyer rows per input

Contact Record Deduplicated customer record
No duplicate contacts in output

Building Your Customer Database from eBay

eBay Doesn't Export Customers

Unlike other e-commerce platforms, eBay doesn't have a dedicated customer export. Your buyer information is scattered across order history. This tool extracts unique customers from orders and creates proper contact records for Xero.

Why Customer Data in Xero Matters

Having eBay customers in Xero enables invoicing repeat buyers, tracking sales by customer, creating quotes, and building marketing lists. It also speeds up invoice creation since contact info auto-fills from existing records.

Common Contact Import Errors

Issues you might encounter when importing Orders Report data to Contact - and how we solve them

Repeat Buyers in Export

Same buyer appears multiple times

john_buyer: 5 orders
john_buyer: 1 contact record

Deduplication keeps most recent info

All orders linked, but only one contact created

eBay Masked Email Address

eBay shows anonymized email

buyer123-abcd@members.ebay.com
Email field populated with masked address

Masked emails still work for eBay messaging

Update with real email if customer provides it

Phone Number Not Available

eBay may not export phone numbers

Buyer phone: (blank)
PhoneNumber: (empty)

Phone field left blank if not available

Add phone manually in Xero if needed

Same Person, Different Names

Buyer uses different shipping names

John Smith, J Smith, John D Smith
Deduplicated by username or email

Use username deduplication for accuracy

Merge contacts in Xero if needed

Why Use This Tool?

Automatic Deduplication

Smart deduplication by username, email, or name prevents duplicate contacts.

Address Extraction

Captures shipping addresses from orders as contact street addresses.

eBay ID Reference

Stores eBay username as account number for easy customer lookup.

Name Parsing

Automatically splits full names into first and last name fields.

Batch Processing

Handles years of order history efficiently with Xero-compatible batching.

Browser Privacy

Customer data processes locally. Never uploaded to external servers.

Frequently Asked Questions

eBay Username is most reliable - it's unique per buyer. Email works well but eBay may show masked addresses. Name-based deduplication is least accurate since the same person might ship to different names (gift orders, business vs personal).
We keep the most recent address when deduplicating. In Xero, you can add multiple addresses to a contact if needed. The primary address will be the latest shipping address from your export.
eBay shows anonymized emails like buyer123@members.ebay.com for privacy. These still work for eBay messaging. Real emails may not be available unless customers provide them directly.
Import contacts FIRST if you want addresses and details. When you import invoices, Xero matches by name or creates basic contacts. Pre-importing gives you complete contact records with addresses.
Our tool handles unlimited contacts and automatically batches for Xero's import limits. Large exports are split into multiple files packaged in a ZIP.
Xero matches by exact name. New names create new contacts. Existing names may create duplicates unless you use Xero's 'Update existing contacts' option during import. Review matches carefully.

Ebay Seller → Xero Data Ecosystem

All available data flows from Ebay Seller to Xero

Ebay Seller Orders Report eBay Seller Hub orders export with shipping details
→
Xero Contact Customer or supplier contact records
Buyer name → Name Buyer email → EmailAddress Buyer phone → PhoneNumber
Customer sync, supplier management
Ebay Seller Transaction Report eBay Managed Payments transaction report with sales, fees, and payouts
→
Xero Bank Statement Bank transactions for reconciliation
Transaction creation date → Date Net amount → Amount Gross transaction amount → Amount
Payout reconciliation, fee tracking
Ebay Seller Transaction Report eBay Managed Payments transaction report with sales, fees, and payouts
→
Xero Sales Invoice Sales invoices for accounts receivable (B2B, payment terms)
Buyer name → ContactName Buyer email → EmailAddress Order number → InvoiceNumber
B2B sales, invoiced orders, payment terms