Skip to main content

Configure and run flows in the Amazon MWS - Microsoft Dynamics 365 Business Central quickstart integration template

Tom Santiago
  • Updated

Contents

You can install the Amazon MWS – Microsoft Dynamics 365 Business Central integration template from the integrator.io Marketplace.

Amazon MWS orders to Microsoft Dynamics 365 Business Central sales orders

When an order is created in Amazon MWS the integration flow exports orders from Amazon MWS and imports them into Microsoft Dynamics 365 Business Central as sales orders.

Before you begin

  1. Verify that Item Id in Amazon MWS and Item Number in Microsoft Dynamics 365 Business Central are the same.
  2. Verify that the Payment Method name in Amazon MWS and Payment Method code in Microsoft Dynamics 365 Business Central are the same.
  3. Verify that Shipment Service Level Category name in Amazon MWS and Shipment Method displayName in Microsoft Dynamics 365 Business Central are the same.
  4. Create a Non-Inventory item in Microsoft Dynamics 365 Business Central with Item Number 'AMZGIFTWRAP'.

Setup instructions

  1. Verify that the concurrency level for your Microsoft Dynamics 365 Business Central connection is set to 1.
concurrency.png
  1. Open the Get Microsoft Dynamics 365 Business Central companies by displayName export flow step and click Launch under Configure search parameters to create a filter to retrieve company details.
SearchParam.png
  1. Configure dynamic mapping for shipmentMethodId and paymentMethodId in mapping on the Import Microsoft Dynamics 365 Business Central customers flow step.
    • ShipmentMethod
    shipMeth.png
    • PaymentMethod
    paymeth.png
  1. Configure dynamic map for itemId in mapping on the Import Microsoft Dynamics 365 Business Central sales order lines import step.
SOLines.png
  1. Configure mapping for Type on the Import Microsoft Dynamics 365 Business Central customers import step.
type.png
  1. Configure mapping for lineType on the on the Import Microsoft Dynamics 365 Business Central sales order lines import step.
lineType.png

Flow details

  • Export source: Amazon MWS
    • Export: Get Amazon MWS orders - retrieves all orders since the last time the flow ran and transforms data from XML to JSON.
    • Lookup: Get Amazon MWS orderitems - retrieves all order items by itemID.
  • Import destination: Microsoft Dynamics 365 Business Central
    • Lookup: Get Microsoft Dynamics 365 Business Central companies by displayName - retrieves all companies by displayName
    • Import: Import Microsoft Dynamics 365 Business Central customers - adds or updates Amazon MWS customers as Microsoft Dynamics 365 Business Central customers.
    • Import: Import Microsoft Dynamics 365 Business Central sales orders - adds new or ignores existing Amazon MWS orders as Microsoft Dynamics 365 Business Central sales orders.
    • Import: Import Microsoft Dynamics 365 Business Central sales order lines - adds or updates Amazon MWS sales items as Microsoft Dynamics 365 Business Central sales order lines.
Picture4.pngResults mappings: Get Amazon MWS orderitems
Picture5.pngResults mapping: Get Microsoft Dynamics 365 Business Central companies
Picture6.pngImport mappings: Import Microsoft Dynamics 365 Business Central customers
Picture7.pngResponse mappings: Import Microsoft Dynamics 365 Business Central customers
Picture8.pngImport mappings: Import Microsoft Dynamics 365 Business Central sales orders
Picture9.pngResponse mappings: Import Microsoft Dynamics 365 Business Central sales orders
Picture10.pngImport filter: Import Microsoft Dynamics 365 Business Central sales order lines
Picture11.pngImport mappings: Import Microsoft Dynamics 365 Business Central sales order lines

Microsoft Dynamics 365 Business Central fulfillments (SO with status fulfilled) to Amazon MWS fulfillments

When a sales order is created in Microsoft Dynamics 365 Business Central the integration flow exports the ShipmentmethodId from Microsoft Dynamics 365 Business Central sales order API and imports it into Amazon MWS as a fulfilment.

Setup instructions

  1. Open the Get Microsoft Dynamics 365 Business Central companies by displayName export flow step and click Launch under Configure search parameters to create a filter to retrieve company details.
SearchParam.pngSearch parameters: Get Microsoft Dynamics 365 Business Central companies by displayName
  1. Configure the TimeZone for Fulfillment Date.
  2. Configure the mapping for tracking number on the Amazon MWS fulfillment import import step.
soFulf.png

