Category facets are displayed in the top navigation menu of the store header,
and in the left sidebar category facet. You can change the order of category in the storefront by
sorting them by count, name, or Management Center sequence. The sort orders apply when customers
both browse and search the storefront.
Before you begin
- Install the interim fix for JR54524.
Procedure
-
Configure the SORT_ORDER column value of the FACET
table:
-
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. |
-
Restart the WebSphere Commerce server.
-
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 are sorted by count when searching the storefront:
