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

Tom Santiago
  • Updated

Contents

Additional record mapping is required to integrate the template’s exports and imports with your Amazon Seller Central and Microsoft Dynamics 365 Business Central apps.

Note that all of your flows are disabled when first installed. After configuring the flows, you may enable them in your Flows dashboard or in Flow Builder with the Off/On toggle button. then run or schedule each flow.

Amazon Seller Central orders to Microsoft Dynamics 365 Business Central sales orders

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

Before you begin

  1. Verify that Item Id in Amazon Seller Central and Item Number in Microsoft Dynamics 365 Business Central are the same.
  2. Verify that the Payment Method name in Amazon Seller Central and Payment Method code in Microsoft Dynamics 365 Business Central are the same.
  3. Verify that Shipment Service Level Category name in Amazon Seller Central 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 Seller Central
    • Export: Get Amazon Seller Central orders - retrieves all orders since the last time the flow ran and transforms data from XML to JSON.
    • Lookup: Get Amazon Seller Central 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 Seller Central customers as Microsoft Dynamics 365 Business Central customers.
    • Import: Import Microsoft Dynamics 365 Business Central sales orders - adds new or ignores existing Amazon Seller Central orders as Microsoft Dynamics 365 Business Central sales orders.
    • Import: Import Microsoft Dynamics 365 Business Central sales order lines - adds or updates Amazon Seller Central sales items as Microsoft Dynamics 365 Business Central sales order lines.
Picture4.pngResults mappings: Get Amazon Seller Central orderitems
Picture5.pngResults mapping: Get Microsoft Dynamics 365 Business Central companies
2.pngImport mappings: Import Microsoft Dynamics 365 Business Central customers
Picture7.pngResponse mappings: Import Microsoft Dynamics 365 Business Central customers
3.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
4.pngImport mappings: Import Microsoft Dynamics 365 Business Central sales order lines

Microsoft Dynamics 365 Business Central fulfillments (SO with status fulfilled) to Amazon Seller Central 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 Seller Central as a fulfillment.

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 the tracking number on the Amazon Seller Central 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 Seller Central
    • Import: Import Amazon Seller Central fulfillments - adds sales orders, sales order lines, and shipment methods from Microsoft Dynamics 365 Business Central as Amazon Seller Central 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 Seller Central Fulfillments
image__8_.pngImport mapping: Import Amazon Seller Central Fulfillments

Microsoft Dynamics 365 Business Central inventories to Amazon Seller Central inventories

This flow exports newly created item quantities in Microsoft Dynamics 365 Business Central them as Amazon Seller Central 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 Seller Central 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 Seller Central
    • Import: Import Amazon Seller Central inventories - adds all items from Microsoft Dynamics 365 Business Central as Amazon Seller Central inventories.
Picture6.pngResponse mappings: Get Microsoft Dynamics 365 Business Central items
importMappingInv.pngImport mapping: Import Amazon Seller Central inventories

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

This flow exports newly created item prices in Microsoft Dynamics 365 Business Central and imports them into Amazon Seller Central 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 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 Seller Central
    • Import: Import Amazon Seller Central product prices - adds all items from Microsoft Dynamics 365 Business Central as Amazon Seller Central 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 Seller Central product prices
priceImpMap.pngImport mapping: Import Amazon Seller Central product prices

Related articles

Comments

0 comments

Please sign in to leave a comment.