HCL Commerce Version 9.1.14.0 or later

Troubleshooting: Improving facet count accuracy

You can achieve more accurate facet counts. The process may result in slower performance in certain configurations.

Problem

In HCL Commerce Version 9.1.14, an adjustment was made in how facets are returned when grouping is enabled. This adjustment was made to avoid scenarios where zero results are returned in certain queries. The parameter that controls merging facets from SKUs and Products, MergeProductAndSKUFacet is by default set to false and you will not experience any performance issues with this setting. If you want more accurate facet counts, you can change the value to "true." In this case, there may be a performance impact due to the extra processing involved.

Solution

You can reverse the change to how Product and SKU facets are managed. To enable the merging of facets for Products and SKUs, use the following configuration at the endpoint provided. Doing this will resolve the performance difference between the versions.
Note: If this is the first time you are changing this configuration, then use the POST request method. Subsequently, you can use PATCH to reconfigure the endpoint.
After you have made this change, restart the Query service for the changes to take effect.
PATCH/POST - http://dataQueryHost:dataQueryPort/search/resources/api/v2/configuration?nodeName=component&envType=auth

MESSAGE BODY:

{
"extendedconfiguration": {
"configgrouping": [
{
"name": "SearchConfiguration",
"property": [
{ "name": "MergeProductAndSKUFacet", "value": "true" }

]
}
]
}
}