The CSV file containing your matrix items data should include columns that map to the following fields. For best results, set the column headers to match these field names.
- 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.
Your CSV file also can include columns that map to other Item record fields.
Note :- In CSV import, updating parent item values for the Asset Account, Cost of Goods Sold (COGS) account, or Income Account fields does not automatically update child item field values. You need to set these values for each child item row. The system does not enforce that child item values match the parent item values for these fields, so you need to ensure that they match yourself.
| External ID | Item Name/Number | Display Name/Code | Color | Size | Matrix Type | Subitem of |
|---|---|---|---|---|---|---|
| 12000 | CottCrewSweat | Cotton Crewneck Sweater | — | — | Parent Matrix Item | — |
| 12011 | CottCrewSweat-ES | Cotton Crewneck Sweater | Ecru | S | Child Matrix Item | CottCrewSweat |
| 12012 | CottCrewSweat-EM | Cotton Crewneck Sweater | Ecru | M | Child Matrix Item | CottCrewSweat |
The CSV import process is different. Each parent matrix item and each child matrix item must be added or updated individually, and the CSV file should include a separate line for each parent matrix item and child matrix item. Otherwise, the rules for creation of matrix items in the NetSuite user interface generally also apply to matrix items imports.
