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
- Overview: Understanding the Amazon MWS - Acumatica quickstart integration template
- Install the Amazon MWS - Acumatica quickstart integration template
- Configure and run the flows in the Amazon MWS - Acumatica integration template
- Acumatica to Amazon MWS
- Acumatica inventories to Amazon MWS inventories
- Acumatica kit inventories to Amazon MWS inventories
- Acumatica items price to Amazon MWS products price
- Acumatica items to Amazon MWS products
- Acumatica sales order cancellations to Amazon MWS order cancellations
- Acumatica shipments to Amazon MWS fulfillments
- Acumatica to Acumatica
- Amazon MWS to Acumatica
- Amazon MWS orders to Acumatica sales orders
- Amazon MWS customers to Acumatica customers
- Amazon MWS sales order cancellations to Acumatica sales order cancellations
- Amazon MWS settlement reports to Acumatica customer refunds
- Amazon MWS settlement reports to Acumatica payments
- Amazon MWS settlement reports to Acumatica journal transactions
- Amazon MWS (FBA) integration flows
- Acumatica to Amazon MWS
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.
- 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.
- 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.
- 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.
- Mappings for:
- 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
- A multi-field for:
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.
- 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.
- 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
- Mapping for:
- 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.
- 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.
- From your integrator.io home page, click Amazon MWS-Acumatica integration tile.
- In the Flows section, enable the On/Off toggle button next to the flow.
- On the confirmation window, click Yes.
- Click Run next to the appropriate flow.
Comments
0 comments
Please sign in to leave a comment.