Solr Product index schema
The complete field mappings for the HCL Commerce Solr product catalog entry index.
Product index schema design
The CatalogEntry core is the primary Solr search index for HCL Commerce catalog entries (products and SKUs). It indexes product records with comprehensive product information including names, descriptions, part numbers, manufacturer details, pricing data, and product hierarchy relationships. This is the primary search index for product discovery and storefront search functionality.
For field type definitions, see Solr index field types. The Options column uses the following indicators: T (tokenized), I (indexed), S (stored), and M (multiValued).
Field reference
| Index Field Name | Index Field Type | Options (T/I/S/M) | Description |
|---|---|---|---|
| catentry_id | string | X / ✓ / ✓ / X | Primary key; unique identifier of the catalog entry. |
| version | long | X / ✓ / ✓ / X | Solr version control. |
| catalog_id | long | X / ✓ / ✓ / X | Parent catalog reference. |
| storeent_id | int | X / ✓ / ✓ / X | Store entity reference. |
| member_id | long | X / ✓ / ✓ / X | Member/seller identifier. |
| productset_id | long | X / ✓ / ✓ / X | Product set or bundle ID. |
| parentCatentry_id | long | X / ✓ / ✓ / X | Parent product/bundle reference. |
| parentVariant_id | long | X / ✓ / ✓ / X | Parent variant reference. |
| childCatentry_id | long | X / ✓ / ✓ / X | Child product IDs. |
| parentCatgroup_id_facet | wc_keywordText | ✓ / ✓ / ✓ / ✓ | Parent category (facet). |
| parentCatgroup_id_path | wc_keywordText | ✓ / ✓ / ✓ / X | Parent category path. |
| parentCatgroup_id_search | wc_keywordText | ✓ / ✓ / ✓ / X | Parent category for search. |
| grouping_parentCatentry_id | long | X / ✓ / ✓ / X | SKU grouping parent. |
| grouping_parentVariant_id | long | X / ✓ / ✓ / X | Variant grouping parent. |
| parentDK_id | long | X / ✓ / ✓ / X | Parent dynamic kit reference. |
| pdks | wc_keywordText | ✓ / ✓ / ✓ / ✓ | Child dynamic kits. |
| name | wc_text_en | ✓ / ✓ / ✓ / X | Product name (full-text). |
| nameOverride | wc_text_en | ✓ / ✓ / ✓ / X | Workspace-specific name override. |
| shortDescription | wc_text_en | ✓ / ✓ / ✓ / X | Brief description (full-text). |
| shortDescriptionOverride | wc_text_en | ✓ / ✓ / ✓ / X | Workspace-specific short description. |
| longDescription | wc_text_en | ✓ / ✓ / ✓ / X | Detailed description. |
| keyword | wc_text_en | ✓ / ✓ / X / X | Keywords for discoverability. |
| keywordOverride | wc_text_en | ✓ / ✓ / X / X | Workspace-specific keywords. |
| categoryname | wc_text_en | ✓ / ✓ / ✓ / X | Category/group name. |
| mfName | wc_text_en | ✓ / ✓ / ✓ / X | Manufacturer name. |
| mfName_ntk | wc_keywordTextLowerCase | ✓ / ✓ / ✓ / X | Manufacturer name (keyword). |
| mfName_ntk_cs | wc_keywordText | ✓ / ✓ / ✓ / X | Manufacturer name (case-sensitive). |
| mfPartNumber_ntk | wc_keywordText | ✓ / ✓ / ✓ / X | Manufacturer part number. |
| partNumber_ntk | wc_keywordText | ✓ / ✓ / ✓ / X | SKU/part number. |
| catenttype_id_ntk_cs | wc_keywordText | ✓ / ✓ / ✓ / X | Catalog entry type ID. |
| components | wc_keywordText | ✓ / ✓ / ✓ / ✓ | Component product IDs. |
| defaultSearch | wc_text_en | ✓ / ✓ / X / X | Aggregated search field. |
| spellCheck | wc_textSpell_en | ✓ / ✓ / ✓ / X | Spell check index. |
| spellCorrection | wc_textSpellCorrection_en | ✓ / ✓ / ✓ / X | Spell correction data. |
| defaultTerms | wc_termSuggest | ✓ / ✓ / X / X | Term suggestions. |
| defaultSuggest | wc_textSuggest | ✓ / ✓ / X / X | Autocomplete suggestions. |
| name_suggest | wc_textSuggest | ✓ / ✓ / X / X | Product name suggestions. |
| name_ntk | wc_keywordTextLowerCase | ✓ / ✓ / ✓ / X | Name tokens (lowercase). |
| partNumber_suggest | wc_textSuggest | ✓ / ✓ / X / X | Part number suggestions. |
| shortDesc_suggest | wc_textSuggest | ✓ / ✓ / X / X | Short description suggestions. |
| term_suggest | wc_termSuggest | ✓ / ✓ / X / X | Generic term suggestions. |
| seo_token_ntk | wc_keywordTextLowerCase | ✓ / ✓ / ✓ / X | SEO tokens. |
| ad_attribute | wc_keywordText | ✓ / ✓ / ✓ / ✓ | Custom attributes. |
| buyable | int | X / ✓ / ✓ / X | Purchasable flag (0/1). |
| dkConfigurable | int | X / ✓ / ✓ / X | Dynamic kit configurable flag. |
| isDKPreConfigured | int | X / ✓ / ✓ / X | Pre-configured DK flag. |
| parentDKConfigurable | int | X / ✓ / ✓ / X | Parent DK configurable flag. |
| disallowRecOrder | int | X / ✓ / ✓ / X | Reorder disallow flag. |
| published | int | X / ✓ / ✓ / X | Publication status (0/1). |
| deepPublished | int | X / ✓ / ✓ / X | Hierarchical publish status. |
| dkDefaultConfiguration | string | X / ✓ / ✓ / X | Default DK configuration. |
| dkModelReference | string | X / ✓ / ✓ / X | Dynamic kit model reference. |
| dkURL | string | X / ✓ / ✓ / X | Dynamic kit configuration URL. |
| parentDKModelRef | string | X / ✓ / ✓ / X | Parent DK model reference. |
| state | string | X / ✓ / ✓ / X | Product state/status. |
| subscripType | string | X / ✓ / ✓ / X | Subscription type. |
| publishedOverride | int | X / ✓ / ✓ / X | Workspace-specific publish flag. |
| startdate | date | X / ✓ / ✓ / X | Availability start date. |
| enddate | date | X / ✓ / ✓ / X | Availability end date. |
| indexedTime | date | X / ✓ / ✓ / X | Index timestamp. |
| fullImage | string | X / X / ✓ / X | Full/large product image URL. |
| thumbnail | string | X / X / ✓ / X | Thumbnail image URL. |
| item_sequence | int | X / ✓ / ✓ / X | Item ordering. |
| sequence | wc_keywordText | ✓ / ✓ / ✓ / ✓ | Display sequence/order. |
| globalSequence | long | X / ✓ / ✓ / X | Global ordering value. |
| unstructure | wc_text_en | ✓ / ✓ / ✓ / X | Unstructured attachment content. |
Copy fields
Several source fields are copied into aggregated search and suggestion fields. The name, shortDescription, partNumber_ntk, categoryname, keyword, nameOverride, and shortDescriptionOverride fields are copied into defaultSearch (primary search), and also feed the spellCheck and spellCorrection fields. The name, partNumber_ntk, shortDescription, and keyword fields are copied into the corresponding suggestion fields (name_suggest, partNumber_suggest, shortDesc_suggest, and term_suggest).