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.
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.
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.
VNMT 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:
- Update the customer records in bulk.
- To remove the duplicate entries in customer records.