Changing the order of category facet values

The category facet appears in the top navigation menu of the store header, as well as in the left sidebar of the browser window. You can change the order in which categories appear in the storefront, by sorting them according to their count, name, or Management Center sequence. The sort orders apply when customers browse or search the storefront.

Procedure

  1. Configure the SORT_ORDER column value of the FACET table:
    1. Run the following SQL statement to update the sort order value in the FACET table:
      
      UPDATE FACET SET SORT_ORDER='sortOrderOption' WHERE FACET_ID = -1001
      
      Where sortOrderOption accepts the following values:
      Sort order option Top navigation menu Left sidebar category facet
      0: Sort by facet entry count.

      This option sorts categories based on the number of facets, from highest to lowest.

      Sorted by Management Center sequence. When browsing: Sorted by count.

      When searching: Sorted by count.

      1: Sort by category name.

      This option sorts categories alphabetically, regardless of the number of facets.

      Sorted alphabetically. When browsing: Sorted alphabetically.

      When searching: Sorted by count.

      2: Sort by Management Center sequence. Sorted by Management Center sequence. When browsing: Sorted by Management Center sequence.

      When searching: Sorted by count.

      When searching with category filters applied: Sorted by Management Center sequence.

  2. Restart the WebSphere Commerce server.
  3. Restart the WebSphere Commerce Search server.

Example

To change the category facet to sort by category name:

UPDATE FACET SET SORT_ORDER='1' WHERE FACET_ID = -1001
As a result of the sort order change:
  • Facets are sorted alphabetically in the top navigation menu and when browsing the storefront:

    Facets when browsing storefront

  • Facets are sorted by count when searching the storefront:

    Facets when searching storefront