Import WooCommerce to Xero: Complete Import Guide with Regional Formatting

🥦

Import Complete

Xero Invoice Import CSV Format
valid rows

Step-by-step guide to import WooCommerce orders and products into Xero with correct formatting

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

Download Sample WooCommerce Orders

Example WooCommerce order export

Download Sample

Tool Rating

4.9 / 5 (76 votes)

How It Works

1

Export from WooCommerce

Export orders and products from WooCommerce Analytics or export plugins

2

Select Your Region

Choose your Xero organization region (US, UK, AU, NZ) for correct date formatting

3

Convert Files

Use our converter to format exports for Xero import requirements

4

Import Invoices

Go to Xero > Business > Invoices > Import and upload invoice CSV

5

Import Items (Optional)

Import products as Xero items for better reporting and inventory tracking

WooCommerce to Xero Import Benefits

Easier Than QuickBooks

Xero advantages for WooCommerce import: - Auto-creates contacts - No need to pre-import customers - 500 invoices per import - Generous batch limits - All editions support import - No need for expensive editions - Better multi-currency - Native support for international sales

Regional Formatting Required

Xero requires region-specific date formats: - US: MM/DD/YYYY (e.g., 01/15/2024) - UK/AU/NZ: DD/MM/YYYY (e.g., 15/01/2024) Tax types must also match your region exactly (e.g., "20% (VAT on Income)" for UK).

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

Woocommerce Orders Source Value Xero Invoice Target Value Note
order_number #12345 → InvoiceNumber #12345 Unique invoice identifier with prefix
order_date 2024-01-15 14:30:00 → InvoiceDate 2024-01-15 14:30:00 Convert to DD/MM/YYYY or MM/DD/YYYY based on region
product_name Blue Widget → Description Blue Widget Product description for line item
quantity 2 → Quantity 2 Line item quantity
tax_label NY State Tax → TaxType NY State Tax Map WooCommerce tax to Xero tax type

Why Use This Tool?

Auto-Contact Creation

Xero automatically creates contacts from invoices - no pre-import needed!

Regional Date Formats

Tool formats dates correctly for US, UK, AU, or NZ Xero organizations

Tax Type Mapping

Maps WooCommerce taxes to exact Xero tax type names by region

500 Invoice Batches

Import up to 500 invoices per file (vs QuickBooks' 100 limit)

Product Catalog Sync

Import WooCommerce products as Xero inventory items with SKU linking

Multi-Currency Support

Native support for international WooCommerce stores

Data Transformation

Multiple line items become one multi-line invoice

Input Order Line Items

One row per product in order

Key columns: order_id, product_name, quantity, line_subtotal
N:1 — Multiple input rows aggregate to one output row
Output Xero Invoice Lines aggregated rows per input

Multi-line invoice grouped by InvoiceNumber

Invoice Line Each product becomes an invoice line with tax
Tax types must match Xero exactly; Xero creates contacts automatically

Common Sales Invoice Import Errors

Issues you might encounter when importing Orders Export data to Sales Invoice - and how we solve them

Tax Type Not Found in Xero

Xero requires exact tax type name match

TaxType: 'Standard Rate' (not in Xero)
TaxType: 'Tax on Sales' (US) or '20% (VAT on Income)' (UK)

Map WooCommerce tax rates to exact Xero tax type names

Check your Xero Settings > Tax Rates for exact names

Invalid Date Format

Xero requires DD/MM/YYYY (UK/AU/NZ) or MM/DD/YYYY (US)

2024-01-15 14:30:00
15/01/2024 (UK) or 01/15/2024 (US)

Select your Xero region in options

Tool converts dates automatically based on region

Contact Created Automatically

Xero creates new contacts if name doesn't match exactly

Contact: 'John Doe' vs 'john doe' creates duplicate
Xero creates both as separate contacts

Pre-sync customers or clean up duplicates in Xero after import

Use consistent name formatting (Title Case recommended)

Frequently Asked Questions

No! Unlike QuickBooks, Xero automatically creates contacts when you import invoices. However, be aware this can create duplicates if customer names aren't formatted consistently. Our tool uses Title Case formatting to minimize duplicates.
Go to Settings > General Settings > Tax Rates in Xero. Copy the tax rate names EXACTLY as shown (including parentheses and percentages). For example, UK VAT is '20% (VAT on Income)' not 'VAT 20%'. Our tool includes regional presets for common tax types.
Xero will reject the entire import file. Always select your correct region in our converter: US uses MM/DD/YYYY, while UK/AU/NZ use DD/MM/YYYY. The converter handles the transformation automatically.
Yes, just convert the same WooCommerce export multiple times with different region settings. Each conversion will format dates and tax types for that specific region.
Xero allows up to 500 invoices per import file. For larger batches, either split your WooCommerce export by date range or use our tool to process in chunks.

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
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