ADD – Select if all imported records are new to NetSuite.
UPDATE – Select if all imported records already exist in NetSuite, and the import is intended to modify these records.
ADD OR UPDATE – Select if imported records are a mixture of new and existing records.
Under Advanced Options:
- If Validate Mandatory Custom Fields checkbox is checked, should give data for mandatory custom fields.
- If Validate Mandatory Custom Fields checkbox is Unchecked, should not give data for mandatory custom fields.
- Log System Notes For Custom Fields check box is checked, Enable this option to create system notes during import of custom field data. Impacts performance; recommended only when custom fields require an audit trail.
- Overwrite Missing Fields enable this option to clear NetSuite fields mapped to CSV file fields that do not contain data.
- Custom Multi-Select Value Delimiter This option we are using for Multi-Select fields using pipe symbol (|).
- Custom Form should select which form you are importing the data.
- Overwrite subsists – This option can be used to update the entire sublist data
- Run Server SuiteScript and Trigger Workflows: This option allows you to automatically run any workflows or server-side SuiteScripts on the transaction at the time of upload. It should be noted that running server SuiteScript will slow the import process.