CSV import data handling “add or update” can internal id be used for updates and blank for additions

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** Yes, you can use the "add or update" option in CSV import data handling in NetSuite. For updating existing records, you can use the internal id as a reference. Every record in NetSuite has an internal id, which is the database key for the object. When you are preparing your CSV file for import, you can include only the internal id and the external id columns for the records you want to update. Map the internal id in your CSV file to the internal id in NetSuite during the import process. For adding new records, you can leave the internal id field blank in your CSV file. NetSuite will automatically assign a new internal id to the new records. Remember to always use data from saved searches to build your CSV update data, as saved searches will provide you with the internal id of the record. This will make your CSV import less error prone. Please note that you should test this process with a few records in a sandbox account before applying it to your live account.