Customer Data Updation (Mass update script)

Home / / Customer Data Updation (Mass update script)

There may arise situations where you may want to mass delete or update customer records. Exactly that was what one of our NetSuite client wanted to achieve. When there are large number of customer records it is impossible to update or delete particular customer records, as we want to go through each customer records one by one to delete or update that specific record. Our experts finally decided to use script to mass update and clean the data. Here is how they have achieved it.

Requirement

There may arise situations where you may want to mass delete or update customer records. When there are large number of customer records it is impossible to update or delete particular customer records, as we want to go through each customer records one by one to delete or update that specific record.

One of the client approached us with a requirement to update the customer records in their NetSuite, which contain almost 9000 records and also to remove duplicate entries from the records if there are any.

Challenges

To update the customer records, there are two options, either update the record manually or by using script. As our approached client’s NetSuite account has more than 9000 records, hence manual update was out of question. Then the only option left was using script.

But how we can update the records in bulk, each time when  there are updates? and that was the major challenge we have faced.

Our Solutions

With our expert NetSuite team we developed a mass update script to update the customer records in bulk and to remove the duplicate entries also.

So the deployed script set against a set of parameters when run, will check for the update and will update the customer records with the new data. The script is executed in a way to remove duplicate entries from customer records also.

 

Results

Jobin&Jismi created an efficient Mass update script to remove duplicate entries and to update customer records. The main highlights of our solution were:

Created a highly efficient Mass update script that can be customized for any clients and business verticals. The mass update script is able to:

1. Update the customer records in bulk.
2. To remove the duplicate entries in customer records.