General CSV Field Mapping Tips
-
If your account is using NetSuite OneWorld, the Subsidiary field is a required field for the following record types: Chart of Accounts, Contacts, Customers, Employees, Jobs (Projects), Leads, Partners, Prospects, and Vendors. For imports of these record types, you must map the Subsidiary field to a field in your CSV file. If the import attempts to add or update records in a OneWorld account without identifying the subsidiary, the import will fail.
-
NetSuite fields shown in the right pane of the Field Mapping page are dependent upon the fields available on the user's preferred form for that record type. If the user's preferred form does not allow access to certain NetSuite fields, those fields will not display or be available to map.
If a custom form is in use for data entry in the NetSuite user interface, you can specify this custom form as an advanced option on the Import Options page, to ensure appropriate fields are available for mapping. By default, the standard form is used. For more information, see Set Advanced CSV Import Options.
-
You can map a single CSV source field into multiple fields within the same NetSuite record or sublist.
-
Be aware that if you do not map any fields for a sublist, no sublist data is imported, even if you set a default value for one or more sublist fields on the Field Mapping page. For more information about sublist data and the Import Assistant, see Sublist Data Import.
-
If you want to create your own CSV import template files with columns that map to NetSuite data automatically, review the SOAP Schema Browser for details about fields for each record type. For information about working with this tool, see the help topic SOAP Schema Browser.