AMAZON MWS INTEGRATION

1. Create a script that will make the connection to Amazon MWS API to get orders.
2. Create a script that will make the connection to Amazon MWS API to update inventory count

Requirement

Order integration, we will fetch the orders from Amazon MWS and create a sales order in NetSuite.

Inventory count update, we will fetch all items location-wise quantity from Netsuite (Amazon FBA location). Then update item count in Amazon MWS according to the Amazon

Our Solution

Sales Order Sync

1. We will create a connection between Netsuite and Amazon MWS.
2. For order integration, we will fetch all orders from Amazon MWS to Netsuite using Listorders API.
3. We will use a filter in the API call for getting specific date orders from a specific date range (created after and created before). That means in a result the orders are only listed between created after the date and created before the date.
4. Using each order from the result we will create sales orders in NetSuite for a single customer. We will store “AmazonOrderId” in a custom field, for detecting duplicate orders in Netsuite. If a sales order with “AmazonOrderId” exists we will not create that order in Netsuite.
5. The order creation item mapping should be given by Robert green.
6. The entity for order creation should be given by Robert green.

Inventory Sync

1. Inventory count update, we will fetch all items location-wise quantity from Netsuite (Amazon FBA location) using a saved search. Then update item count in Amazon MWS according to the Netsuite Amazon FBA location count.
2. For updating product inventory count in Amazon MWS, we have to map item SKU between  Amazon MWS and Netsuite. (Mapping should be given by Robert Green)
3. For each SKU we will update the quantity of the items available from Netsuite (on  Amazon FBA location) to Amazon MWS.
4. If the item quantity is successfully updated in the Amazon MWS, the updated date will be stored in the item record custom field.

Assumptions

1. For inventory count updates we can send only one request every 2 minutes which implies a maximum of 30 API calls can be called in an hour.
2. We will consider the available quantity of Amazon FBA location is quantity item quantity in Amazon MWS.
3. We do not consider the historical data integration in order integration.
4. We will not consider the order update, delete, refund and fulfillment.
5. For detecting duplicate orders, we will check the amazon order id which is stored in a custom field in NetSuite (This will available only sales order which was created via amazon mws integration).

Question

1. For update item quantity from Netsuite to Amazon MWS. For this API call, we have to use a location-specific URL. kindly specify the Amazon MWS registered region URL? 

1. We need your Amazon MWS account credential for integration purposes. Kindly provide the Amazon MWS user credentials?