Item Sublists Available for Import

Item sublist data supported for import varies according to the type of item data to be imported, and the related features enabled. The following table indicates these limitations:

Sublist	Notes
Bills of Materials	Available for the following import types: Assembly Item Serialized Assembly Item Lot Numbered Assembly Item Available if the Advanced Bill of Materials feature is enabled at Setup > Company > Setup Tasks > Enable Features (Administrator), on the Items & Inventory subtab.
Bin Numbers	When Bin Management feature or Advanced Bin/Numbered Inventory Management enabled. Selectively updatable based on Bin Number key field. For Assembly/BOM Item and Inventory Item imports. Note: If you are importing bin records, you should complete this import before you import items with associated bin numbers. See Bin Import.
Locations	When Multi-Location Inventory feature enabled. Selectively updatable based on Internal ID, External ID, or Location. (See Updating Locations on Items.) For Assembly/BOM Item and Inventory Item imports.
Members	For Assembly/BOM Item, Item Group, and Kit/Package Item imports.
Merchandise Hierarchy	Available for the following item types: Inventory Item Lot Numbered Inventory Item Serialized Inventory Item Available if the Merchandise Hierarchy feature is enabled at Setup > Company > Setup Tasks > Enable Features, on the Items & Inventory subtab.
Pricing	When any of Multiple Prices, Quantity Pricing, or Multiple Currencies feature enabled. Selectively updatable based on fields of Currency, Quantity, and Level, depending on enabled features (See Keys for Item Pricing Sublist.)
Related Items	When Web Site feature enabled. Not available for Non-Inventory Item for Purchase, Service Item for Purchase, Other Charge Item imports. For more information, see Importing Related Items Groups.
Site Category	When Web Site feature enabled. Not available for Non-Inventory Item for Purchase, Service Item for Purchase, Other Charge Item imports.
Task Templates	When Project Management feature enabled. For Service Item for Sale imports.
Translation	When Multi-Language feature enabled. Selectively updatable based on Language key field.
Vendors	When Multiple Vendors feature enabled. Selectively updatable based on Vendor key field. For Inventory Item, Non-Inventory Item for Resale or Purchase, Service Item for Resale or Purchase, and Other Charge Item for Resale or Purchase imports, and Assembly/BOM Item when Allow Purchase of Assembly Items preference is enabled. Note that if multiple vendors are defined as preferred, the last one listed is the only one marked preferred by the import. See Updating Vendors on Items.

Every sublist on each record can optionally have a separate file. For imports that update existing Item records, handling of sublist data updates depends upon the setting for the Overwrite Sublists advanced option, and on whether the sublist is keyed. Complete deletion of sublist data currently is not supported. For more information, see Sublist Data Import.

The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.

Related Topics