Site Category Import
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
For details about fields that can be mapped in the site category record, see the SOAP Schema Browser’s site category reference page. 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.
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.
Review the following guidelines for site category imports:
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.
To import values for multiple presentation items per category, format your CSV file with repeating columns for the Presentation Items sublist fields (such as Item1, Type1, Item2, Type2, Item3, Type3), and map multiple instances of this sublist on the Import Assistant Field Mapping page. (Click the + sign next to the sublist to add mappable instances.)
Importing Updates to Site Category Records
If you need to import updates to existing site category records, you should 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.
The site category import does not support the definition of an audience for categories to be published internally to an intranet or to specific set of individuals. If necessary, you can define an audience for a category on its record within NetSuite after the import.