Importing Kit/Package Item record via CSV Import

Scenario: To be able to import Kit/Package Item records.

Solution
This can be done by using two files during the upload: one is for Primary, the other is for Item Members. Below are the steps:

Note: Values are included on this article to serve as examples. Replace these accordingly when creating the import files.

1. Create an import file for Primary with the following column headers and values:

External ID | Item Name/Number

Kit001 | Kit Item 1

2. Create an import file for Item Members with the following column headers and values:

External ID | Item Member Name | Quantity

Kit001 | Kit Member A | 1

Kit001 | Kit Member B | 1

Kit001 | Kit Member C | 1

3. Import the items into NetSuite:
4. Navigate to Setup > Import/Export > Import CSV Records
5. On Scan & Upload CSV File step, set the following: Import Type = Items Record Type = Kit/Package Item
6. Select MULTIPLE FILES TO UPLOAD
7. For ‘Primary File – Item’, click Select… then choose the file created in #1
8. For Linked File (Optional) – Item Members’, click Select… then choose the file created in #2
9. Click Next
10. On Import Options step, set Data Handling = Add
11. Expand Advanced Options and choose the Custom Form accordingly
12. Click Next
13. On File Mapping step, set the following: Primary File Key Column = External ID Item Members (Linked File) > Column = External ID
14. Click Next
15. On Field Mapping step, map the fields accordingly: External ID > Item : ExternalId Item Name/Number > Item : Item Name/Number (Req) Item Member Name > Item Members : Item (Req) Quantity > Item Members : Quantity
16. Click Next
17. On Save mapping & Start Import step, enter an Import Name (in case you need to use this in the future)
18. Click Save & Run