When using the Inventory Synchronization via the Shopify Connector (with the Stock Calculation set to "Projected Available Balance at Today"), a Business Central Item's "available" inventory is integrated with Shopify product's "On Hand" inventory. When Sales Orders are manually created in BC, in addition to orders created with the Shopify integration, the "Available" inventory shown on Shopify double counts Shopify orders. This idea is to allow the Inventory Sync on the Shopify Connector to function when using Sales Orders created manually or via the Shopify integration. This could be done by either integrating directly with the Shopify Product's "Available" value or by not including Shopify Orders in the "Inventory Availability" value that is sent from BC to Shopify's "On Hand" field.

For example, on Business Central:

Quantity On Hand = 100 EA

Outstanding Qty on Sales Lines = 30 EA. Let's assume 20 EA came from sales orders integrated via Shopify, and 10 EA came from sales orders manually input into BC.

Item Availability = 70 EA

We would expect 70 EA to be available inventory shown in Shopify as well. When the inventory sync with Shopify is run...

On Shopify:

On Hand = 70 EA. This is the "Item Availability" number above that BC is sending to Shopify.

Committed = 20 EA

Available = 50 EA

There is a mismatch in inventory availability, due to the 20 EA from Shopify orders being deducted twice from Shopify's inventory availability.