Configure Amazon FBA order flow settings

Before running data flows, you must 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 also have options to import multiple Amazon orders into NetSuite.

General

The General tab present under Settings > Order (FBA) contains the following fields that let you control the way orders are synced to NetSuite from Amazon.

The following diagram illustrates how various fields available under the General tab lets you sync Amazon orders to NetSuite and also demonstrates how a delta flow works.

To understand the various fields present under the General tab better, let's assume that,

• today's date and time of flow execution is 17th January 1300 HRS and that the Amazon (FBA) Order to NetSuite Order Add flow is already run for the first time,
• you have scheduled the Amazon (FBA) Order to NetSuite Order Add flow to run after every 15 minutes,
• and the values mentioned in the table below are entered under Settings > Order (FBA) > General.

Notes:

• When the Amazon (FBA) Order to NetSuite Order Add flow is being run for the very first time, it will not sync any received/modified orders to NetSuite. integrator.io considers the first run date and time as a reference to run the flow again as per the configured schedule.

For example, if you run the Amazon (FBA) Order to NetSuite Order Add flow on 17th January 1300 HRS for the first time and schedule it to run every 15 minutes, then for the first run, no orders will be synced to NetSuite.

As per the configured schedule, the flow will run again after 15 minutes at 17th January 1315 HRS, and the orders received/modified between 17th January 1300 HRS through 17th January 1315 HRS will be synced to NetSuite.

• For users who want to go live with the Amazon - NetSuite Integration App immediately or in the future: When scheduling and running the Amazon (FBA) Order to NetSuite Order Add flow for the first time set the Filter orders by drop-down list box to Creation Time and also specify a value in the Duration in days field. Later, you must change the value to Last Modified Time. This will help you sync all the orders from Amazon to NetSuite without missing any.

Table: Illustrates various scenarios available on the General tab.

Shipping

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 Record: Select this check box if you want the order sync to fail when there is no match.
• Use Empty String as Default Value: Select this check box to sync an empty value. 
• Use Null as Default Value: Select this checkbox If you wish to use null as default value.
• Use Custom Default Value: A field will be enabled then you can select from the list for a value.

Orders

• 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: This 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 Gift Wrap 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. 

Customers

• Allocate FBA orders to below NetSuite customer(s): Provide the internal ID(s) of NetSuite customers in a comma-separated format. Based on the number of customer IDs you provide, during order sync to NetSuite, the FBA orders are equally distributed among the mentioned customers. This setting lets you skip the creation of new customer records in NetSuite for each new order from Amazon.

Note: If the number of orders in a single job run is less than the number of mentioned customer ids, only the first few customers will be utilized without the random pick.

Also, If you provide an incorrect customer ID, the following error message is displayed: “Enter a valid customer internal ID(s).”

The FBA orders are allocated in a cyclic way (round-robin manner). The flow randomly picks the customer ID from the provided IDs and the order allocation continues to the next customer ID. The random pick is to ensure that the starting few customer ID(s) are not allocated with many FBA orders. Take note of some examples:

• • If you provide three valid customer internal ID(s): 123, 456, 789. When you run the settlement flow and if you have 30000 orders, each customer is allocated with 10000 orders.
  • If the flow first picks 456 as the customer ID, the first-order is allocated to the customer with ID 456, the second-order is allocated to the customer with ID 789, and the third-order is allocated to the customer with ID 123.
  • Provide the number of customers in the setting in such a way that in a settlement period, the number of invoices on any customer does not exceed 10,000. If the average volume of orders you receive in a settlement period is 100000, provide more than 10 customer IDs. If the volume of orders is around 20000 in a settlement period, provide 3 customer IDs.
• 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: This lets you define a business rule where an invalid first name and last name on Amazon order are automatically trimmed to the first 32 characters before the order is added to NetSuite. This prevents order import failures when the buyer enters more than 32 characters for the first name and/or last name fields in Amazon.
• Use Shipping Address/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: 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 the first names. For ex- you can enter a default value FNU i.e. First Name Unavailable in this field.
• Default last name if missing on Amazon order: This helps prevent any manual intervention to import orders with missing the last name.

Related topics

• Amazon (MFN) Order to NetSuite Order Add
  • Advanced Settings for Amazon Order (MFN)
• Amazon (FBA) Order to NetSuite Order Add