Skip to main content

Configure and run the Amazon MWS - Acumatica quickstart integration template flows

Naga Sri Hari Gonaboyina
  • Updated

The Amazon MWS - Acumatica Quickstart template comprises a set of pre-built integration flows. These flows help you to sync information of sales orders, customers, refunds & settlements, inventory levels, products, shipments, invoices, and cancellations between Amazon MWS and Acumatica.

Contents

Understand and configure your integration flows

Acumatica to Amazon MWS

Acumatica inventories to Amazon MWS inventories

The flow syncs the inventory information from Acumatica to Amazon. The flow only updates the inventory information. 

Note: To sync the data, ensure that the product SKU in Amazon and stock items Inventory ID in Acumatica are the same.

In “Import Amazon MWS inventories,” ensure to configure the following mappings as per your requirement before you run the flow:

  • SwitchFulfillmentTo
  • Mandatory field mappings:
    • SKU
    • Quantity 
    • FulfillmentCenterID

Acumatica kit inventories to Amazon MWS inventories

The flow syncs the kit inventory information from Acumatica to Amazon. The flow only updates the kit inventory information. 

Note: To sync the data, ensure that the product SKU in Amazon and kit inventory ID in Acumatica are the same.

Before you run the flow, in “Import Amazon MWS inventories,” ensure to configure the following mappings as per your requirement:

  • SwitchFulfillmentTo
  • Mandatory field mappings:
    • SKU
    • Quantity 
    • FulfillmentCenterID

Acumatica items price to Amazon MWS products price

The flow syncs the Acumatica item price to the product price in Amazon MWS. The flow only updates the product price and does not allow you to add the product price. 

Note: To sync the data, ensure that the product SKU in Amazon and stock items Inventory ID in Acumatica are the same.

Before you run the flow, in “Import Amazon MWS inventories,” ensure to configure the following mappings as per your requirement:

  • SKU
  • StandardPrice 
  • Currency

Acumatica items to Amazon MWS products

The flow syncs the Acumatica items as products in Amazon MWS. The flow adds and updates the product information to Amazon.

Note: To sync the data, ensure the following:
  • The Postingclass ID in Acumatica and the first 10 index values of Product Category in Amazon should match.
  • The Itemclass description in Acumatica and the value of the Product subcategory in Amazon should be the same.
  • The item type in Amazon and the custom field value in Acumatica should be the same.
  • The StandardProductID value in Amazon and the custom field value in Acumatica should be the same.

Before you run the flow, in “Import Amazon MWS products,” ensure to configure the following as per your requirement: 

  • In “Create HTTP Query,” configure the subcategories mapping. More categories and subcategories can be added to the body.
    Note: The mapping field should not be empty.
  • Create a custom field of type "text" on StockItems record type in Acumatica. The custom field stores the item-type and StandardProductID value of Amazon.
    • The item type in Amazon and the custom field value in Acumatica should be the same.
    • The StandardProductID value in Amazon and the custom field value in Acumatica should be the same.
  • In Get Acumatica stock items > Configure search parameters > Custom, configure the custom field IDs in Queryparameter on stockitems export.
  • Following are the list of mandatory fields or mappings:
    • SKU
    • StandardProductID.Type
    • StandardProductID.Value
    • ProductTaxCode
    • DescriptionData.Title
    • DescriptionData.Brand
    • DescriptionData.Manufacturer
    • DescriptionData.MfrPartNumber
    • DescriptionData.ItemType 
    • ProductData(Categories)
    • ProductType(Subcategories) 
    • ProductType.MaterialType

Acumatica salesorder cancellations to Amazon MWS order cancellations

The flow syncs the Acumatica sales order cancellation as an order cancellation in Amazon MWS. The flow only updates the status of the sales order cancellation. 

Note: To sync the data, the Amazon order ID should be stored in the External Reference field in the Acumatica orders. 

Before you run the flow, in the “Import Amazon MWS Order Cancellations,” ensure to configure the following:

  • A hard-coded mapping for StatusCode
  • A mandatory field mapping for AmazonOrderID.

Acumatica shipments to Amazon MWS fulfillments

The flow syncs the Acumatica shipment as fulfillment in Amazon MWS. The flow only adds the shipment information to Amazon and does not update the shipment information.

Note: To sync the data, ensure the following:
  • The OrderID in Amazon and the External Reference value of the order in Acumatica should be the same.
  • The OrderItemID in Amazon and the LineDescription value of the item in Acumatica should be the same.
  • The CarrierName in Amazon and the ShipVia value in Acumatica should be the same.

