MyWorks supports syncing inventory levels from QuickBooks Online to Shopify, anytime an inventory level is changed in QuickBooks. This is most helpful when using QuickBooks Online as the “master” for your inventory. Since orders placed on Shopify will correctly reduce inventory in QuickBooks as we sync the order into QuickBooks, our ability to sync inventory levels applies to any inventory activities aside from Shopify orders - like when a product is manually edited to change inventory; or new inventory is received.

• Using QuickBooks Online as the “master” for your inventory levels? Read on to review how to enable inventory syncing from QuickBooks Online to Shopify.
   
• Using Shopify as the “master” for your inventory levels? Check out our doc on syncing inventory from Shopify to QuickBooks Online, instead.  
   

There's a few factors to keep in mind before enabling inventory sync - in MyWorks Sync > Settings > Automatic Sync. We'll sync inventory for any products that meet the below conditions:

• The product needs to be an inventory product in both Shopify and QuickBooks Online.
• The products must be mapped together in Map > Products/Variations in our sync.

Once the above conditions are met and inventory sync is enabled in MyWorks Sync > Settings > Automatic Sync, we'll start syncing inventory levels: from QuickBooks to update Shopify to match. If you're not managing inventory in a Shopify or QuickBooks product, we won't sync inventory for that product. 

Handling multiple Shopify Locations

If you have multiple locations in your Shopify store, MyWorks includes additional options to easily manage how inventory should sync with those Shopify Locations, as shown below.

When syncing inventory from QuickBooks to Shopify, the below settings help you control exactly which inventory level should update in Shopify to match QuickBooks.

Shopify Location to sync inventory with
You can select the Shopify location you'd like MyWorks to update inventory for as we sync inventory from QuickBooks.

Exclude Shopify Locations when syncing inventory
If no location is selected here, MyWorks will update the above Shopify Location to result in the total inventory count for that Shopify product matching the QuickBooks inventory. If you wish to exclude some Shopify locations from being counted in this calculation, you can select them here. 

Shopify Inventory Field to use when syncing inventory
Since Shopify has two separate inventory values for a product: Available and On Hand; you can choose which value we should update as we sync inventory levels from QuickBooks. This is normally set to Available, by default - and should only be changed to On Hand if you're only syncing orders to QuickBooks when they're fulfilled in Shopify.  

Example of inventory updating in Shopify

When you have more than one location in Shopify, MyWorks can still sync inventory from QuickBooks to Shopify. But, since QuickBooks Online doesn't support separate inventory locations, we'll sync inventory in a way that ensures that the total of the Shopify product matches the inventory level in QuickBooks - allowing you to treat QuickBooks as tracking the “total” amount in inventory.

The way MyWorks handles this is by changing inventory for one Shopify location to result in the total inventory in the Shopify product (across all warehouses) matching the QuickBooks inventory level, as mentioned above.

Once set, inventory would sync like the below example:

Starting: QuickBooks has 12 in stock, and the Shopify product also has 12 total:
Location 1 - 3 in stock
Location 2 - 4 in stock
Location 3 - 5 in stock
Total: 12

Then: QuickBooks changes to 14. We'd update the Shopify location set in our settings above - which for example, is Location 2. This would result in this Shopify product having:
Location 1 - 3 in stock
Location 2 - 6 in stock
Location 3 - 5 in stock
Total: 14

As discussed above, you can exclude some Shopify Locations from being included in this calculation in our settings.