Featuring products by using Exclusive or Clearance search facets
Business users can work with site administrators to enable search facets for featured
products. The storefront can provide customers with faceted navigation for attributes that are
intended to be featured. You can enable search facets for featured products on the default Exclusive
and Clearance facets, or on other existing Attribute Dictionary attributes.
Procedure
-
Business users: Mark the attribute
you want featured as facetable using the Management Center Attribute
Dictionary tool.
For example, mark the default Exclusive and Clearance attributes as facetable.
-
Site administrators: Update the FACET table to mark the attribute as featured.
This is done by updating the
Group_ID
value of the attribute from0
to1
:
Where ATTR_ID is the facetable attribute ID that you want to feature:UPDATE FACET SET GROUP_ID=1 WHERE ATTR_ID=ATTR_ID;
- To find the attribute ID of the faceted attribute you want to feature, either:
- Look up the attribute in the
ATTR_ID
column of the ATTRDICTSRCHCONF table, or - Use the Attribute Dictionary-Attributes list view in the Management Center. It displays a list of the attributes and view the Unique ID details for the faceted attribute you want to feature.
- Look up the attribute in the
- The default attribute ID for the Exclusive facet is
7000000000000000156
. - The default attribute ID for the Clearance facet is
7000000000000000157
.
For example, to enable the default Exclusive and Clearance attributes as featured facets, run the following SQL queries:UPDATE FACET SET GROUP_ID=1 WHERE ATTR_ID=7000000000000000156; UPDATE FACET SET GROUP_ID=1 WHERE ATTR_ID=7000000000000000157;
- To find the attribute ID of the faceted attribute you want to feature, either: