Hey all, Sorry if this is a repeat, looked and couldn't find an answer. Can you append values to a multi-select field on import? I need to add "W22" to a list of items Those items have a variety of other values that I'd like to preserve (e.g. W19,W20, or W20,S20)

Please clarify: are you wanting to add W22 as an available value on the Sublist values? Or is it W22 on a Customer?

I don't think so. Maybe an export/import combo?

Overwrite Sublists

is not in reference to multi-select fields but rather like the

Items

on Invoices,

Addresses

on Vendors, etc. where you have many to one relationships (or sometimes many to many)

W22 is a value for a matrixed item/product. It's already available at the parent level, but it needs to be appended for a subset of child-items @Merik Ducker, Thanks for the info about Overwrite Sublists -- that makes sense. I was hoping to have to do an export of all the existing records in NS, since I'd have to run a search for each ID as a list. For a little more clarity: W22 is our 'sales season' indicator -- so "winter 22" is the defining value to show that something is on sale during that period. So, the business decides which products we will continue to sell in w22, and that decision needs to be reflected in the system. This multi-value field is what controls that. So, I could export ALL items from netsuite, clean it up in an excel file, and re-import with the full 'Sales Season' values, but that's a bear.

If it's a recurring thing then it might be a worthwhile customization. Could have another custom field of the same list but single-select. Then the customization could take values added to that one and append it to the multi-select

Try a CSV import test onto a single item. It might just do what you want. Maybe a Mass Update might also do it