Commerce Category Import
The commerce category import lets you add or update the following information for commerce categories:
-
Commerce Categories
-
Customer segment assignments
-
Subcategories
-
Category item assignments
-
Category tags
-
Category translations
Commerce categories are used to create a hierarchical structure of items in your web store. The fields supported for commerce category CSV import reflect those on the Commerce Category Record at Commerce > Content Management > Catalog & Categories > Commerce Categories. After the import, the categories and items are displayed on your site and are available for management through Site Management Tools and also through the Commerce Category record in NetSuite.
You can use the fields referenced here to create CSV files for import. You can manually create the CSV files or export them from another system, including SiteBuilder Categories.
The import includes categories and related sublists. These include:
See Commerce Categories for more information about categories, subcategories, and item assignments.
External ID Best Practice
Each CSV file includes an External ID column. Use the external ID in your CSV files to link the rows in one file to the relevant row in another file. You should also use the external ID for columns that reference a subcategory. Even though you can use the category names in these columns, category names are not necessarily unique and it is best practice to use the External ID instead.
Any category created with Site Management Tools or through the NetSuite UI are not assigned an external ID in the CSV file. After the export, you must manually enter an external ID for each record.
Updating Items in Commerce Categories
There are multiple ways to update the items or item sequence numbers in your commerce categories. Using a CSV import is normally the most efficient way to update your commerce categories. When using a CSV to update your items or item sequence numbers it is possible to overwrite existing data depending on the options used for the import.
To update items in Commerce Categories
-
Create a saved search of your existing commerce category items. For more information, see Saved Searches.
-
Export the saved search as a CSV.
-
Update the CSV file with the new items and edit the list sequence numbers as needed.
-
Create a new CSV import.
-
Use the Import Assistant to import your updated CSV file. For more information, see Importing CSV Files with the Import Assistant.
Commerce Category
The following table identifies the fields for Commerce Category record. Fields flagged with an * are required. Use the external ID to link the records in the primary CSV file to records in the subcategory and item sublist files.
|
Addition to Head |
JavaScript, HTML, or other code to include in the |
|
Catalog* |
Catalog to which the category is assigned. Specify the catalog name. |
|
Description |
Description of the category. |
|
Display in Website |
T if the category should display in the website or F if it should not display. |
|
External ID* |
The external ID is a required value. This serves as a unique ID key for the record. This can be user defined for a manually generated CSV import file. It can also be the unique key for the record when the data originated as an export from another system. This ID is used to establish the relationship between the CSV import files for subcategories and items. |
|
Heading |
The heading to display on the commerce category page. |
|
Inactive |
T if the category is Inactive or F if the category is active. |
|
Meta Description |
The description to populate the meta description HTML element for the page. |
|
Meta Keywords |
The keywords to populate the meta keywords HTML element for the page. |
|
Name* |
Name of the category. |
|
Page Banner |
Image file in the File Cabinet to use as the banner image for the category page. Specify the file name. |
|
Page Title |
The title of the page. This populates the HTMl |
|
Primary Parent |
The primary parent for this category. If the category has no parent, omit this value. If you specify a primary parent, that parent category must already exist or precede the record in the CSV file. |
|
Sequence Number |
Sequence number for the category. This is used for ordering the sequence of categories in SMT. |
|
Sitemap Priority |
Value between 0.0 and 1.0 used for ranking the importance of pages on the site. If you leave this empty the priority is set to 0.5. The value you enter here populates the |
|
Thumbnail Image |
The image file in the File Cabinet to use as the thumbnail image for this category. Specify the file name. |
|
URL Fragment* |
The URL fragment to use for accessing the category page. |
Subcategory assignments with no category attribute overrides can be created with the primary commerce category CSV file by specifying a value in the primary parent field. The following table is a sample of a CSV file that creates a root level category and multiple levels of subcategories.
|
External ID |
Name |
Catalog |
URL Fragment |
Primary Parent |
... |
|---|---|---|---|---|---|
|
10 |
Men’s |
default |
mens |
— |
... |
|
11 |
Men’s Shirts |
default |
mensshirts |
Men’s |
... |
|
12 |
Men’s Short Sleeve Shirts |
default |
mensshirts-ss |
Men’s Shirts |
... |
|
13 |
Men’s Long Sleeve Shirts |
default |
mensshirts-ls |
Men’s Shirts |
... |
This import results in a root level category of Men’s with a subcategory of Men’s Shirts. The Men’s Shirts subcategory has two subcategories, Men’s Short Sleeve Shirts and Men’s Long Sleeve Shirts.
To create subcategories with override attributes, use the subcategory CSV import file.
Commerce Category Subcategory Sublist
The commerce subcategory CSV import lets you add or update subcategories and override values for those categories. The following table identifies the fields for creating override values for subcategories. Use the External ID field in this file to link to the primary commerce category CSV file.
|
Addition to <Head> Override |
JavaScript, HTML, or other code to include in the |
|
Description Override |
Description of the category. |
|
Display in Web Site Override |
T if the category should display in the website or F if it should not display. |
|
External ID |
Key column to link to records in Primary CSV file. |
|
Heading Override |
The heading to display on the commerce category page. |
|
Meta Description Override |
The description to populate the meta description HTML element for the page. |
|
Meta Keywords Override |
The keywords to populate the meta keywords HTML element for the page. |
|
Name Override |
Name of the category. |
|
Page Banner Override |
Image file in the File Cabinet to use as the banner image for the category page. Specify the file name. |
|
Sitemap Priority Override |
Value between 0.0 and 1.0 used for ranking the importance of pages on the site. If you leave this empty the priority is set to 0.5. The value you enter here populates the |
|
Subcategory |
Name of the category. |
|
Thumbnail Image Override |
The image file in the File Cabinet to use as the thumbnail image for this category. Specify the file name. |
|
Title Override |
The title of the page. This populates the HTMl |
|
URL Fragment Override |
The URL fragment to use for accessing the category page. |
The following table is a sample CSV file that sets override values for subcategories. The examples used here continue the sample primary category CSV file example.
|
External ID |
Subcategory |
Name Override |
Title Override |
... |
|---|---|---|---|---|
|
11 |
Men’s Shirts |
Shirts |
Shirts |
... |
|
12 |
Men’s Short Sleeve Shirts |
Short Sleeve |
Short Sleeve |
... |
|
13 |
Men’s Long Sleeve Shirts |
Long Sleeve |
Long Sleeve |
... |
Commerce Category Items Sublist
The following table identifies the fields for assigning items to Commerce Categories. Use the External ID field in this file to link to the primary category and subcategory files.
|
External ID |
External ID of the category to which this item should be assigned. |
|
Items |
The item name. |
|
Primary Category |
T if the category is the primary category for the item or F if it is not the primary category. |
Commerce Categories Tags Sublist
When you include tags in the CSV import for Commerce Categories, the CSV file must have a separate tag column for each tag. For example, if each record in the CSV file contains only one tag for each category, then you need only one tag column, but if one or more categories has multiple tags, then the file must include multiple tag columns. In the following sample CSV file you see four separate tag columns. Some records have multiple tags, with four tags being the most, and other records have only one tag
|
Name |
... |
Tag1 |
Tag2 |
Tag3 |
Tag4 |
|
Men’s Pants |
... |
Men’s Trousers |
Men’s Slacks |
— |
— |
|
School Supplies |
... |
Back To School Sale |
Teachers |
Kids |
Office |
|
Backpacks |
... |
Satchel |
— |
— |
— |
By default, the NetSuite Fields mapping for Commerce Categories Tags includes only one column. You can add more tag columns to the import by clicking the Add New tag button. The following example illustrates four tag columns to accommodate four tag columns in the CSV file:
You can then map each tag column in the CSV file to a Commerce Category Tags column in the import.
Commerce Category Translation Sublist
Commerce categories supports the translation locale’s supported by NetSuite. The following table lists the fields required for importing commerce category translations by CSV. Enter the values in the language specified by the value you enter in the Locale field.
|
External ID |
The external ID for the category for these translation values. |
|
Addition To |
JavaScript, HTML, or other code to include in the <head> area of the commerce category page when it is rendered on the site. |
|
Description |
Description of the category. |
|
Heading |
The heading to display on the commerce category page for the specified language. |
|
Locale |
Specify the locale code for this translation subsublist. See Locale Code Reference for valid codes. |
|
Name |
The name of the category. |
|
Page Banner |
Image file in the File Cabinet to use as the banner image for the category page. Specify the file name. |
|
Page Title |
The title of the page. This populates the HTML <title> element. |
|
Thumbnail Image |
The image file in the File Cabinet to use as the thumbnail image for this category. Specify the file name. |
By default, the field mapping for translations includes column sets for only one language. You can click the +button to add another set of columns for additional languages. Your CSV file must include the translation values for different languages in different column sets. To help organize the import, consider prefixing the column names with the locale code as in the following example:
-
es_ES_External-ID
-
es_ES_Addition-To
-
es-ES_Description
-
es_ES_Heading
-
es_ES_Locale
-
es_ES_Name
-
es_ES_Page-Banner
-
es_ES_Page-Title
-
es_ES_Thumbnail-Image
-
fr_FR_External-ID
-
fr_FR_Addition-To
-
fr_FR_Description
-
fr_FR_Heading
-
fr_FR_Locale
-
fr_FR_Name
-
fr_FR_Page-Banner
-
fr_FR_Page-Title
-
es_ES_Thumbnail-Image
Locale Code Reference
When you import translations for commerce category you must specify the locale Code for the translation.
|
Locale Code |
Language |
|
af_ZA |
Afrikaans |
|
sq_AL |
Albanian |
|
ar |
Arabic |
|
hy_AM |
Armenian |
|
ms_MY |
Bahasa Malai |
|
bn_BD |
Bengali |
|
bs_BA |
Bosnian |
|
bg_BG |
Bulgarian |
|
zh_CN |
Chinese (Simplified) |
|
zh_TW |
Chinese (Traditional) |
|
hr_HR |
Croatian |
|
cs_CZ |
Czech |
|
da_DK |
Danish |
|
nl_NL |
Dutch |
|
en_AU |
English (AU) |
|
en_CA |
English (CA) |
|
en |
English (International) |
|
en_GB |
English (UK) |
|
et_EE |
Estonian |
|
tl_PH |
Filipino |
|
fi_FI |
Finnish |
|
fr_CA |
French (Canada) |
|
fr_FR |
French (France) |
|
de_DE |
German |
|
el_GR |
Greek |
|
gu_IN |
Gujarati |
|
he_IL |
Hebrew |
|
hi_IN |
Hindi |
|
hu_HU |
Hungarian |
|
is_IS |
Icelandic |
|
id_ID |
Indonesian |
|
it_IT |
Italian |
|
ja_JP |
Japanese |
|
kn_IN |
Kannada |
|
ko_KR |
Korean |
|
es_AR |
Latin American Spanish |
|
lv_LV |
Latvian |
|
lt_LT |
Lithuanian |
|
lb_LU |
Luxembourgish |
|
mr_IN |
Marathi |
|
no_NO |
Norwegian |
|
fa_IR |
Persian (Iran) |
|
pl_PL |
Polish |
|
pt_BR |
Portuguese (Brazil) |
|
pt_PT |
Portuguese (Portugal) |
|
pa_IN |
Punjabi |
|
ro_RO |
Romanian |
|
ru_RU |
Russian |
|
sh_RS |
Serbian (Cyrillic) |
|
sr_RS |
Serbian (Latin) |
|
sk_SK |
Slovak |
|
sl_SI |
Slovenian |
|
es_ES |
Spanish |
|
sv_SE |
Swedish |
|
ta_IN |
Tamil |
|
te_IN |
Telugu |
|
th_TH |
Thai |
|
tr_TR |
Turkish |
|
uk_UA |
Ukrainian |
|
vi_VN |
Vietnamese |