ANS-1079 · CSV IMPORT & DATA MIGRATION
How to Erase or Nullify Data Fields During NetSuite CSV Imports?
Understand how to leverage a specific advanced CSV import option in NetSuite to clear existing data values on records.
Short answer
To erase or nullify data in specific fields on existing NetSuite records during a CSV import, utilize the 'Overwrite Missing Fields' checkbox. This advanced option, found within the CSV import settings, allows the import process to clear values for fields that are present in the import mapping but have no corresponding data in the CSV file.
Scenario
NetSuite users performing CSV imports may encounter situations where they need to clear or nullify data in certain fields on existing records, rather than just updating them. This requirement arises when a field's value needs to be removed entirely, effectively resetting it to an empty state through an import process.
Solution
To nullify values on records during a CSV import in NetSuite, locate the advanced options within the import assistant. Enable the checkbox labeled 'Overwrite Missing Fields'. This specific option allows the import process to clear existing data in fields that are mapped but have no corresponding value in the imported CSV file.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support