Required Fields on Records

Some NetSuite fields are required, meaning you must specify a value for them or the import cannot proceed. You can map these required fields to CSV column headers, or provide default values for them on the Import Assistant's Field Mapping page.

NetSuite required fields are shown in the NetSuite Fields column with (Req) after the field name. Usually, NetSuite required fields are shown automatically in the mapping column, to alert you that they must be mapped. However, required fields that do not show, meaning they are rolled up in the tree node in the right column, must be clicked on and mapped. Note that required fields for sublists are handled somewhat differently; for information see Required Fields for Sublist Import Mapping.

Mapping a Required Field

  1. On the Field Mapping page of the Import Assistant, click the required NetSuite field on the right if it is not already showing in the mapping column.

  2. Click the appropriate field name from your CSV file on the left to add it to the mapping section next to the NetSuite required field.

Providing a Default Value for a Required Field

  1. Click the edit icon next to your field.

  2. Provide a default value for this field.

    For more information, see Assign Default Values during Field Mapping.

Be aware that even if you set a default value for one or more fields in a sublist, no sublist data is imported unless you map at least one field for that sublist. For more information about working with sublists, see Sublist Data Import.


If Marketing Automation is enabled and you choose the “Add” data handling option on the Import Assistant's Import Options page, you will be required to map the Unsubscribe field on the Field Mapping page, even if this field is not displayed on your preferred form for the record type. If the Unsubscribe field has not been mapped to a value, an error is thrown and you must go back and rectify the error.

Related Topics

Step Four Field Mapping
CSV Field Mapping Tasks
General CSV Field Mapping Tips
Select Reference Types
Assign Default Values during Field Mapping
Assign Null Values during Field Mapping

General Notices