After the order details are synchronized with Amazon MCF, Amazon MCF fulfills the order and updates the associated fulfillment information, including tracking numbers and package details. The Amazon (MCF) Shipment to NetSuite Fulfillment Add flow syncs these shipping and fulfillment details from your Amazon MCF account into your NetSuite account.
Prerequisite
To sync fulfillment details for an order, the order must be from the same Amazon MCF account, and its SellerFulfillmentOrderId must match the value provided in the NetSuite Order ID setting under Settings > Order.
Supported fulfillment status
Fulfillment details are synced based on the field mappings configured in the Amazon (MCF) Shipment to NetSuite Fulfillment Add flow. The integration app supports importing fulfillment information from Amazon MCF to NetSuite for orders with the following statuses:
- Complete
- CompletedPartialled
- Processing
Note
The integration app supports importing multiple tracking IDs from Amazon MCF to NetSuite, which can be associated with an individual order.
- Go to Settings > Fulfillment in the integration app.
- Use the Amazon Seller Fulfillment Order ID setting to sync on-demand fulfillment details for a specific order. Enter the SellerFulfillmentOrderId and click Save.
Specify the date used for selecting fulfillment orders that were last updated after (or at) a specified time in the Add shipments updated after setting.
- Use the Add shipments updated after setting only when you need to backfill or reprocess historical data. This flow is designed to run incrementally (delta), meaning it automatically processes only new or updated records. Setting a date in this field forces the flow to fetch and process all records updated since that date, which can significantly increase run time and system load.
- Leave the Add shipments updated field blank for regular operations. Specify a date only for one-time use cases such as initial data sync, reprocessing, or troubleshooting.
Note
- An update is defined as any change in fulfillment order status, including the creation of a new fulfillment order.
- Select Automatically assign Lot/Serialized numbers to automatically allocate serial or lot numbers to serialized and lot-numbered items. For serialized items, the earliest created serial numbers are assigned. For lot-numbered items, the lot closest to expiration is assigned or, if no expiration date is available, the lot created at the earliest is used.
- When configuring Select inventory location present in NetSuite, select the NetSuite inventory/fulfillment location to apply to both the body and line levels of the fulfillment.
- Click Save to save the changes made to the settings.
- Enable the Amazon (MCF) Shipment to NetSuite Fulfillment Add flow in the Flows tab of the integration app.
-
Click Edit mapping (
) to verify, update, or add field mappings.
Note
This step is required only for the initial flow run or after the flow has been disabled and re-enabled.
- Make changes as needed to the field mappings and click Save & close to exit the Edit mapping pane.
- You can schedule the Amazon (MCF) Shipment to NetSuite Fulfillment Add flow to run automatically. The frequency can be customized using presets from 15 minutes to once a week or by selecting a duration of your choice. To learn how to schedule the order data flow, see Scheduling flows.
- Click Run (
) to run the flow.
Troubleshoot fulfillment status and sync errors
If completed Amazon MCF orders do not create an Item Fulfillment record in NetSuite, or an on-demand import returns an error similar to the following, verify that the flow's input filter is configured with the correct shipment status:
Failed to import fulfillment order from Amazon. { "errors": [{ "code": "InvalidInput", "message":
"Received 500 response", "details": "" }] }
Note
Set the flow's input filter to Shipped and rerun the flow. Amazon MCF always returns the fulfillment shipment status as Shipped even when the Amazon console shows the order as Completed or Dispatched, so filtering on any other status skips matching records and prevents Item Fulfillment records from being created in NetSuite.
Related articles