Articles in this section

Sync Amazon MCF fulfillments to NetSuite

Saikumar Rachamalla
Updated

The Amazon (MCF) Shipment to NetSuite Fulfillment Add flow in the Amazon MCF - NetSuite integration app brings Amazon's shipping and fulfillment details, including tracking numbers and package details, into NetSuite after Amazon MCF fulfills an order. The flow creates an item fulfillment in NetSuite for the items Amazon shipped. This article covers which orders the flow picks up, the fulfillment settings, and how to run the flow.

Prerequisites: The order must come from the same Amazon MCF account, and its Amazon SellerFulfillmentOrderId must match the value in the NetSuite field set in NetSuite Order Id field under Settings > Order. For details, see Configure the order settings.

Which fulfillments sync

The flow is a delta flow: each run picks up only the Amazon fulfillment orders that changed since the last run. A change is any change in fulfillment order status, including a new fulfillment order.

The flow imports fulfillment details for orders with these Amazon statuses:

  • Complete
  • CompletePartialled
  • Processing

An order can have several tracking IDs, and the flow imports all of them. Which details reach NetSuite depends on the flow's field mappings.

Configure the fulfillment settings

  1. Open the Amazon MCF - NetSuite integration app, and go to Settings > Fulfillment.

  2. Set any of these settings, and then select Save:

    • Amazon Seller Fulfillment Order Id: Enter an order's SellerFulfillmentOrderId to sync that order's fulfillment details on demand.
    • Add shipments updated after: Enter a date to fetch every fulfillment order updated on or after it. Use this only for one-time needs, such as an initial sync, reprocessing, or troubleshooting, and leave it blank for regular runs. A date here makes the flow process every record since that date instead of only new changes, which can make runs much longer.
    • Automatically assign Lot/Serialised numbers: Select to assign serial or lot numbers automatically. Serialized items get the earliest created serial numbers. Lot-numbered items get the lot closest to expiration, or the earliest created lot if no expiration date is available.
    • Select inventory location present in NetSuite: Select the NetSuite inventory location that the flow sets at both the header and line level when it sets the item fulfillment's inventory detail.

Run the fulfillment flow

  1. In the integration app, go to Flows, and turn on Amazon (MCF) Shipment to NetSuite Fulfillment Add.
  2. Before the first run, and whenever you turn the flow off and on again, select Edit mapping and check, update, or add field mappings.
  3. Select Schedule, and choose how often the flow runs. You can pick a preset from every 15 minutes to once a week, or set your own frequency.
  4. To sync fulfillments now, select Run.

If completed orders don't create item fulfillments in NetSuite, see Fulfillment orders don't create item fulfillments.