Choose Data Handling for Import

On the Import Options page, select a Data Handling option to show how your import will affect NetSuite data:

Add — Select this if all records in your file are new to NetSuite.
Update — Select this if all records in your file already exist in NetSuite, and you want to update them.
Add or Update — Select this if your import has a mix of new and existing records.

Note:

See Required Permissions for CSV Imports to get an understanding of the permission level a user must have for a record type to add or update records of that type through CSV import.

Keep these things in mind when updating NetSuite data with CSV imports:

The reference type you pick in the Field Mapping step decides how your CSV records are mapped to existing NetSuite records. You can use external ID, internal ID, or name. Using names can cause errors more frequently, because of matching failures. For more info, see Select Reference Types.
By default, NetSuite won’t clear out fields if your CSV leaves them blank. You can change this by enabling the Overwrite Missing Fields advanced option. For more info, see Overwrite Missing Fields.
Imports always populate dependent field values automatically when related field values are set, in the same manner that dependent field values are populated in the user interface. For updates, make sure your CSV includes all the necessary values so you don’t accidentally change something to a default.
How sublist data gets updated depends on the Overwrite Sublists option and whether the sublists are keyed. You can set Overwrite Sublists as an advanced option for a job or as a general preference at Setup > Import/Export > CSV Import Preferences.

If Overwrite Sublists is enabled, CSV file sublist rows completely replace existing sublist data. If the Overwrite Sublists option is disabled, for keyed sublists, CSV file sublist rows selectively update existing sublist data, and for other sublists, CSV file rows are added to the existing sublist.

For more information about the option, see Overwrite Sublists. To review which sublists are keyed, see Supported Sublist Imports.
You can’t currently fully delete sublist data. You can only overwrite it with new CSV data, not remove it by leaving blank rows.

Related Topics