Before you run the flow, in “Import Amazon MWS fulfillments,” ensure to configure the following mappings as per your requirement: 

  • TimeZone for Fulfillment Date
  • ShipperTrackingNumber 
  • AmazonOrderID
  • FulfillmentDate
  • FulfillmentData.CarrierName
  • FulfillmentData.CarrierCode
  • Item.AmazonOrderItemCode
  • Item.Quantity

Acumatica to Acumatica

Acumatica sales orders to Acumatica cash sales

The flow syncs the sales orders as cash sales in Acumatica. This flow only adds cash sales to Acumatica.

Before you run the flow, configure the following mappings as per your requirement:

  • In “Import Acumatica sales invoice of type cash sale”
    • Type.value 
    • CustomerID.value
  • In “Update Acumatica sales orders”:
    • Store the Acumatica invoice ID in CustomerOrder.value field of Acumatica sales order. Later, configure it as lookup criteria on the import. 

Acumatica sales order to Acumatica payments

The flow syncs the sales order as payments in Acumatica. 

Before you run the flow, configure the following mappings as per your requirements:

  • In “Get Acumatica sale orders,” configure "Filter" in search parameters.
  • In “Import Acumatica payments,”
    • Type.value 
    • CustomerID.value
    • CashAccount.value 
    • PaymentAmount.value

Amazon MWS to Acumatica

Amazon MWS orders to Acumatica sales orders

The flow syncs the Amazon MWS orders as sales orders in Acumatica. The flow only adds the sales orders to Acumatica and does not update the sales order information.

Note: To sync the data, ensure the following:
  • The products SKU in Amazon and InventoryID in Acumatica should be the same. 
  • Create a non-stock Item in Acumatica with InventoryID "AMAZONGIFT " (to add Amazon Gift wraps for all order items). 
  • The Shipvia calculation method in Acumatica must be “manual.”

Important: Ignore the warning message that is displayed while creating a new customer in the "Amazon MWS orders to Acumatica salesorders" flow. ”No value found in \"16b738409ceb4415b4b4eca3b83a8bdb\" lookup result using extract: CustomerID.value ”. Please ignore it”.

Before you run the flow, configure the following as per your business requirement:

  • In “Import Acumatica customers,” 
    • Mappings for:
      • Status.value
      • CustomerClass.value
      • StatementCycleID.value 
    • Dynamic mapping for CustomerID.value
    • Mandatory mappings
      • CustomerName.value 
      • MainContact.Address.Country.value.
  • In “Import Acumatica salesorders,”
    • A multi-field for: 
      • RequestedOn.value
      • Date.value
      • ShippingSettings.ScheduledShipmentDate.value
    • A mapping for:
      • OrderType.value
      • ShipToAddressOverride.value
      • ShipToContactOverride.value
      • Details[*].ManualDiscount.value
    • A static mapping for:
      • Payment Method
      • ShipVia
    • A mandatory mapping for CustomerID.value

Amazon MWS customers to Acumatica customers

The flow syncs the customers between Amazon MWS and Acumatica. 

Important: Ignore the message that is displayed while creating a new customer in the flow "Amazon MWS customers to Acumatica customers" flow. “no value found in \"16b738409ceb4415b4b4eca3b83a8bdb\" lookup result using extract: CustomerID.value ”. Please ignore it.”

In “Import Acumatica customers,” before you run the flow, configure the following as per your business requirement:

  • Mapping for:
    • Status.value
    • CustomerClass.value
    • StatementCycleID.value 
  • Dynamic mapping for CustomerID.value
  • Mandatory mappings for: 
    • CustomerName.value 
    • MainContact.Address.Country.value.

Amazon MWS sales order cancellations to Acumatica sales order cancellations

The flow syncs the sales order cancellation from Amazon MWS to Acumatica. The flow only updates the status of the sales order cancellation.

Note: To sync the data, ensure that the Amazon order ID is stored in the ExternalRef field on the Acumatica orders. 

In “Import Acumatica sales order cancellations,” before you run the flow, configure the following mappings as per your business requirement:

  • A dynamic lookup mapping for entity.OrderNbr.value
  • A mapping for:
    • entity.OrderType.value
    • entity.Status.value

Amazon MWS settlement reports to Acumatica customer refunds

The flow syncs the Amazon MWS settlements as customer refunds in Acumatica. The flow only adds the customer refunds and does not update the customer refund information. 

Note: To sync the data, ensure the following:
  • The Amazon MWS orders must be synced with Acumatica orders.
  • The Amazon MWS order ID should be stored in the ExternalRef.value field of Acumatica order.
  • The appropriate credit memo and invoice should exist in Acumatica. The Amazon MWS order ID should be stored in the CustomerOrder field of the Acumatica invoice and credit memo records.  

