Scheduled Scripts and Mass Update

Home / / Scheduled Scripts and Mass Update

SuiteScript is a NetSuite platform to automate and customize the business operations, ensuring portability and developer productivity. Our client wanted us to use the same capability of the NetSuite cloud ERP to update large number of custom records in site details. 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. Read this case study to understand how suitescript helped our client to update many custom records in site details.

Requirement

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 Jobin&Jismi, with a requirement to update 9000 custom site records under several departments with particular site details efficiently .

Challenges

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.

Our Solution

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.

Results

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

1. To retrieve the custom site records under certain departments efficiently.
2. To update the custom site records simultaneously with the particular site details.