ANS-1427 · CSV IMPORT & DATA MIGRATION
How to Update External IDs for Existing Records in NetSuite?
Learn how to modify the External ID of an existing NetSuite record using various methods, including CSV imports, web services, and scripts.
Short answer
To update an existing NetSuite record's External ID, the system requires a unique identifier to locate the record. This can be achieved by providing the record's Internal ID in a CSV import alongside the new External ID. Other methods include web services or user event scripts.
Scenario
When attempting to update an existing record in NetSuite, a mismatch in the provided External ID can prevent the system from identifying the correct record. Consequently, direct updates to the External ID via standard import methods may be disallowed if the initial identifier does not match.
Solution
To successfully update the External ID of an existing record in NetSuite, the system requires a definitive method to identify the target record. While CSV imports are a common approach, External IDs can also be modified using web services or user event scripts.When utilizing a CSV import for this purpose, the import file must contain two essential columns:
The record's Internal ID
The new External IDThis ensures the system can accurately locate the existing record and apply the desired External ID update.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support