The site category import lets you add or update website categories in NetSuite. These categories are used to organize information and items for sale on your website. Each category must be associated with a presentation tab to be displayed in a website. Presentation tabs are the building blocks, or pages, in a website.
Supported fields for this import mostly match the fields on the Site Category page available at Commerce > Site Builder > Content Management > Categories > New, including the following:
- Category – name of the site category (required)
- Site – the site where the category should be used (required when the Multiple Sites feature is enabled)
- Subcategory of – the tab or category where this category is grouped
- Display in Web Site – Boolean indicating whether the category should be displayed
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.
Supported Site Category Sublist Data Import
The site category import supports the import of information and items to be included in each category, as Presentation Items sublist data. The records in this sublist can be File Cabinet items, information items, actual items to be sold on the website, or subcategories.
Importing Updates to Site Category Records
If you need to import updates to existing site category records, NetSuite recommends that you use an identifier of internal ID or external ID to prevent duplication of records.
- If you select the Update data handling option, you can use Category as an identifier to match records and perform updates.
- If you select the Add or Update data handling options, no Category lookups are performed, so in the absence of internal ID or external ID, multiple records with the same category name may be added.