Sync inventory from Microsoft Dynamics 365 Business Central to Shopify

The warehouse manager of an eCommerce manufacturer ensures that the inventory details of each product are available in different locations in Microsoft Dynamics 365 Business Central and should be synced to the products listed in Shopify. This is to ensure that inventory is always up-to-date and avoid backorders or products being “sold out” scenarios.

Understand the flow

In the Microsoft Dynamics 365 Business Central inventory to Shopify inventory (add or update) flow, the export gets the inventory balance report and inventory details of the products from each location in Microsoft Dynamics 365 Business Central since the last flow run. The flow looks for the inventory item ID in Microsoft Dynamics 365 Business Central. The flow filters the items that have an item ID map for the store and inventory item ID. The import updates the inventory for all products based on the locations available in Shopify and specifies the count of all inventory updates on the integrator.io Dashboard. This is a scheduled flow. If the flow fails to add or update the inventory, an error message is displayed on the integrator.io Dashboard.

Configure the flow settings

1. Log in to your integrator.io account.
2. Click on the Shopify - Microsoft Dynamics 365 Business Central integration app tile.
3. Go to Settings > General.
4. In the Map Microsoft Dynamics 365 Business Central locations with Shopify locations setting, map Microsoft Dynamics 365 Business Central locations to the corresponding Shopify locations. You can choose to map locations as one-to-one or many-to-one (map a group of Microsoft Dynamics 365 Business Central locations to a single Shopify location). If you have only a single location set up in Shopify to which all of your Microsoft Dynamics 365 Business Central locations are mapped, then select it from the Select a default Shopify location list.
5. In the Select a default Shopify location setting, select a default Shopify location to map all the Microsoft Dynamics 365 Business Central locations. To select the Shopify default location, you must map one or many locations or provide a default Shopify location.
6. Click Save.

Run the flow

Know before you run the flow: 

• The products should already exist in Shopify.
• Ensure that you run the Shopify product details to Microsoft Dynamics 365 Business Central Celigo eTail item map (add or ignore) flow before you run this flow.

To run the flow:

1. Go to Flows > Inventory.
2. Next to the Microsoft Dynamics 365 Business Central inventory to Shopify inventory (add or update) flow, use the toggle button to enable the flow.
3. Click Run.

You can see the flow status in the integrator.io Dashboard.

Understand the Microsoft Dynamics 365 Business Central and Shopify inventory records