Unexpected error may due to blank/invalid values mapped to Item: Matrix Option field(s) in NetSuite.
To resolve this, check the CSV file if the Mapped column contains the proper matrix option values in NetSuite Interface. Once the CSV file has been corrected, perform the CSV Import again.
Please also note that when adding NEW Matrix items data thru CSV Import, the following should be included in the CSV File:
-
External ID: Recommended for all CSV imports, to serve as a unique identifier for each record.
-
Item Name/Number: Name for each matrix item.
-
Matrix Type: Possible values for this column are Parent Matrix Item, Child Matrix Item.
-
Subitem of: For each child matrix item, this column's value is the name of the parent matrix item. For each parent matrix item, this column is blank.
-
Columns that map to custom lists, such as Color, Size. Values for these columns should match those in the custom lists you set up.