Shopify Products to Xero Inventory Converter

🥦

Convert Complete

Xero Inventory Item CSV Format
converted

Sync your Shopify product catalog to Xero. Essential for tracked inventory and invoice line items.

No API required
Browser-based processing
Run on Google Cloud Platform

Download Sample Products Export

Sample CSV to test the converter

Download Sample

Tool Rating

4.5 / 5 (198 votes)

How It Works

1

Export

Export from Shopify Admin → Products → Export

2

Upload

Upload products CSV and configure account codes

3

Preview

Review converted inventory items

4

Import

Import to Xero via Products and Services → Import

Your Data is Safe

Bank-Level Security

256-bit SSL encryption. Same standards as major financial institutions.

No Data Storage

Files are processed directly in browser. No calls to our servers.

GDPR Compliant

Full EU data protection compliance. Your privacy rights protected.

ISO/IEC 27001 Certified GDPR Compliant Swiss Privacy CCPA Compliant

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

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

Why Use This Tool?

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).

Frequently Asked Questions

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.

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
Customer sync, supplier management
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
B2B sales, invoiced orders, payment terms
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
Payout reconciliation, fee tracking
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
Product catalog sync, inventory management Current tool
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
Refund processing, returns handling