How can use the Import Assistant to update existing NetSuite records?
WebWorks_WriteArrow(WebWorksRootPath, “wwdd1033886”, true); WebWorks_WriteDIVOpen(“wwdd1033886”, true); To update records with the Import Assistant, select either the Update or the Add or Update data handling option on the Import Options page. See Step 2 Import Options. Your CSV file should include data for a primary key field that can be used to match CSV file records with existing NetSuite records and correctly update them. For best results, use the Internal ID field as the primary key, include a column of NetSuite internal ID values in your CSV file, and map this column to the Internal ID field. You can obtain internal ID values by creating a saved search of the record type in NetSuite that includes Internal ID as a results column and exporting saved search results to a CSV file. For instructions on how to do this for transactions, see Creating Transaction Saved Searches for Reimport. If internal ID values are not available, use the External ID field as the primary key, include a co
