Connector for HCL Commerce Manual / Version 2207
Table Of ContentsPer default HCL behavior, you cannot distinguish the SEO keyword overridden by a store. If you have overridden the SEO keyword in the store, then you will get multiple SEO keywords in the response, without knowing which SEO keyword belongs to which store. To be able to distinguish the SEO keyword you need to extend the Solr field by adding the custom CM_SEO_TOKEN field in the Solr index. This custom CM_SEO_TOKEN field concatenates the store ID and the SEO keyword.
Add a preprocessing file for CM_SEO_TOKEN field. The file
Code\ts-app\xml\search\dataImport\v3\db2\CatalogEntry\wc-dataimport-preprocess-cm-seo-token.xmlin the CoreMedia HCL Commerce Workspace defines a custom preprocessing task for this. The file contains the new temporary table definition, database schema metadata and a reference to the Java class used in the preprocessing steps for an Oracle database.Copy the file to the corresponding location in your HCL Commerce RAD system. The workspace contains files for other databases which you can use similarly.
Extend the HCL Solr configuration files by including CM_SEO_TOKEN into the SQL statements as follows:
Add the following new field to the HCL
x-schema.xmlfileWCDE-INSTALL/workspace/search-config-ext/src/index/managed-solr/config/v3/CatalogEntry/x-schema.xml<field name="cm_seo_token_ntk" type="wc_cmKeywordTextLowerCase" indexed="true" stored="true" multiValued="true"/>Example 3.2. New CM_SEO_TOKEN Solr field
Extend the query select and the query from for parent part number using the wc-data-preprocess-x-finalbuild.xml file
WCDE-INSTALL\workspace\WC\xml\search\dataImport\v3\db2\CatalogEntry\wc-data-preprocess-x-finalbuild.xml.
Rebuild the index as described in the HCL documentation at https://help.hcltechsw.com/commerce/9.0.0/search/tasks/tsdsearchbuildindex.html
WebSphere Commerce search contains a scheduler job (UpdateSearchIndex) that synchronizes catalog changes with the search index. The default update interval is 5 minutes. You can change the default value in the WebSphere Commerce Administration Console.
