Convert WooCommerce Products to Xero Items

🥦

Convert Complete

Xero Items Import CSV Format
valid rows

Transform WooCommerce product catalog into Xero inventory items instantly

Free preview — then from $0.15. Save with bundles.
Free preview before you pay
Files never leave your browser
No account needed to start

Download Sample Products

Example WooCommerce product export

Download Sample

How to Convert WooCommerce Products → Xero

1

Export from Woocommerce

Products → All Products → Export products

2

Upload and Configure

Upload Products Export CSV and choose Inventory Item format

3

Preview and Download

Review converted data, download Xero-ready file

4

Import to Xero

Accounting → Inventory → Import → Upload CSV

Output is in Xero Items Import CSV format — ready to import directly, no manual reformatting needed.

WooCommerce Products → Xero Conversion Questions

What if my products don't have SKUs?

The tool auto-generates item codes from product IDs (e.g., PROD-101). However, for best practice, add SKUs to all your WooCommerce products before exporting. This makes inventory tracking across systems more reliable.

Can I update existing Xero items?

Xero's import will update existing items if the ItemCode (SKU) matches. New items are created for unmatched codes. This makes it safe to re-import for price or stock updates.

Should I import products before or after orders?

Import products BEFORE orders. This way, when you import invoices, Xero can link line items to existing inventory items automatically. This provides better reporting and inventory tracking.

Common Inventory Item Import Errors

Issues you might encounter when importing Products Export data to Inventory Item - and how we solve them

Missing Item Code (SKU)

Xero requires ItemCode - SKU cannot be empty

SKU: (empty)
SKU: PROD-001

Ensure all products have SKUs in WooCommerce

Tool auto-generates codes from product ID if SKU missing

Why WooCommerce Products Need Conversion for Xero

SKU and Tax Requirements

Xero requires item codes (SKUs) and exact tax type names. WooCommerce exports product data in a different format that needs transformation for successful Xero import.

What We Convert

- SKU → ItemCode (auto-generated if missing) - Product Name → ItemName - Description → Description (HTML stripped) - Price → SalesPrice - Stock → QuantityOnHand - Tax Status → TaxType (regional: VAT, GST, or Sales Tax)

Field Mapping

How Woocommerce Products fields map to Xero Inventory Item

Woocommerce Products Source Value Xero Inventory Item Target Value Note
SKU PROD-001 → ItemCode PROD-001 Unique item identifier (required)
Name Blue Widget → ItemName Blue Widget Product name/title
Description <p>Premium widget with lifetime warranty</p> → Description <p>Premium widget with lifetime warranty</p> Product description for sales
Regular price 29.99 → SalesPrice Default selling price
Stock 100 → QuantityOnHand 100 Current inventory quantity
Tax status taxable → TaxType Sales tax applicability

Why Use the WooCommerce Products → Xero Converter?

Auto-Generate SKUs

Creates item codes from product IDs if SKUs are missing

Regional Tax Types

Maps to correct tax types for US, UK, AU, or NZ Xero organizations

HTML Cleanup

Strips HTML tags from product descriptions automatically

Price Optimization

Uses sale price if active, otherwise regular price

Inventory Sync

Imports stock quantities for inventory tracking in Xero

Account Code Mapping

Links products to your Xero sales revenue account

Data Transformation

Each WooCommerce product becomes one Xero inventory item

Input WooCommerce Product

One row per product from WooCommerce product export

Key columns: SKU, Name, Regular price, Stock, Tax status
1:1 — One input row creates one output row
Output Xero Item 1 rows per input

One inventory item record

Item Record Product details with inventory tracking and tax type
ItemCode (SKU) must be unique and non-empty; region-specific tax types applied

Your WooCommerce Products → Xero Conversion is Secure

Local Processing Engine

Your WooCommerce Products → Xero files stay on your device. Processing happens client-side, nothing leaves your machine.

Zero Server Storage

Your WooCommerce Products → Xero files are never cached, logged, or stored anywhere. Every session is ephemeral.

Privacy-First Architecture

Designed for data sovereignty. No third-party trackers or analytics touch your WooCommerce Products → Xero files.

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Frequently Asked Questions

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.
The tool auto-generates item codes from product IDs (e.g., PROD-101). However, for best practice, add SKUs to all your WooCommerce products before exporting. This makes inventory tracking across systems more reliable.
Go to Settings > General Settings > Tax Rates in Xero. For US, use 'Tax on Sales'. For UK, use '20% (VAT on Income)'. For AU/NZ, use 'GST on Income'. The tool includes these regional defaults.
Xero's import will update existing items if the ItemCode (SKU) matches. New items are created for unmatched codes. This makes it safe to re-import for price or stock updates.
Import products BEFORE orders. This way, when you import invoices, Xero can link line items to existing inventory items automatically. This provides better reporting and inventory tracking.
Yes, SKU codes must match exactly between WooCommerce and Xero for proper mapping. Avoid spaces and special characters in SKUs to prevent sync errors.
Yes, product variations can be mapped to Xero. Use automap if variations have matching names or SKUs, or manually map each variation individually.
WooCommerce to Xero sync typically only reduces Xero inventory when items sell. Inventory won't automatically sync if quantities change in Xero.
Tax rates must match account types in Xero. Sales tax applies to sales accounts, not expense accounts, or Xero will reject the sync.
Prices export as tax-exclusive by default. If your WooCommerce prices are tax-inclusive, specify this to avoid double-charging tax in Xero.
Xero aborts entire batches on errors without messages. Check SKU matching, tax rates, and account codes before retrying the sync.

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

Also available as

This platform pair is available in 1 other hub

Learn More:

vs MyWorks Software vs Xeroom vs Synder vs Webgility vs Amaka vs Zetpy vs SyncPenguin vs Xelation vs CodeKiwi vs Commercient Export Products Guide