LOOKING FOR PARTNERS 🤝

We're currently looking for partners and distributors in different regions. If you're interested, please feel free to contact us.

Shopify Inventory Quantities syncs with Xero Inventory Quantities

Sync Shopify and Xero Inventory

Learn about SyncPenguin's Shopify and Xero inventory level sync


Free 14-day trial with full support, no credit card required

Many merchants sell through Shopify but keep their books and tracked inventory in Xero. Without a connection between the two, every Shopify sale and every restock recorded in Xero has to be copied over by hand. Stock counts drift apart, products get oversold or shown as out of stock when they aren't, and the inventory value in your accounts no longer matches what is actually on the shelf. Reconciling the two systems turns into a recurring spreadsheet chore that eats into time better spent running the business.

How SyncPenguin helps

The SyncPenguin Shopify and Xero inventory connection keeps stock levels in your Shopify location and your Xero tracked inventory in sync automatically. Products are matched by SKU (the Xero Item Code). SyncPenguin sets the starting quantities and then syncs every sale, return, restock, and manual adjustment as an adjustment rather than an overwrite. Shopify orders reduce stock in Xero, and goods you receive and record in Xero flow back to your Shopify store. You can sync one-way or two-way, limit syncing to selected SKUs or tagged products, and record every Xero change as a proper accounting transaction, so your storefront and your books always agree.

Best suited for: Shopify merchants who manage their accounting and tracked inventory in Xero. Bookkeepers and accountants managing e-commerce clients. Multichannel retailers using Xero as their central stock record. Small product businesses and makers selling online and in person.

Real-world use cases

  • Automatically reduce Xero stock whenever an order is placed in your Shopify store, so inventory values in your accounts stay accurate without manual entries.
  • Record incoming supplier deliveries in Xero and have the new quantities pushed to Shopify automatically, so restocked products become available to buy online right away.
  • Use Xero as the central inventory record for a business that sells online through Shopify and in person with Square POS, keeping all three in sync.
  • Sync only a selected product line, such as items tagged 'retail' in Shopify, with Xero while managing wholesale or made-to-order items separately.
  • Sync your main Shopify warehouse location with Xero, so fulfilment stock and accounting stock always match.
  • Share one pool of stock between Shopify, WooCommerce, and Xero, so a sale on either website updates stock everywhere, including your books.
  • Keep Shopify, Xero, and your Zettle card reader in sync when selling at markets, pop-ups, and events, so stock and accounts stay current after every event.
  • Run a Shopify store alongside a Squarespace site and keep both storefronts and your Xero inventory aligned on the same stock levels.
  • Expand to BigCommerce while keeping stock levels in sync with your existing Shopify store and Xero accounting during the transition.

Key features

Two-Way Stock Sync

Sync quantities from Shopify to Xero, from Xero to Shopify, or both ways, so sales and restocks are reflected wherever they happen.

Automatic SKU Matching

Shopify variants are matched to Xero items by SKU and Item Code automatically, with no manual product linking required.

Adjustment-Based Syncing

Only stock changes are synced, so simultaneous sales and restocks in both systems add up correctly instead of overwriting each other.

Accounting-Friendly Records

Stock changes are recorded in Xero as proper transactions, with an optional inventory adjustment account to keep your books balanced.

Selective Syncing

Sync only specific SKUs or Shopify products with chosen tags, and leave the rest of your catalog and Xero items untouched.

Affordable & Scalable

With SyncPenguin you only pay for changes to your inventory quantities, regardless of how many products you have now or will have in the future.

Things to note

  • The connection syncs stock quantities only. Products need to exist in both Shopify and Xero with matching SKUs, because SyncPenguin does not create, rename, or delete products.
  • Only Xero items with 'Track inventory' turned on are synced, and each item should have a purchase price set so stock adjustments can be valued correctly.
  • SKUs should be unique in both systems. Shopify variants without a SKU are skipped, and duplicate SKUs are flagged so you can fix them instead of being updated incorrectly.
  • Xero records tracked inventory changes through transactions, so stock increases appear as bills and decreases as supplier credit notes under an 'Inventory Adjustments (SyncPenguin)' contact. Selecting an inventory adjustment account keeps your books balanced.
  • Shopify changes trigger syncing through webhooks, while Xero changes are picked up during regular sync checks. Very large catalogs may take a little longer to process because SyncPenguin respects Xero's API limits.
  • Each connection syncs one Shopify location and one Xero organization. To include more locations or organizations, add a separate connection for each one.
  • Quantities are synced as whole units, and Shopify inventory tracking is turned on automatically for synced variants.

