Half my WooCommerce products were missing SKUs, which Xero requires as item codes. The auto-generate SKU feature created item codes from my product IDs so I could import everything without going back to fix my catalog first. The regional tax type mapping for my AU Xero organization was accurate too.
Convert WooCommerce Products to Xero Items
or drop files here .csv, .xlsx, .xlsm, .xls (up to 50 MB)
Free 5-row preview · No sign-up required
Invoice import blocked if Sales Tax enabled in QBO
Convert Complete
Your converted file is ready!
Download now before closing this page
Xero Items Import CSV Format
Showing valid rows only (download includes all rows + errors)
All rows valid
| $ |
|---|
+ more rows
valid rows
invalid rows skipped from preview
credits
| Row | Column | Value | Error |
|---|---|---|---|
Showing first 50 errors. more errors not shown.
more errors hidden. Download the full validation report to see all errors.
Validation Report Download
The download includes your original file with an added "Validation Error" column showing error messages for each row. Valid rows have an empty error column.
• credits
Use credits to download
Click any download button to use your credits
- Full CSV & Excel export
- Google Sheets export
- Instant browser download
for credits
One-time payment
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle
Want to save on credits?
Buy bundles and get up to 27% off. Perfect for recurring monthly conversions.
Liked the preview?
Upload your actual file to get the real conversion
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
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)
How People Use WooCommerce Products → Xero
I convert WooCommerce product catalogs to Xero items for several UK-based clients. The regional tax type selection correctly maps to VAT on Income, and the HTML cleanup strips all the formatting from product descriptions. I always import products before orders so Xero can link line items to existing inventory.
We re-import our WooCommerce products to Xero every quarter to update pricing and stock levels. Since Xero updates existing items when the ItemCode matches, the converter makes this a painless process. The sales account code mapping links everything to the correct revenue account automatically.
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
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
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
Also available as
This platform pair is available in 1 other hub
🥦
Quick question before you go
Help us improve—what stopped you today?
🎉
Thank you!
Enter your email to claim your welcome bonus