<img src="https://ws.zoominfo.com/pixel/5BFMW73xT6Cu70sN1cUt" width="1" height="1" style="display: none;">

CSV Import of Kit/Package Item record

Posted by Kevin Suh, NetSuite Administrator on Oct 8, 2024 12:12:04 PM
Kevin Suh, NetSuite Administrator

CSV Import of Kit Package Item record

Item records allow you to track and manage the goods and services your company buys and sells in the course of doing business. 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

 

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

 

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

If you want to learn more about the CSV import of Kit/Package item record, please contact Concentrus today to discuss your needs.

 

 

 

 

 

 


About Us

Concentrus is a leading provider of innovative cloud-based enterprise resource planning (ERP) solutions, including NetSuite. Our team of NetSuite experts offers a range of services, including NetSuite price analysis, NetSuite training, and NetSuite integration services.  

Our goal is to help businesses of all sizes maximize their investment in NetSuite by providing expert NetSuite cost optimization and implementation strategies. With years of experience as a NetSuite partner, our NetSuite administrators and NetSuite consultants are well equipped to help businesses of all sizes with their NetSuite consulting needs.  

Whether you're looking for a NetSuite consultant to help with your NetSuite implementation or you need ongoing NetSuite support, Concentrus is here to help. 

 

Read About Our Implementation Methodology

 

Want more NetSuite Tips and Tricks? Check out our Short & 'Suite videos

 

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, Inventory Management, NetSuite Tips, CSV Import

Subscribe to our blog!

Recent Posts

Posts by Topic

see all

Request a quote