Syncing multiple WooCommerce Stores to a single Xero Company

How to connect multiple WooCommerce stores to one Xero Company.

Written by the MyWorks Team

Updated at December 18th, 2023

Our WooCommerce Sync for Xero supports syncing multiple WooCommerce stores to one Xero company. As a reminder, you'll need one active plan for each WooCommerce site you'd like to sync with Xero.

There are a couple of tips that come up when configuring our sync for this type of scenario.

Connecting to Xero

In your MyWorks account, simply ensure you have a plan for each WooCommerce store you wish to connect to Xero. You can add additional plans to your account by clicking Add Plan in the My Plans menu.

Then, inside each plan, ensure your WooCommerce store URL is correct, and then click Connect to Xero to choose your Xero company within each plan.  

Order number conflicts

Now that orders from multiple sites are being synced into Xero, there is a greater possibility for conflicting order numbers - for example: order number #545 existing on both systems, and attempting to sync to Xero from both. In this case, the sync would error out in the second install that attempts to sync this order over to Xero, as it already exists in Xero under a different client - as a different order.

To mitigate this possibility of conflict, we have several best practices to choose from and adhere to:

  1. Using our WooCommerce Sequential Order Numbers Pro compatibility addon. By using this plugin combination in each WooCommerce store, you can add a store-specific prefix to each order number, which our sync will sync over to Xero accurately. 
     
  2. Use the “Next Xero #” setting when syncing orders to Xero. By default, we’ll sync orders from WooCommerce into Xero using the WooCommerce order ID as the Invoice number in Xero. However, if it’s necessary to sync orders into Xero without relying on any number from WooCommerce, we have an advanced setting that supports syncing orders into Xero using the next Xero invoice/sales receipt number – not relying on any WooCommerce order number. Although this results in the WooCommerce order number not matching your Xero order number, this will ensure there are no order number conflicts in Xero going forward.