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:
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.
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:
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. |
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
- Items Import
- Item Record Types that Can Be Imported
- Notes about Items Imports
- Selecting General Ledger Accounts for Item Imports
- Importing Demand Planning Data for Items
- Importing Related Items Groups
- Importing Matrix Options for Items
- Importing Pricing Data for Items
- Replacing the Bill of Materials Sublist with the CSV File