Reference Existing Records

When importing a file into NetSuite QuickStart Edition, you may need to reference existing records to ensure accurate data mapping and seamless integration. This is essential in two key scenarios:  

• Updating an existing record 
• Linking a new record to an existing one (e.g., importing a new contact and associating it with an existing company) 

To accurately reference an existing record, you must use a unique identifier. NetSuite QuickStart Edition allows referencing by: 

• Name – Default option in CSV templates, provided the name is unique. 
• Internal ID – A system-generated identifier. 
• External ID – A custom identifier assigned to the record. 

By default, NetSuite QuickStart Edition references records by name. For example, in a purchase order import, the item field appears as