For adding matrix item we’ve to follow some steps during mapping in the NetSuite and while creating CSV files.
We’ve add Item Name/ Number column in the NetSuite and if we add this then it’ll be the Matrix item
| External ID | Item Name/Number | SKU | Description | Category | Class | Subsidiary | Department | Location | Price Level (Req) 1 | Price Currency (Req) 1 | Price (Req) 1 | Price Quantity 1 | Price Level (Req)2 | Price Currency (Req)2 | Price (Req)2 | Price Quantity2 | Income Account | Tax Schedule | Asset account | COGS Account | Matrix Type |
You can use CSV file like this in Matrix item for the Parents category and Child category.
For child category import you’ve to add some more columns regarding Color, Size and Packaging in the new column you can import same as in import.
- When you select matrix options for a parent in the NetSuite user interface, child matrix items are created automatically. 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.
- Each child matrix item can have separate pricing data.
- A limit of 2000 child matrix items are permitted for each parent matrix item.
- You can use the Import Assistant to add child matrix items to existing parent matrix items. Use the Subitem of field to store the value of the parent matrix item for each child.
- The following limitations apply to updates of matrix items with the Import Assistant:
- You cannot change matrix option values for existing child matrix items.
- You cannot change the parent matrix item (Subitem of value) for existing child matrix items.
- You cannot change the matrix type value for existing matrix items.
- Unlike in the user interface, matrix items imports cannot update child matrix items as a group in the parent item record. Each child matrix item record must be updated individually.
- Otherwise, the fields that you can update with matrix items imports are the same as those you can update manually in the user interface. For information.
- You cannot use the Import Assistant to delete matrix options.
- In the user interface, child matrix items inherit Units Type field values from parent matrix items. However, items imports set Units Type field values separately on parent and child matrix items. You should map this field for both parent and child items and include values for both in CSV import files. Also note that Stock Units, Purchase Units, and Sale Units values are dependent on Units Type values.
- When you are using a CSV import for populating the facet field values, ensure that the facet field values are the same for the child matrix items. If the facet field values are not the same or they are missing for the child matrix items, the facet filter might not work as expected. This issue is observed only when you use non-matrix options as facet fields.
| External ID | Item Name/Number | Display Name/Code | Color | Size | Matrix Type | Subitem of |
|---|---|---|---|---|---|---|
| 12000 | TestItem | Test Item | — | — | Parent Matrix Item | — |
| 12011 | CottCrewSweat-ES | Cotton Crewneck Sweater | Black | S | Child Matrix Item | TestItem |
| 12012 | CottCrewSweat-EM | Cotton Crewneck Sweater | White | M | Child Matrix Item | TestItem |
| 12021 | CottCrewSweat-RS | Cotton Crewneck Sweater | Red | S | Child Matrix Item | TestItem |
| 12022 | CottCrewSweat-RM | Cotton Crewneck Sweater | Rose | M | Child Matrix Item | TestItem |
| 12031 | CottCrewSweat-SS | Cotton Crewneck Sweater | SkyBlue | S | Child Matrix Item | TestItem |
| 12032 | CottCrewSweat-SM | Cotton Crewneck Sweater | SkyBlue | M | Child Matrix Item | TestItem |