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 Your File
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.
How People Use This
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.
Managing inventory across WooCommerce and Xero used to be a manual nightmare. Now I export my WooCommerce product catalog, run the conversion with the NZ GST tax type selected, and import directly into Xero. Stock quantities come through accurately, and the price optimization picks the active sale price when one exists.
Common 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.
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)
Your Conversion is Secure
Browser-Only Processing
All conversion runs in your browser. Files are never uploaded to any server.
No Data Retention
Nothing is stored after conversion. Close the tab and your data is gone.
GDPR Compliant
Full EU data protection compliance. Your privacy rights are fully protected.
// PRICING //
Choose the plan that fits your needs
Pay as you go
Just start processing on any tool page
$1/credit
Tools processing starts from 5 credits. Then 1 credit = 1k rows. No sign-up needed.
OR
Credit Bundles
$
/Credit
One-time purchase
- No monthly commitment
- Credits valid for one year
- Access to all tools
- Full file downloads
Monthly Bundles Pro
$
/Credit
Best for professionals and content creators
Annual Discount
Per month, billed annually:
Save 20% more
- Credits refresh monthly
- Priority processing
Purchase Credits
- Full CSV & Excel export
- Google Sheets export
- Instant browser download
for credits
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle
Do unused credits expire?
One-time credit bundles are valid for one year. Subscription credits refresh monthly. You can use credits across any tool, anytime.
Is my data secure?
Files process entirely in your browser. We're GDPR compliant with TLS encryption.
Can I get a refund?
Yes! Full refund within 14 days if no credits used. Partial refund for unused credits anytime. Contact sup@spreadsheetbroccoli.com.
Powered by
Paddle
Terms of service applies. VAT included where applicable.
More credits - more savings
Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.
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 This 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
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
Frequently Asked Questions
Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.
No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.
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