IBM WCS Indexing Product attributes and Enabling Facets

IBM WCS Indexing Product attributes(Classic Attributes)

1. Product attributes can be either defining (SKUs) or descriptive.
2. There are 30 String fields and 10 Integer and Float fields each that can be used for attribute indexing.
3. To index an attribute, enter the attribute name in “ATTRNAME” field of “CLSATTRSRCHCONF” table. For e.g., enter “Colour” if you have colour as the defining/descriptive attribute for items
4. Update the separator to the relevant separator character. For me it is a semicolon ;
5. Once this is done, run the pre-processing and then build index.
6. This will index the catalog attributes in Solr

IBM WCS Enabling Facets on Product attributes

Indexing will not enable the facets display on the store. To enable facet display, follow the steps below:

We need to add a search attribute for Colour in SRCHATTR table (Assuming colour is my product attribute)
-10001    0    CatalogEntry    _cat.Colour    0

Also add the search attribute properties in SRCHATTRPROPS as below
-10001    rank    cas_f1    0
-10001    search    cas_f1    0
-10001    display    cas_f1    0
-10001    filter    cas_f1_ntk_cs    0
-10001    catalogFilter    cas_f1_ntk_cs    0
-10001    facet    cas_f1_ntk_cs    0
Where cas_f1 and cas_f1_ntk_cs are the fields defined in solr core. Restart the websphere commerce server once done and you have the attribute facets appearing on the page.