Configure Amazon MFN order settings – Celigo Help Center

Before running data flows, you may want to set up the data flow and save the settings.

You can set up the ship methods, orders and customer filters before you run the data flow. You can filter orders based on the time of their creation, or specific customer duration or order status. You have options to map the ship methods between the systems. You have options to import multiple Amazon orders into NetSuite.

General tab

Filter orders by: Let’s you select the time filter. Based on the value selected in the drop-down, the associated orders within the specified duration are imported from Amazon to NetSuite. Two options are: Last modified time and Creation time. The recommended option is to select the last modified date and leave the duration in days option as blank. The option is a delta flow (searches for the latest or updated orders)
Duration in days: Specify the duration in days to import orders. The duration is considered from now till the specified number of days in past.
Go Live Date: Enter the date from when you want to start importing orders. All Amazon orders created prior to this date are ignored. When specified, this date takes precedence over the Duration setting.
Sync orders when order status is: This multi-select field allows you to select the order statuses. Only the order with status matching your selection is synced with NetSuite. The leading practice is to set this field as 'Unshipped' and 'Canceled' once you are live. To understand more about canceled orders, refer here.
Item aliases are configured in NetSuite: If you have configured item aliases in NetSuite, by checking this box it allows you to link multiple Amazon SKUs with a single SKU in NetSuite. For more information, refer Item Aliases.

Shipping tab

This setting lets you map the shipping methods between Amazon and NetSuite. You can also provide a default value in case no match is found. Click in the row to select and map the shipping method.

Fail if unique match not found: Select this checkbox, if you want the order sync to fail when there is no match.
Default lookup value: Select from the list.
Use Null as default value: Select this checkbox If you wish to use null as default value.
Use Empty string as default value: Select checkbox when you want to use the empty string as default value.

Orders tab

Amazon order IDs: You can provide up to 10 Amazon order ids separated by a comma (,) for an on-demand import of orders from Amazon to NetSuite.
NetSuite discount item to track Amazon discounts: Lets you choose the corresponding NetSuite item to track promotion/discount amounts on your Amazon orders. Promotion codes applied on the Amazon SKUs are mapped to the "eTail Discount Code" field at the line level on the Sales Order record in NetSuite.
NetSuite item to track Amazon Gift Wrap amounts and taxes: Select the NetSuite item to track gift wrap amounts/taxes on the Amazon orders. You need to create an item of "Non-Inventory" type in NetSuite and add it here, the Integration App will create an order line with this item for the total giftwrap amounts and taxes. It's recommended to unset "Can be Fulfilled/Received (isfulfillable)" on the selected item record.
NetSuite item to track Amazon Shipping amounts and taxes: Select the NetSuite item to track shipping amounts/taxes on the Amazon orders. You need to create an item of "Non-Inventory" type in NetSuite and add it here, the Integration App will create an order line with this item for the total shipping amounts and taxes. It's recommended to unset "Can be Fulfilled/Received (isfulfillable)" on the selected item record.
Deduct GST/VAT from order total: Enable this checkbox to deduct GST/VAT from the order total before it is added to NetSuite.
Exclude Canceled Items: Lets you exclude/ignore importing a canceled item in Amazon, i.e., item with 0 quantity.

Customers tab

Default NetSuite Customer for All Amazon Orders: Provide the internal id of the default customer record in NetSuite if you prefer to skip the creation of new customer records in NetSuite for each new order from Amazon and assign a default customer record to all the Amazon orders.
Remove phone number if invalid on Amazon order: Lets you define a business rule where invalid phone numbers on Amazon order are automatically removed before the order is added to NetSuite. This prevents any manual intervention to import orders with invalid phone no.s (<7 digits or alphanumeric format).
Trim customer name if invalid on Amazon order: Lets you define a business rule where an invalid first name and last name on Amazon order are automatically trimmed to first 32 characters before the order is added to NetSuite. This prevents order import failures when the buyer enters more than 32 char for first name and/or last name fields in Amazon.
Use ShippingAddress/Name when Buyer Name is Missing: Lets you define a business rule where Buyer Name on Amazon order is missing then we should consider ShippingAddress -> Name as NetSuite first name and last name.
Default first name if missing on Amazon order: Lets you define a business rule where the missing first name on Amazon order is automatically replaced with a default value of your choice before the order is added to NetSuite. This helps prevent any manual intervention to import orders with missing first name. E.g. you can enter a default value FNU i.e. First Name Unavailable in this field.
Default last name if missing on Amazon order: Lets you define a business rule where the missing last name on Amazon order is automatically replaced with a default value of your choice before the order is added to NetSuite. This helps prevent any manual intervention to import orders with missing last name. E.g. you can enter a default value LNU i.e. Last Name Unavailable in this field.

Related topics

Related articles