Variant Support
Each Shopify variant becomes a separate Xero inventory item.
Shopify Products to Xero Inventory Converter
or drop files here .csv, .xls, .xlsx, .xlsm (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 Inventory Item 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
Sync your Shopify product catalog to Xero. Essential for tracked inventory and invoice line items.
Free preview — then from $5. Save with bundles.
Free preview before you pay
Files never leave your browser
No account needed to start
How to Convert Shopify Products → Xero
1
Export from Shopify
Products → All Products → Export → Export CSV
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 Inventory Item CSV format — ready to import directly, no manual reformatting needed.
Field Mapping
How Shopify Products fields map to Xero Inventory Item
| Shopify Products | Source Value | Xero Inventory Item | Target Value | Note | |
|---|---|---|---|---|---|
Body (HTML) |
<p>This is a great t-shirt.</p> |
→ | Description |
<p>This is a great t-shirt.</p>
|
HTML stripped description |
Title |
Example T-Shirt |
→ | PurchaseDescription |
Example T-Shirt
|
Purchase order description |
Variant Price |
25.00 |
→ | SalesUnitPrice |
25.00
|
Selling price |
Cost per item |
12.00 |
→ | PurchaseUnitPrice |
12.00
|
Cost/purchase price |
Variant Inventory Qty |
25 |
→ | QuantityOnHand |
25
|
Current stock level |
Data Transformation
Each Shopify variant becomes one Xero inventory item
Input
Shopify Product Variant
Product variant with SKU, price, inventory
Key columns:
Handle,
Variant SKU,
Variant Price
1:1 — One input row creates one output row
Output
Xero Inventory Item
1 rows per
input
Inventory item for Xero catalog
Shopify Products → Xero Conversion Questions
How are variants handled?
Each Shopify variant becomes a separate Xero inventory item. A t-shirt with 3 sizes becomes 3 items.
What if products have no SKU?
We fall back to the product Handle (URL slug). Or use 'Skip Products Without SKU' to exclude them.
Can I update existing items?
Xero will update items with matching ItemCodes. New codes create new items.
Why Use the Shopify Products → Xero Converter?
SKU Mapping
Variant SKU becomes Xero ItemCode (truncated to 30 chars).
Inventory Tracking
Optionally enable Xero inventory tracking with asset/COGS accounts.
Price Mapping
Sales price and cost properly mapped to Xero fields.
HTML Stripping
Product descriptions cleaned of HTML for Xero import.
Batch Processing
Large catalogs split into 1000-item batches (Xero limit).
How People Use Shopify Products → Xero
Our Shopify catalog has 3,500 variants and Xero kept rejecting imports because of missing ItemCodes and character limits. The converter maps each variant SKU to a proper Xero inventory item, truncates codes to 30 characters, and ensures uniqueness. Our product sync finally works without manual fixes.
I needed tracked inventory in Xero so my COGS calculations would be accurate. The converter set up each Shopify variant as a separate Xero item with the correct sales and purchase account codes. Enabling inventory tracking through the tool saved me from configuring 480 items by hand.
Clients always ask why their Xero invoices show generic line items instead of proper product names. The answer is they never imported products first. I convert their Shopify products to Xero inventory items so every invoice references a real ItemCode with pricing and descriptions intact.
Why Sync Products to Xero
The Inventory Code Problem
When invoices reference a product code (InventoryItemCode) that doesn't exist in Xero,
the import fails or creates generic line items without proper inventory tracking.
Shopify exports one row per VARIANT (a t-shirt in 3 sizes = 3 rows).
Each variant needs a separate Xero inventory item with unique ItemCode.
What This Tool Does
Transform Shopify products to Xero inventory format:
- Each variant → One Xero item
- SKU or Handle → ItemCode (max 30 chars)
- Variant Price → Sales price
- Cost per item → Purchase price
- Optional inventory tracking setup
Common Inventory Item Import Errors
Issues you might encounter when importing Products Export data to Inventory Item - and how we solve them
ItemCode Exceeds 30 Characters
Xero ItemCode maximum length is 30 characters
We automatically truncate to 30 chars
Review truncated codes for uniqueness conflicts
Duplicate ItemCode
Two items with same ItemCode will conflict
Ensure SKUs are unique across all variants
Review and deduplicate codes before import
Your Shopify Products → Xero Conversion is Secure
Client-Side Conversion
No server round-trips. Your Shopify Products → Xero data is processed entirely in the browser tab.
Auto-Erased on Close
The moment you close the page, all Shopify Products → Xero data is wiped from browser memory. No traces left.
EU Privacy Standard
Meets GDPR requirements by design — no data processing on external servers, ever.
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.
Xero ItemCode max is 30 characters. We truncate and ensure uniqueness automatically.
Enable if you want Xero to track stock levels and calculate COGS. Requires Inventory Asset and COGS accounts to be configured.
Each Shopify variant becomes a separate Xero inventory item. A t-shirt with 3 sizes becomes 3 items.
We fall back to the product Handle (URL slug). Or use 'Skip Products Without SKU' to exclude them.
Xero will update items with matching ItemCodes. New codes create new items.
Yes, when enabled, inventory levels sync in real-time between Shopify and Xero. This keeps stock quantities accurate across both systems and prevents overselling.
Yes, you can customize product mapping. If product names don't match automatically, you can map Shopify products to Xero items manually via the Products tab.
Product names transfer as-is from Shopify to Xero. If names differ between systems, you can map them manually to ensure the same products link correctly.
Yes, SKUs must use standard Latin alphabet characters. Xero cannot process non-Latin characters, so ensure all SKUs are in standard English text format.
Each variant maps to a separate Xero item. Variants are synced with their individual SKUs and stock levels maintained independently for accurate inventory tracking.
Shopify → Xero Data Ecosystem
All available data flows from Shopify to Xero
Shopify
Customers Export
Customer profiles with contact info, addresses, and marketing preferences
→
Xero
Contact
Customer or supplier contact records
First Name + Last Name → Name
First Name → FirstName
Last Name → LastName
Shopify
Orders Export
Customer orders with line items, shipping, taxes, discounts, addresses
→
Xero
Sales Invoice
Sales invoices for accounts receivable (B2B, payment terms)
Name → InvoiceNumber
Name → Reference
Created at → InvoiceDate
Shopify
Payouts/Transactions
Shopify Payments transactions, fees, and bank deposits
→
Xero
Bank Statement
Bank transactions for reconciliation
Transaction Date / Payout Date → Date
Amount / Net → Amount
Type → Payee
Shopify
Products Export
Product catalog with variants, pricing, inventory, and images
→
Xero
Inventory Item
Products and services for inventory tracking
Variant SKU / Handle → ItemCode
Title + Option Values → ItemName
Body (HTML) → Description
Shopify
Refunds (via Orders Export)
Refunded orders filtered from Orders export. Filter by Financial Status = refunded.
→
Xero
Credit Note
Refunds and returns as credits against invoices
Name + '-R' → CreditNoteNumber
Name → Reference
Created at → CreditNoteDate
Also available as
This platform pair is available in 4 other hubs
🥦
Quick question before you go
Help us improve—what stopped you today?
🎉
Thank you!
Enter your email to claim your welcome bonus