Before you begin

  1. Verify that the Amazon order id is stored as externalDocumentNumber in Microsoft Dynamics 365 Business Central sales orders.
  2. Verify the OrderItemId in Amazon and the number of Items in Microsoft Dynamics 365 Business Central are the same.
  3. Verify the CarrierName in Amazon and the ShipMethod in Microsoft Dynamics 365 Business central are the same.

Flow details

  • Export source: Microsoft Dynamics 365 Business Central
    • Export: Get Microsoft Dynamics 365 Business Central companies by displayName - retrieves.Microsoft Dynamics 365 Business Central companies since the last time the flow ran.
    • Lookup: Get Microsoft Dynamics 365 Business Central sales orders - retrieves all sales orders since the last time the flow ran.
    • Lookup: Get Microsoft Dynamics 365 Business Central sales order lines by sales order id - retrieves all sales order lines for all sales orders since the last time the flow ran.
    • Lookup: Get Microsoft Dynamics 365 Business Central shipment method - retrieves all shipment methods since the last time the flow ran.
  • Import destination: Amazon MWS
    • Import: Import Amazon MWS fulfillments - adds sales orders, sales order lines, and shipment methods from Microsoft Dynamics 365 Business Central as Amazon MWS fulfillments.
Picture1.pngLookup filter: Get Microsoft Dynamics 365 Business Central sales orders
Picture2.pngResults mappings: Get Microsoft Dynamics 365 Business Central sales orders
Picture3.pngResults mappings: Get Microsoft Dynamics 365 Business Central sales order lines by sales order id
Picture4.pngResults mappings: Get Microsoft Dynamics 365 Business Central shipment method
Picture5.pngImport filter: Import Amazon MWS Fulfillments
image__8_.pngImport mapping: Import Amazon MWS Fulfillments

Microsoft Dynamics 365 Business Central inventories to Amazon MWS inventories

This flow exports newly created item quantities in Microsoft Dynamics 365 Business Central them as Amazon MWS Inventories.

Before you begin

Verify the products SKU in Amazon and displayName in Microsoft Dynamics 365 Business Central are the same.

Setup instructions

  1. Open the Get Microsoft Dynamics 365 Business Central companies by displayName export flow step and click Launch under Configure search parameters to create a filter to retrieve company details.
SearchParam.png Search parameters: Get Microsoft Dynamics 365 Business Central companies by displayName
  1. Configure the mapping for FulfillmentCenterID and SwitchFulfillmentTo in the Import Amazon MWS inventories import according to your business needs.

Flow details

  • Export source: Microsoft Dynamics 365 Business Central
    • Export: Get Microsoft Dynamics 365 Business Central companies by displayName - retrieves.Microsoft Dynamics 365 Business Central companies since the last time the flow ran.
    • Lookup: Get Microsoft Dynamics 365 Business Central items - retrieves all items since the last time the flow ran.
  • Import destination: Amazon MWS
    • Import: Import Amazon MWS inventories - adds all items from Microsoft Dynamics 365 Business Central as Amazon MWS inventories.
Picture6.pngResponse mappings: Get Microsoft Dynamics 365 Business Central items
importMappingInv.pngImport mapping: Import Amazon MWS inventories

Microsoft Dynamics 365 Business Central item prices to Amazon MWS product prices

This flow exports newly created item prices in Microsoft Dynamics 365 Business Central and imports them into Amazon MWS as product prices.

Before you begin

Verify the products SKU in Amazon and displayName in Microsoft Dynamics 365 Business Central are the same.

Setup instructions

  1. Open the Get Microsoft Dynamics 365 Business Central companies by displayName export flow step and click Launch under Configure search parameters to create a filter to retrieve company details.
SearchParam.png
  1. Configure the currency mapping in Import Amazon product prices import according to your busniess needs.

Flow details

  • Export source: Microsoft Dynamics 365 Business Central
    • Export: Get Microsoft Dynamics 365 Business Central companies by displayName - retrieves.Microsoft Dynamics 365 Business Central companies since the last time the flow ran.
    • Lookup: Get Microsoft Dynamics 365 Business Central items - retrieves all items since the last time the flow ran.
  • Import destination: Amazon MWS
    • Import: Import Amazon MWS product prices - adds all items from Microsoft Dynamics 365 Business Central as Amazon MWS product prices.
Picture7.pngResponse mappings: Get Microsoft Dynamics 365 Business Central items
mapping.png Lookup: Get Microsoft Dynamics 365 Business Central items
Picture8.pngImport filter: Import Amazon MWS product prices
priceImpMap.pngImport mapping: Import Amazon MWS product prices

Related articles

Comments

0 comments

Please sign in to leave a comment.