The term FBA means Fulfilled by Amazon, sellers are expected to ship the inventory to Amazon Warehouses and Amazon is responsible for the fulfillment, returns, and refunds for the orders. It is also known as AFN (Amazon Fulfilled Network).
The order or customer data flow automatically pushes orders and associated customer information from Amazon to NetSuite periodically. The integration app Celigo is used to connect the amazon and NetSuite and t share the data between them.
Importing FBA Order Into NetSuite
1)Ensure that you have an SKU in Amazon that also exists in NetSuite with the same SKU name/number. If you don’t already have one, use the steps as follows
In your Amazon seller central account, Go to the Inventory tab > Add product and create a new product.
In NetSuite, Go to Lists > Accounting > Items > New > Inventory Item and create an item
2) From buyer account, create a test sales order for the same product and enter the necessary order details. Once the order is placed, make a note of the order id. Alternatively, can skip step 1 and 2 and use an existing order which has not been imported in NetSuite. When using existing order, please ensure that the item for which the existing order was placed exists both in NetSuite and Amazon.
3) In the Amazon (FBA) order to NetSuite order Add flow mappings, in the Amazon (FBA) Order Import Adaptor, ensure to select eTail Channel (Name) in the Import field NetSuite, instead of eTail Channel (InternalId). This ensures that the order lookup is successful when you run the flow.
4) In NetSuite, ensure that the Celigo Amazon IO Account page has the correct integration store ID populated in the Account ID field. Do not enter the account ID manually. This ensures that the order lookup is successful when you run the flow.
5) Navigate to the Integration App settings page in the integrator.io, go to Settings > Order section > Order tab, and perform the following steps:
- Click the Shipping tab and click Map Ship Methods.
- Select a value in the Default Lookup Value field.
- Click Save.
6) Click the Off /On switch to enable the Amazon Order (FBA) to NetSuite Order Add flow.
Import FBA order
- In the Order section, under Settings click the Order tab.
- Enter the Amazon Order Id (noted in Step 2 of the prerequisites) in the Amazon Order Id(s) text box.
- Click Save. This action triggers the Integration App to pull the specified order details from Amazon and push it into NetSuite.
- To monitor the success or failure of this action, click on the speedometer icon to the top right of the Integration App Settings page to open up the Dashboard page. On this page, you should see a new job in a few seconds that changes its status from Queued -> In Progress -> Completed.
- If the job status shows “Completed” with a success count as 1, this indicates that the order has been successfully added into NetSuite and you can directly go to Step #5.
- If the job status shows “Errored” with an error count as 1, this indicates the order import has failed. In this case, use the following steps to resolve the error:
- Click on the View button next to the error count on the same job to know why the order import failed.
- Fix the error and retry the same job using the Retry button. Note: As NetSuite does not report all errors with an order at once, you may need to fix errors one by one as they appear till the order is successfully added into NetSuite.
- Navigate to your NetSuite account and put the same “Amazon Order Id” in the global search box to find the order record created in NetSuite for the corresponding order in Amazon.