SuiteScript is a NetSuite platform to automate and customize the business operations, ensuring portability and developer productivity. Organisations may encounter situations where they need to mass update or delete records, and here is when the need for Scheduled SuiteScripts emerges. They are used for processing large, complex business operations against a set of data on a scheduled basis.
One of our client approached VNMT, with a requirement to update 9000 custom site records under several departments with particular site details efficiently .
Our client wanted to update certain site details to large number of custom records, which were categorized under several departments. There were almost 9000 records, so going through each record every time and updating the particular records with the specific information was out of the question.
So only option left was creating scripts. But how to simultaneously update large number of records and how to identify the particular custom site records under a specific category to manipulate the data in that record were the main challenges we faced during our requirement analysis.
With our expert SuiteScript development team, we developed Scheduled scripts set against a set of parameters to retrieve each custom records under particular departments on a scheduled basis. We scheduled mass updates as there are 9000 records, which needed updating.
Using Mass Update, we identified the multiple records which needs updation and updated the particular field value that are outdated in respective records.
With the help of NetSuite SuiteScript, our team created an efficient Scheduled Mass Update Script to update 9000 custom site records simultaneously with the specific site informations that the client wanted. The main tasks we accomplished are listed below.
Created Scheduled Mass Update Scripts on a scheduled basis
- To retrieve the custom site records under certain departments efficiently.
- To update the custom site records simultaneously with the particular site details.