Proposal Summary
Our proposed solution outlines the development of the NetSuite and Amazon Inventory Available Quantity Sync. This involves fetching inventory items from NetSuite, incorporating Protec/Boulevard Location Available Quantity, and updating the available quantity on Amazon Seller Central using the SP-API Listings Items & Search Catalog items functionality. The process will occur twice daily, with a consolidated email notification in case of errors.
Requirement
Protec/Boulevard seeks to integrate NetSuite with Amazon Seller Central to synchronize Inventory Available Quantity. The Quantity Available from NetSuite should be exported and synced to Amazon Seller Central. The client aims for a scheduled sync twice a day.
Deliverables
To automate the synchronization process, a script will be developed for scheduled runs at 12 PM and 6 PM. The script will systematically fetch active inventory items from NetSuite, capturing essential details like Item Name and Protec/Boulevard Location Available Quantity. The recently (last day) available quantity changed items will be fetched for the Inventory sync process.
The items will be processed to retrieve Item Product Type using the Item ID (SKU) from Amazon Seller Central. This involves verifying the item’s presence on Amazon and collecting Item Product Type. If the item is available on Amazon Seller Central, the NetSuite Available Quantity will be updated on Amazon Seller Central.
The Available Quantity – 10 will be updated to the seller central. If the available quantity – 10 is a negative number, it will be updated to a value of 0. Also, the conditions in the NetSuite Saved Search “Protec Inventory Report (for PROTEC) Item” will be considered in the integration.
The synchronization process relies on the utilization of the “Search Catalog items” for fetching the item Product type “Listings Items” SP-API for updating item quantity on Amazon. The available quantity updates specifically target the Protecstyle United States Amazon seller central account.
Error Handling:
A consolidated email will notify the user of any unexpected errors during script execution.
Assumptions
- The proposal assumes a consistent level of stability and reliability in Amazon Seller Central. Any unexpected disruptions, downtimes, or alterations in the API structure may pose a risk to the successful execution of the scheduled script and data retrieval.
- The synchronization process focuses only on Inventory items. It assumes that other item types such as Kit/Package and Item Groups are not available on Amazon Seller Central.
- The assumption is made that the available quantity will be updated exclusively for the Protecstyle United States Amazon, utilizing the US Marketplace ID. It is assumed that there are no items within the Canada Amazon seller central account.
- The proposal assumes that the Fulfilment channel code value will be set to “DEFAULT” for all items, and that “DEFAULT” will be utilized in the API request for updating the available quantity.
Notes
- Due to API restrictions, the proposal anticipates updating item details through separate API requests for each item. This approach is acknowledged as a workaround due to API limitations.
- Only active items within NetSuite are considered for the Inventory sync process, excluding inactive items from the synchronization.
- The proposal assumes the utilization of the “Listings Items” SP-API for updating item details on Amazon.
- The Inventory sync process is set to occur twice daily at precise times: 12:00 PM and 6:00 PM.
- The NetSuite’s available Quantity will be sourced from the Protec/Boulevard location. Additionally, the Item details will be retrieved using the Item Name (itemid) from NetSuite and SKU on Amazon.
- The Product Type will not be stored in NetSuite; instead, it will be retrieved from Amazon Seller Central using Catalog Item search functions for each execution.
Risks
- Potential integration issues, particularly those related to API compatibility, may result in delays or failures in the Inventory Sync. Any unforeseen problems in the interaction between the proposed solution and Amazon Seller Central could impact the synchronization process.
- Changes or updates to the SP-API may affect the Inventory Sync process. Monitoring and adapting to any alterations in the SP-API are crucial to maintaining the reliability of the synchronization.
- There is a potential risk if there are API request limits imposed by Amazon, as this could affect the Inventory Sync process. Understanding and managing these limits will be crucial for the seamless execution of the synchronization process.
- The execution time of the scheduled run may vary depending on the number of items considered in an execution.