Proposal summary

The proposal details the integration between NetSuite and Amazon Vendor Central Integration via Selling partner API (SP-API).

The scope of the integration covers

• Fetching Purchase Order from Amazon
• Creating corresponding Sales Order in NetSuite 
• Acknowledge whether the Sales Order can be fulfilled by the client back to Amazon
• When corresponding Item Fulfillment is created for Sales Order, and the Item Fulfillment is shipped, inform this back to Amazon
• When a corresponding Invoice is created for the Sales Order, inform this back to Amazon

Our Solution

A custom record will be setup for configuring Amazon Vendor Central accounts, say ‘Amazon Integration Config’
This contains all the necessary fields such as API key, customer (under which Sales Order should be created), Item Price Level, etc. The NetSuite user can manage access to this custom record using the role permission.

A map-reduce script will execute once every day and if this custom record is properly configured

Another custom record (say ‘Amazon Integration Status’) will be created and its purpose is to track all the transactions created by the integration. This also helps in error handling and to inform the user about the same.

The map-reduce script will check whether any new purchase order is created in the last 7 days.
If there is any and if it is not already synced with NetSuite, a corresponding entry will be created in the custom record   ‘Amazon Integration Status’ and a Sales Order will be created in the ‘Pending Approval’ status under the predefined customer with the item price level.


While creating a Sales Order, if there is an Item Rate mismatch between Amazon and NetSuite, such lines will be closed. If all the items in Sales Order have an item rate mismatch, then immediately, the map-reduce script will acknowledge back to Amazon that the Purchase Order cannot be fulfilled and the Sales Order will be closed in NetSuite and no further approval required.

When a user in NetSuite approves a Sales Order, a User-Event script will acknowledge back to Amazon that all the Item in Sales Order which is not closed can be fulfilled.
The closed item lines will be acknowledged as rejected.

When an Item Fulfillment is created/updated and the status is ‘Shipped’ for the Amazon Sales Order, then another User-Event script will send the shipment confirmation information to Amazon.

When an Invoice is created for the Amazon Sales Order, then another User-Event script will submit invoice details to Amazon.

All transactions under consideration will contain the necessary custom fields to track additional information from Amazon if need be.

Assumptions

• Authorization Initial steps should be handled by the client
• Amazon sandbox environment will be provided
• The product code can be retrieved from Amazon API and this will match the Item Item ID/UPC code. This will be the unique identifier to identify the items between NetSuite and Amazon
• Only the Inventory Items and Matrix Inventory Items are considered
• Lot Numbered and Serialised Inventory Item Types are not considered
• The currency is always Euro

Risks 

• Amazon is stringent on providing personally identifiable information related to customer

Time

Effort required: 60h