Related items groups are defined for items in Web stores to cross-sell items that complement each other. The Import Assistant supports the import of related item sublist data for item records when the Web Site feature is enabled.
On the Import Assistant Field Mapping page, you must map two fields for the Related Items sublist: Item and Type.
The Item field represents the item name that appears in the browser, whereas the Type field indicates the NetSuite type of relation, for example File Cabinet Item, Information Item, Item, Presentation Category Item.
To see available values for the Type field, create a new item in the browser, go to the Related Items subtab, and click the List button for the Item field. The top of the popup displays a dropdown list of available values for the Type field.
You can include Type values in your CSV files and select a default value for Type on the Field Mapping page by clicking the edit icon.
In the Default Value popup, select a default Type value (File Cabinet Item, Information Item, Item, or Presentation Category) from the dropdown list next to the Provide Default Value option.
Note the following:
For an import job that includes large numbers of related item records, you should upload multiple CSV files.
Import of related items is not supported for Non-Inventory Item for Purchase, Service Item for Purchase, or any Other Charge Item imports.
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.
- Items Import
- Item Record Types that Can Be Imported
- Item Sublists Available for Import
- Notes about Items Imports
- Selecting General Ledger Accounts for Item Imports
- Importing Demand Planning Data for Items
- Importing Matrix Options for Items
- Importing Pricing Data for Items
- Replacing the Bill of Materials Sublist with the CSV File