Automated File-Based Inventory Stock Update in NetSuite

img

Client Portfolio

Our client, based in New York, is one of the top ranked, authorized online retailer for industry tools. They stock up on items such as electrical and lighting, metal fabrication, oilfield equipment, automotive maintenance, hoisting and rigging, and more. They deal with items manufactured by more than 300 companies. Their customer based includes government agencies, universities, Fortune 500 companies weekend warriors and end users. Their product line encompasses various categories such as electrical and lighting, metal fabrication, oilfield equipment, automotive maintenance, hoisting and rigging, and more.

Problem Statement

Based on the daily transactions that happen on the website, our client required to have the inventory on NetSuite updated. Before approaching us, they were manually updating the details. This was prone to manual error and effort. 

What We Suggested

To automate the stock update process for our client’s active items in NetSuite, our experts analyzed the requirement in detail. After evaluating the existing systems and processes, they devised a solution to automate the stock update process based on the data provided in a file. This file contains the information required to update the inventory levels of the active items, such as the item ID and the new stock quantity. 

The automation process is designed to run daily at the time specified by the client. This meant  the inventory levels on the website are updated regularly without any manual intervention. The automation process also includes error handling and validation checks to ensure that the inventory levels are updated accurately and without any issues. 

To keep the client informed about the status of the automation process, an email is sent to the specified user in case of any issues that arise during the stock update process. This allows the client to take prompt action and ensure that the inventory levels on the website and NetSuite are almost real time.  

Customer Success

The Automation of inventory stock update enabled the business to save time and extra effort to update the stock quantity manually. By this automation they enjoyed more benefits that includes: 

Previously, they needed to update the stock of inventory items manually and was a complicated process. Now, they only need to check whether the file is available in the mentioned location for the stock update. 

Since the stock update are from different vendors and by different file transfer, it was hard to process them simultaneously. After the integration, multiple files from different vendors are processed as scheduled. 

Through email plugin, the file received are automatically transferred to desired folder and replaces the old files. 

Since, there is a backup folder to store the processed files, user can check the information regarding the stock update at any time. 

The client was able to save on man hours and an error free process.