Sync Microsoft Dynamics 365 Business Central inventory to Amazon inventory (add or update)

Contents

• Understand the flow
• Before you run the flow
• Configure settings
• Run the flow
• Understand the inventory records in Amazon and Microsoft Dynamics 365 Business Central

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 on Amazon. 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 Amazon inventory (add or update) flow, the export gets the inventory details of the products from each location in Microsoft Dynamics 365 Business Central since the last flow run. The import updates the inventory for all Amazon products in a store and specifies the count of all inventory updates on the integrator.io Dashboard. 

This is a scheduled flow that syncs inventory only for the selected locations in the Select Microsoft Dynamics 365 Business Central locations to pick inventory from the integration app setting. If the flow fails to add or update the inventory, an error message is displayed on the integrator.io Dashboard.

Before you run the flow

• The eTail account ID must exist in Microsoft Dynamics 365 Business Central item record.
• The products should already exist in Amazon.
• : The items in Amazon must be in sync with Microsoft Dynamics 365 Business Central, otherwise the flow will error out.

Configure settings

1. From the integration app, go to Settings > Inventory.
2. In the Select Microsoft Dynamics 365 Business Central locations to pick inventory from setting, select one or many Microsoft Dynamics 365 Business Central locations to pick inventory (for all the items linked to Amazon) when you run the Microsoft Dynamics 365 Business Central inventory to Amazon inventory (add or update) flow. If you select multiple locations, the inventory from all selected locations is synced to Amazon.
3. Click Save.

Run the flow

1. Go Flows > Inventory.
2. Next to the Microsoft Dynamics 365 Business Central inventory to Amazon inventory (add or update) flow, use the toggle button to enable the flow.
3. On the Confirm enable window, click Enable.
4. If you run the flow for the first time, a delta flow pop-up window is displayed. This helps you to sync the historical inventory details. 
   • Automatic: Choose this option to process and sync data from the last flow run time OR
   • Custom: Choose this option to select a custom start date and time from when you wish to process and sync data.
     
5. Click Run.

You can see the flow status in the integrator.io Dashboard. On a successful sync, for every record, the success count of the flow including the import and export is shown as 1.

Understand the inventory records in Amazon and Microsoft Dynamics 365 Business Central 

Microsoft Dynamics 365 Business Central inventory item

Microsoft Dynamics 365 Business Central matrix item

The Microsoft Dynamics 365 Business Central inventory to Amazon inventory (add or update) flow syncs the inventory from Microsoft Dynamics 365 Business Central each location to Amazon inventory. In the images, you can find the inventory for all items is synced to Amazon's individual item inventory. 

The inventory details such as item name and available quantity are synced.

Amazon Seller Central inventory