Powered by
Arif W-Browne
  • Home
  • About
  • Integrations
    • EShop-Venda Integration
    • EShop-ChannelAdvisor Integration
    • SuiteTalk Integration
    • EShop-Magento Integration
    • SFTP-NetSuite Integration
  • NetSuite
    • eCommerce >
      • Order Exchanges
      • Gift Messaging
      • Real-time Search Engine
    • CRM >
      • CRM Report: Average Response Time
      • Case Incident Portal
    • Hacks & Tricks >
      • Permission Bypassing
      • Event Handling
      • Pop-up Windows
      • Saving Money on Licences
      • EXT-JS Library
    • Order to Cash >
      • CSV Requisition Import
    • NetSuite Re-implementation
    • System Audit
    • Migration Announcements
  • Contact me

 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.
​
Picture

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.
Picture
  • Home
  • About
  • Integrations
    • EShop-Venda Integration
    • EShop-ChannelAdvisor Integration
    • SuiteTalk Integration
    • EShop-Magento Integration
    • SFTP-NetSuite Integration
  • NetSuite
    • eCommerce >
      • Order Exchanges
      • Gift Messaging
      • Real-time Search Engine
    • CRM >
      • CRM Report: Average Response Time
      • Case Incident Portal
    • Hacks & Tricks >
      • Permission Bypassing
      • Event Handling
      • Pop-up Windows
      • Saving Money on Licences
      • EXT-JS Library
    • Order to Cash >
      • CSV Requisition Import
    • NetSuite Re-implementation
    • System Audit
    • Migration Announcements
  • Contact me
Powered by Create your own unique website with customizable templates.