Product Stock Search Engine 

​The existing eCommerce solution for one client I worked for comprised of an integration platform which triggered every 15 minutes to transport data from NetSuite to the front-end, 3rd party system and vice-versa. As the business only had one scripting queue, the transportation of data took far longer than 15 minutes to process because other scripts were often still running. Consequently, data between both systems became out of sync and inaccurate.

Solution:
Implement a search engine and real-time stock report which contacts the 3rd party API on-the-fly to retrieve real-time stock figures and take appropriate action for product stock that may be out of sync.

Generate stock report

 When the user clicks the "Generate Stock Comparison Report" button on a custom Suitelet, a scheduled script is executed to first: pick up every item record on NetSuite, second: search the equivalent product on the 3rd party system, then third: print the stock output from both systems in Excel format. Given the huge data load to process, a scheduled script was necessary to take care of any governance unit limitations.
​

Real-time search engine

Via the same Suitelet as the above,  the user could perform a real-time stock search on the front-end system by inputting the applicable product in the "SKU to Search" field. This would automatically search all products which contain the characters inputted, and display the current stock figures for that one product.