Tips for Matrix Items 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, see Editing Matrix Items.

• 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.

The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.

General Notices