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.
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 Your File
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.
How People Use This
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.
We have a t-shirt brand with products in multiple sizes and colors, so each product generates dozens of variants. The converter turned every Shopify variant into a separate Xero inventory item with the SKU as ItemCode. Our stock quantities finally match between both platforms.
Setting up Xero inventory for Shopify stores used to mean hours of manual data entry per client. Now I export the Shopify products CSV, run it through the converter with the right account codes, and batch import into Xero. The HTML stripping on product descriptions is a nice bonus.
Common 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 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
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 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 |
Why Use This Converter?
Variant Support
Each Shopify variant becomes a separate Xero inventory item.
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).
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
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
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.
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