Broadleaf Commerce Discussion Forums

Take a look at the demo site sample SQL (load_catalog_data.sql) to see how we are adding to the BLC_SEARCH_FACET entity. You can associate search facets with categories to achieve what you are trying to do. In the heat clinic demo, we give an example of this with the "heat_factor" in the hot sauces category.

This is a commercial feature of broadleaf commerce if you want to enable this through Admin,whereas if you are good to go with SOLR and DB then you can create this using sql scripts also.

Steps For Creating a New Facet Filter :
1. Create a Product Attribute On the basis of what filter you want to create,in load_catalog_data.sql(Demosite>Core>src>main>resources>sql>load_catalog_data.sql)
Script for this is-
Lets say creating a Length filter for the Shirts in Broadleaf Demosite

Enter this script for each and every product of the category.

2. Now create an entry of this product attribute in BLC_FIELD.
As per the above example the script will be like this-

For reference to the FACET_FIELD_TYPE check out the schema.xml(Demosite>site>main>resource>schema.xml)
This file has definition of each and every facet field types.

3. After this make entries for the above FIELD_ID in “BLC_SEARCH_FACET” and ‘BLC_CAT_SEARCH_FACET_XREF’ using the following script-

Where the CATEGORY_ID is the ID of the Category on which you want to apply this filter.

Hope this will be helpful to you.