The NetSuite Order to Amazon (MCF) Order Add flow in the Amazon MCF - NetSuite integration app sends NetSuite sales order lines that are pending fulfillment to Amazon, so Amazon Multi-Channel Fulfillment can ship them. Orders can come from any sales channel that creates sales orders in NetSuite. This article covers how to choose which orders sync, how to map ship methods between NetSuite and Amazon, and how to run the flow.
How orders sync
The flow picks up sales orders from a NetSuite saved search and creates a fulfillment order in Amazon for each eligible order line. Amazon generates the shipment information for each line.
After an order is created in Amazon, the flow selects Amazon MCF Order Exported on the NetSuite sales order, under eTail > Amazon. The flow skips orders that have this box selected, so the same order isn't sent to Amazon twice.
Note: If your Amazon fulfillment network doesn't have enough inventory for an order, Amazon returns an error and doesn't create the fulfillment order.
Customize the order saved search
When you install the integration app, it creates two NetSuite saved searches named Celigo Amazon MCF Order Export Search. The locked search is a template for reference and is selected in the flow by default. The unlocked search is yours to change.
- In NetSuite, search for
Celigo Amazon MCF Order Export Search, and open the unlocked saved search. - On Criteria, change the conditions to match the orders you want Amazon to fulfill. In most cases, you change Location to the locations whose orders are fulfilled through Amazon MCF.
- Save the search, keeping its name or giving it a new one.
Configure the order settings
- Open the Amazon MCF - NetSuite integration app, and go to Settings > Order.
- For NetSuite saved search for syncing orders, select your saved search. If it isn't listed, select Refresh to load the saved searches from your NetSuite account.
- For NetSuite Order Id field, enter the internal ID of the NetSuite field that stores the Amazon MCF order ID. Change it only if you don't use the default eTail order ID field,
custbody_celigo_etail_order_id. -
In Ship Method Mapping, map each NetSuite ship method to an Amazon ship method:
- NetSuite Ship Method: The ship method on the NetSuite order.
- Amazon Ship Method: The Amazon ship method that matches it. If no values appear in either list, select Refresh.
- For Action to take if unique match not found, choose what happens when an order's ship method isn't mapped. See Unmapped ship method actions.
- Select Save.
Unmapped ship method actions
| Action | What happens to the order |
|---|---|
| Fail Record | The record fails with an error. |
| Use Empty String as Default Value | The order syncs with an empty ship method and no error. Don't use this action if NetSuite requires a ship method, which is usually the case. |
| Use Null as Default Value | The order syncs with a null ship method and no error, including orders where the value is only a space or invalid data. Don't use this action if NetSuite requires a ship method. |
| Use Custom Default Value | The order syncs with the ship method you select in Default Lookup Value. The values you can select must already exist in NetSuite. |
Run the order flow
- In the integration app, go to Flows, and turn on NetSuite Order to Amazon (MCF) Order Add.
- Select Edit mapping, and check, update, or add field mappings. For the Amazon fields you can map, see POST_FLAT_FILE_FULFILLMENT_ORDER_REQUEST_DATA in the Amazon Selling Partner API documentation, or your copy of the Amazon flat file (v2) template.
- 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.
- To sync orders now, select Run.