Overwrite Sublists

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.
  - Adds CSV file sublist rows with key field values that do not match any values in existing rows as new sublist rows. (These rows represent new sublist key values, such as a new location or a new vendor.)
- For non-keyed sublists, if the Overwrite Sublists option is disabled, the Import Assistant appends all CSV file sublist data as new rows.
- For a list of all sublists supported for CSV import, see Supported Sublist Imports.
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.
- You shouldn't 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.

Related Topics