Before you run the flow, in “Import Acumatica customer refunds,” configure the following:

  • Mapping for:
    • Type.value
    • DocumentsToApply[*].DocType.value 
  • Dynamic mapping for DocumentsToApply[*].ReferenceNbr.value
  • Multi-field for:
    • DocumentsToApply[*].AmountPaid.value
    • PaymentRef.value.
  • Mandatory mappings for:
    • CustomerID.value 
    • CashAccount.value  

Amazon MWS settlement reports to Acumatica payments

The flow syncs the Amazon MWS settlement reports as payments in Acumatica. The flow only adds the payment information and does not update the payment records.

Note: To sync the data, ensure the following:
  • The Amazon MWS orders must be synced with Acumatica orders.
  • The Amazon MWS order ID should be stored in the ExternalRef.value field of the Acumatica sales order.
  • Sales invoices should be already there in Acumatica and Amazon MWS orderid should be stored in the CustomerOrder field of sales invoice record type in Acumatica.

Before you run the flow, in “Import Acumatica payments,” configure the following:

  • Mapping for:
    • CashAccount.value 
    • Type.value
  • Mandatory mappings for: 
    • CustomerID.value 
    • PaymentAmount.value

Amazon MWS settlement reports to Acumatica journal transactions

This flow syncs the new settlement reports from Amazon as journal transactions in Acumatica. When settlement reports are created in Amazon, the flow syncs the settlement reports from Amazon to Acumatica.

Note: Create custom fields on the journal transaction record type in Acumatica to store the details of the settlement record.

Before you run the flow, in the Import Acumatica journal transactions page processor configure the Module.value mapping as per your business requirement. 

Amazon MWS (FBA) integration flows

Amazon MWS orders (FBA) to Acumatica sales orders

The flow syncs the Amazon MWS (FBA) orders as sales orders in Acumatica. The flow only adds the order information to Acumatica and does not update the orders.

Note: To sync the data, ensure that the product SKU in Amazon and InventoryID in Acumatica should be the same.

Before you run the flow, configure the following as per your business requirement:

  • In “Import Acumatica customers”:
    • Mapping for:
      • Status.value
      • CustomerClass.value
      • StatementCycleID.value 
    • Mandatory mapping:
      • CustomerName.value
      • MainContact.Address.Country.value
    • Dynamic lookup mapping for CustomerID.value
  • In “Import Acumatica sales orders”:
  • A multi-field for:
    • RequestedOn.value
    • Date.value
    • ShippingSettings.ScheduledShipmentDate.value.
  • Static mapping for:
    • PaymentMethod.value 
    • ShipVia.value 
  • Mappings for:
    • OrderType.value
    • ShipToAddressOverride.value, 
    • ShipToContactOverride.value and 
    • Details[*].ManualDiscount.value
  • Mandatory mapping for CustomerID.value

Amazon MWS inventory adjustments (FBA) to Acumatica inventory adjustments

The flow syncs the Amazon MWS (FBA) inventory adjustments as inventory adjustments in Acumatica. 

Note: To sync the data, the product SKU in Amazon and InventoryID in Acumatica should be the same.

Important: Ignore the error message that is displayed while creating a new adjustment in the "Amazon MWS inventory adjustments(FBA) to Acumatica inventory adjustments" flow. "No value found in \"lookup id (example: fe8751ba5e7b426caf93d2b57da4b6ca) \" lookup result using extract: 0.ReferenceNbr.value”. Please ignore it”.

Before you run the flow, in “Import Acumatica adjustments,” configure a dynamic mapping for ReferenceNbr.value.

Amazon shipment status (FBA) to Acumatica transfer receipts

The flow syncs the Amazon (FBA) shipments as transfer receipts in Acumatica. The flow only adds the transfer receipts and does not update the information.

Note: To sync the data, ensure the following:
  • The product SKU in Amazon and stock items Inventory ID in Acumatica should match.
  • Amazon shipment ID should be stored as the ExternalRef value in Acumatica transfer orders and Acumatica transfer orders should be in the “shipped” status.

Before you run the flow, in “Import Acumatica purchase receipts of type as transfer receipts” configure the Type.value and Details[*].TransferOrderType.value mappings as per your requirement.

Run your flow 

You need to enable the flow for it to run and perform the sync between your apps.

  1. From your integrator.io home page, click Amazon MWS-Acumatica integration tile.
  2. In the Flows section, enable the On/Off toggle button next to the flow. 
  3. On the confirmation window, click Yes.
  4. Click Run next to the appropriate flow.

Related articles

Comments

0 comments

Please sign in to leave a comment.