Shopify Orders to Xero Invoices & Payments (Zapier)

Automatically sync Shopify sales to Xero with automated reconciliation and multi-step data formatting.

Tools: Shopify → Xero

Platform: Zapier

Short Answer

Every new Shopify order is converted into a detailed Xero Sales Invoice, creating/updating customer contacts and applying payment records automatically. This ensures your Profit & Loss statement is accurate in real-time without manual intervention.

The Problem

Manual entry of sales data from Shopify to Xero leads to human error, delayed financial reporting, and mismatched tax records. This causes significant reconciliation headaches during month-end closing, especially as order volume scales.

The Outcome

Every new Shopify order is converted into a detailed Xero Sales Invoice, creating/updating customer contacts and applying payment records automatically. This ensures your Profit & Loss statement is accurate in real-time without manual intervention.

Step-by-Step Guide

1. **Create the Zap**: Log in to Zapier and click 'Create Zap'. 2. **Configure Shopify Trigger**: Select 'Shopify' as the Trigger app and 'New Order' as the Event. Choose 'paid' as the Order Status (to ensure you only sync completed transactions). 3. **Connect & Test**: Authenticate your Shopify store using the .myshopify.com URL. Pull a recent order as test data. 4. **Format Customer Data**: Add a 'Formatter by Zapier' step. Use 'Text' -> 'Split Text' to separate the Shopify Full Name into First and Last names if needed for your Xero contact structure. 5. **Sync Contact to Xero**: Add a Xero step: 'Find or Create Contact'. Map the Shopify email and use the 'Create Xero Contact if it doesn't exist yet' checkbox. Map Name and Address fields. 6. **Create Sales Invoice**: Add a Xero step: 'Create Sales Invoice'. Set Status to 'Authorised'. Map the Shopify Order Number to 'Invoice Number' and the Line Items to the Xero 'Line Items' fields. 7. **Map Product SKUs**: Ensure Shopify `Line Item SKU` maps to Xero `Item Code`. This is critical for inventory ledger accuracy. 8. **Add a Filter Step**: Before applying payment, add a 'Filter by Zapier' step. Set it to only continue if `Financial Status` (from Shopify) exactly matches `paid`. 9. **Create Payment in Xero**: Add a final Xero step: 'Create Payment'. Map the 'Invoice ID' from Step 6, set the 'Amount' from the Total, and select your Shopify Clearing Bank Account in Xero. 10. **Error Handling**: Use 'Zapier Manager' or the 'Error Handling' option (on Pro plans) to notify you via Slack if a SKU is missing or a tax rate mismatch occurs.