Convert WooCommerce to Xero: Free Invoice Converter & Import Tool

🥦

Convert Complete

Xero Invoice Import CSV Format
valid rows

Transform WooCommerce orders into Xero invoices with automatic formatting

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

Download Sample WooCommerce Orders

Example WooCommerce order export with line items

Download Sample

Tool Rating

4.9 / 5 (94 votes)

How It Works

1

Export from WooCommerce

Export orders from WooCommerce Analytics or use an order export plugin

2

Select Your Region

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

3

Configure Options

Set account code, tax type, and invoice prefix based on your Xero setup

4

Upload & Convert

Upload your WooCommerce CSV and download the Xero-ready file

5

Import to Xero

Go to Xero > Business > Invoices > Import and upload the converted file

Why WooCommerce Orders Don't Import Directly to Xero

Format & Regional Requirements

Xero has strict CSV import requirements including exact date formats (DD/MM/YYYY for UK/AU/NZ, MM/DD/YYYY for US), precise tax type names, and specific column headers. WooCommerce exports don't match these requirements without transformation.

What We Convert

- Dates → Regional format (DD/MM/YYYY or MM/DD/YYYY based on your Xero region) - Customer Names → ContactName (auto-creates contacts in Xero if missing) - Order Numbers → InvoiceNumber (with optional prefix for uniqueness) - Line Items → Multi-line invoices (Description, Quantity, UnitAmount) - Tax Rates → Xero TaxType (must match your Xero tax rates exactly) - Account Codes → Map to your Xero chart of accounts

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?

Regional Date Formatting

Automatically formats dates for US, UK, AU, or NZ Xero organizations

Tax Type Mapping

Maps WooCommerce taxes to Xero tax types with regional presets (VAT, GST, Sales Tax)

Auto-Contact Creation

Xero automatically creates contacts from invoice imports - no pre-import needed

Multi-Line Invoices

Groups products by order into proper multi-line Xero invoices

Account Code Mapping

Specify your Xero revenue account code (typically 200 for Sales)

SKU Support

Maps WooCommerce product SKUs to Xero inventory item codes

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

Go to Settings > General Settings > Tax Rates in Xero. The tax rate names must match EXACTLY as shown there (e.g., '20% (VAT on Income)' for UK standard VAT, 'Tax on Sales' for US sales tax). This is the most common import error - case and spacing matter!
Yes! Unlike QuickBooks, Xero automatically creates contacts (customers) during invoice import if they don't exist. However, be aware this can create duplicates if customer names aren't consistent (e.g., 'John Smith' vs 'john smith').
Select your Xero organization region in the tool options. UK, Australia, and New Zealand use DD/MM/YYYY format, while United States uses MM/DD/YYYY. Using the wrong format will cause import errors.
Yes, just select the appropriate region for each organization. The tool converts the same data to match different regional formats.
Orders with multiple products become multi-line invoices in Xero. All products from the same order share the same invoice number, and Xero groups them automatically during import.
Xero allows up to 500 invoices per import file. If you have more, the tool will automatically split them into multiple files (or you can filter your WooCommerce export by date range).
Yes, the account code (typically 200 for Sales) must exist in your Xero chart of accounts before importing. Check Settings > Chart of Accounts to verify.

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