close

Filter

loading table of contents...

Connector for HCL Commerce Manual / Version 2304

Table Of Contents

3.4.6 Adding New CM_SEO_TOKEN Field to the Solr Index

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

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

  2. Extend the HCL Solr configuration files by including CM_SEO_TOKEN into the SQL statements as follows:

    1. Add the following new field to the HCL x-schema.xml file WCDE-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


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

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

Search Results

Table Of Contents
warning

Your Internet Explorer is no longer supported.

Please use Mozilla Firefox, Google Chrome, or Microsoft Edge.