ANS-1235 · CSV IMPORT & DATA MIGRATION
When is an External ID Required for NetSuite CSV Imports?
External IDs are crucial for uniquely identifying records during new transaction CSV imports in NetSuite.
Short answer
External IDs are not universally required in NetSuite. However, for new transaction CSV imports, an External ID is frequently mandated by the import process itself to ensure unique identification of records, rather than being a setting on a custom form.
Scenario
Users performing CSV imports for new transactions, such as Sales Orders, may encounter questions regarding the necessity of providing an External ID. Understanding when and why External IDs are required is essential for successful data migration and record creation in NetSuite.
Solution
External IDs are not universally required for all record types or operations within NetSuite. However, for new transaction CSV imports, an External ID is frequently required as a unique identifier. This requirement stems from the import process itself, which uses the External ID to uniquely identify each record being created, rather than being a setting configurable on a specific custom form. While Internal IDs serve as NetSuite's primary system identifier, External IDs are critical for managing uniqueness during bulk data uploads.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support