Items Import

Item records allow you to track and manage the goods and services your company buys and sells in the course of doing business.

For a list of the types of items that you can add or update with the Import Assistant, see Item Record Types that Can Be Imported.

For a table of item sublist data that can be imported, see Item Sublists Available for Import.

To review issues you may encounter when you import Items data, see Notes about Items Imports and Selecting General Ledger Accounts for Item Imports.

If the Demand Planning feature is enabled in your account, review Importing Demand Planning Data for Items for information about importing related data.

If the Web Site feature is enabled in your account, review Importing Related Items Groups.

If the Warehouse Management feature is enabled, you can import data for the following fields: Rotation Type, Item Process Group, and Item Process Family. For more information about working with these fields, see Creating Items for NetSuite WMS.

For information about using the Import Assistant to set up matrix options for items, see Importing Matrix Options for Items.

For tips about importing price levels for items, see Importing Pricing Data for Items.

For an example of replacing the contents of a sublist with the content from the CSV import, see Replacing the Bill of Materials Sublist with the CSV File.


Because the Quantity on Hand field is not available for entry on NetSuite user interface Item forms, CSV imports can add Quantity on Hand values for new item records being imported, but cannot update Quantity on Hand values for existing NetSuite item records. The Quantity on Hand field should only be available on the Field Mapping page for Adds, but currently may appear for Updates as well. If you map this field for an update, currently no error occurs, but Quantity on Hand field values are not updated.

For details about fields that can be mapped in Item records, refer to the SOAP Schema Browser, which has a reference page for each supported item type. You can use the field definitions here as a basis for creating your own CSV import template file. For information about working with the SOAP Schema Browser, see SOAP Schema Browser.

Additional Information

Importing CSV Files with the Import Assistant
CSV Import Error Messages
Using Item Records

Related Topics

Guidelines for CSV Import Files
Supported Record Types for CSV Import
Tips for Successful CSV Imports

General Notices