How to configure the sync?


This guide explains in detail how to create, configure, and start the sync.

If you'd like to start syncing right away, feel free to create an account and set up the sync on your own. Come back to this guide if anything is unclear. You can also contact us with any questions, requests, or feedback.

INVENTORY LEVELS ONLY

Please note that this sync connection doesn't include any other product data like images, descriptions, or prices. We simply match existing products and variants by SKUs between the two synced stores and keep the quantity in sync. This means that products that you want synced must have matching SKUs, and the SKUs must be unique within a store.

Step 1. Create a SyncPenguin account

The first step is to create a SyncPenguin account. We offer a free 14-day trial (no credit card required), so you can make sure everything works well before you commit. Follow the link below to create an account.

14-day free trial • no credit card required • quick setup

Step 2. Create the sync

Next, create a sync in the Synchronizations section of the dashboard by clicking the + New sync button. You'll see a wizard page where you need to do the following:

  • Choose Shopify Inventory Quantities for the first app.
  • Then choose Xero Inventory Quantities for the second app.
  • Then select the sync direction.
  • Then click the Create button.

Step 3. Provide access to Shopify and Xero

Now that your sync is created, the next important step is to grant SyncPenguin access to your store inventory data. You'll see an Account section for each app involved in the sync. Below we explain how to connect and configure each account.

How to connect Shopify?

This is a preview of the connection form in your SyncPenguin dashboard, shown for illustration only. Don’t enter any credentials here.
The Shopify Inventory Quantities account connection section will look like this:

Account for Shopify Inventory Quantities (Example)
Shopify Inventory Quantities

How to connect Xero?

This is a preview of the connection form in your SyncPenguin dashboard, shown for illustration only. Don’t enter any credentials here.
The Xero Inventory Quantities account connection section will look like this:

Account for Xero Inventory Quantities (Example)
Xero Inventory Quantities

Please make sure both apps are properly connected before starting the sync.

DATA SECURITY

If you're concerned about the security of your data, please check out our Security Practices page.

Step 4. Sync settings

In the Sync settings section, you can adjust some of the default settings of your sync:

  • The name of your sync.
  • Sync direction (two-way or one-way).
  • Sync interval (by default, the sync runs every 10 minutes).

Please note that this connection uses webhooks, so syncing will be near real-time in most cases. The sync interval is used as a fallback in case a webhook is not fired.

Sync settings

Step 5. Start the sync

The last step is to start the sync. To do that, click the Start syncing button.

You'll then be offered the following options:

  1. Copy quantities Shopify → Xero: take all Shopify SKUs and assign the same levels to Xero.
  2. Copy quantities Xero → Shopify: similar to the previous option but in the opposite direction.

We recommend running the initial sync in either direction to ensure the stock levels are initially the same for all matching SKUs.

Start sync
We'll be checking every 10 minutes for changes in your data.
What should we do initially with already existing inventory?

Once you've made your choice, click Start syncing. If you choose an initial copy, it'll be queued immediately. Once it's done, we'll check for inventory or product changes at the sync interval you've set, as well as react to webhooks, and sync them accordingly. Each sync run is shown in the Sync history at the bottom of the sync page.

Learn more

Frequently Asked Questions

Can I sync Shopify inventory with Xero automatically?

How does SyncPenguin match Shopify products with Xero items?

How do synced stock changes appear in my Xero books?

Will sales in Shopify overwrite stock changes I make in Xero?

Can I sync only some of my Shopify products with Xero?

My Shopify store has several locations. Which one is synced with Xero?

Can I add Square, WooCommerce, or other sales channels to the same setup?