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.

Before you begin

Ensure that you complete the following tasks:

Procedure

  1. 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.

  2. Site administrators: Update the FACET table to mark the attribute as featured. This is done by updating the Group_ID value of the attribute from 0 to 1:
    
    UPDATE FACET SET GROUP_ID=1 WHERE ATTR_ID=ATTR_ID;
    
    Where ATTR_ID is the facetable attribute ID that you want to feature:
    • 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.
    • 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;
    

What to do next

Open the Aurora starter store and ensure that the featured section displays the attributes you want to show as featured.