The objective of this proposal is to outline the integration of Amazon seller central with NetSuite to synchronize order processing between the two platforms. This integration aims to streamline the sales order process, reducing manual intervention, while ensuring accuracy and efficiency.
Proposal Summary
This proposal summarizes the functionality for integrating Amazon seller central with NetSuite.
Requirement
When customer purchases goods from amazon, integrate this order from Amazon to NetSuite as sales order. This will be a one-way integration from Amazon to NetSuite. The integration flow will be from Amazon to NetSuite. As per the requirement we have to fetch periodically newly created order from Amazon and create corresponding orders in NetSuite. We will be creating all orders from Amazon for a unique customer in NetSuite.
Deliverables
Register as a developer on the Amazon Selling Partner API Portal.
Create a new application to obtain essential API credentials (LWA_ID, LWA_SECRET, and REFRESH_TOKEN).
Grant the necessary permissions for the app to access the seller account through Amazon.
Create a dedicated integration record in NetSuite to manage the connection.
Configure the integration with necessary details, including authentication method and credentials.
The sales orders will be created on a scheduled basis.
Develop a Map reduce script tailored for extracting orders from Amazon Seller Central and transforming them into NetSuite sales orders.
Schedule the Map reduce script to run on a daily basis to fetch new orders from Amazon Seller Central.
Automate the creation of corresponding sales orders in NetSuite.
Configure the Map reduce script to generate an error file in CSV format containing detailed information about encountered errors.
We will be creating a custom record in NetSuite for storing the error details for the future reference.
Set up an email notification system within the Map Reduce script to automatically notify relevant stakeholders of any errors. The notification will include the error file as an attachment.
Assumptions
· A specific customer record exists in NetSuite for creating all sales orders from Amazon.
· We will create the sales order only if the item in the order from Amazon exists in NetSuite.
· We will avoid duplicate order creation in NetSuite having same customer-PO combination.
· We will not create historical orders from Amazon. The script will fetch orders which are created after the script deployment in NetSuite production environment.
· The Amazon order ID will be mapped to the PO field in NetSuite. This will be used for duplicate order detection.
· If any of the Amazon items are missing in NetSuite the entire order will not be created in NetSuite.
· Regarding the tax and discount, we will not consider this in order creation. We will use custom price level and store quantity and line total in NetSuite.
Questions
· What unique identifier is used for items on Amazon (SKU, ASIN), and how is it mapped to the corresponding identifier in NetSuite?
· How does pricing work on Amazon and how is it mirrored in NetSuite?
· How are promotions and discounts managed on Amazon, and how are these reflected in NetSuite?
· If dealing with multiple currencies, how is currency conversion handled between Amazon and NetSuite?
· How are taxes applied to prices on Amazon, and how does the integration account for tax differences between platforms?