Overwrite Sublist option replaces sublist data as a whole, rather than checking for individual fields mapped to CSV file fields with no data.
• Your setting for the Overwrite Sublists option affects imports of sublist data when one of the following data handling option buttons is selected: Update, Add or Update. By default the option is disabled.
• Overwrite Sublists = True — If you enable the Overwrite Sublists option, the Import Assistant completely replaces all existing sublist values and replaces them with the CSV file sublist data. Be cautious in enabling the option, as all existing sublist values are removed.
• Overwrite Sublists = False — If you do not enable the Overwrite Sublists option, the effect varies according to whether the sublist import supports selective updates based on key field values.
• For keyed sublists, if the Overwrite Sublists option is disabled, the Import Assistant:
• Selectively updates existing sublist data with key field values that match CSV file sublist rows.
Notes —
Complete deletion of sublist data currently is not supported. Existing sublist data can only be overwritten with new CSV file sublist data, not with an absence of CSV file sublist data. For more information, see Replacing the Bill of Materials Sublist with the CSV File.
Enabling the option cancels the effects of the Overwrite Missing Fields option on any sublists with mapped fields, because the result will be a sublist that looks exactly like the CSV file sublist data no matter what was there before.
NetSuite recommends that you do not enable the Overwrite Sublists option for imports that include item pricing data or item demand plan imports. Enabling the option may result in errors when imported sublist data overwrites existing sublist values driven by body field values such as pricing schedule.