CSV Import > Items > Adding Related Items data to an Item record generates the CSV response error: Invalid item reference key xx.

CSV Import > Items > Adding Related Items data to an Item record generates the CSV response error: Invalid item reference key xx.

 

The Import Assistant supports the import of related item sublist data for item records when the Web Site feature is enabled. Related Items data are mapped to the NetSuite field Presentation Items 1 : Item (Req)and users has the option to choose the following reference types:

1. Names (Item Name/Number or Web Store Display Name*).
2. Internal ID.

The error is received when a user chooses Names as the reference type and listed below are the reasons:

1. The Item Name/Number was incorrectly used (misspelled, incorrect Item Name/Number etc).
2. The Internal ID was used.
3. The Item Name/Number is correctly used but there is a value set on the Web Store Display Name of the related item record. The Web Store Display Name should be used instead of the Item Name/Number.