I am having terrible trouble trying to import Kit/Package Items. I'm sure my data structure is correct and have tried every way and mapping except of course the correct one. Can someone assist and maybe add some clarity to the import procedures and mappings so that I can complete and possibly assist someone else for the future? All the NetSuite posts and documentation go into very little detail and most of the material online is just copied and pasted (cos that is helpful)..
- I have confirmed that my member Inventory Items exist in NetSuite, so that they can be mapped to a new parent Item on the import.
- As you would expect I have a Parent File (Parent Items.csv) and a Member File (Member Items.csv).
- In the Parent File I have and [External ID] (SKU) and [Item Name/Number] (Title) column for the products along with Four (4) rows which I need to create.
- In the Members file Five columns; [Internal ID], [External ID], [Member Name/Number] and [Member Quantity].
- From the Setup menu, I choose Import/Export and New to start the Import Assistant, Selecting 'Items and Kit/Package Item' and my two files
- In the file mapping I select the [External ID] column from each of the respective files
- Then before submitting on the Field Mapping Screen I map the fields as follows;
But the process fails with the error "Invalid item reference key"
If you could help it would be greatly appreciated. I have spent two days on this now, I could have typed them in manually faster!!!
Thank you,
Stuart