Enable Manual sequencing and featured image features for Commerce Insights

To manually change either the sequence of your products or the featured image in Commerce Insights, we must take steps to enable these options before we can use them.

For more information about product sequencing, see Changing product sequence in Store view. For more information about featured images, see Changing a product's featured image in Store view.

Before beginning

• (Developer) Create a staging trigger before you do this procedure. (DB2) For Db2 databases, use the following SQL files:

  • WCBD_installdir\schema\db2\wcs.stage.sequence.sql

  • WCBD_installdir\schema\db2\wcs.stage.trigger.sql

  For example:

  db2 connect to db_name user db_user using db_password
  db2 -tvf WCBD_installdir\schema\db2\wcs.stage.sequence.sql
  db2 -td# -vf WCBD_installdir\schema\db2\wcs.stage.trigger.sql 

  (Oracle) For Oracle databases, use the following SQL files: (Oracle)

  • WCBD_installdir\schema\oracle\wcs.stage.sequence.sql

  • WCBD_installdir\schema\oracle\wcs.stage.trigger.sql

Task info

In the WebSphere Commerce development environment, configure the EnableProductDisplayConfiguration search property in our custom catalog component configuration file (wc-component.xml) on the Search EAR.

Procedure

1. Move to the WCDE_installdir\workspace\search-config-ext\src\runtime\config\com.ibm.commerce.search\ directory. If there is no wc-component.xml file in the directory, copy or rename the existing wc-component-template.xml to wc-component.xml.

2. Edit wc-component.xml. Delete the comment tagging and text surrounding the following XML element.

   <!-- wait until we have CI env for integration (manual, intelligent sequencing) 
   <_config:property name="EnableProductDisplayConfiguration" value="true"/> --> 

   For more information about editing the wc-component.xml component configuration file, see Changing properties in the component configuration file (wc-component.xml).

3. Save and exit the file.

What to do next

When the product display configuration for product sequencing and featured images is enabled, increase the Solr JVM maximum heap space by 15 MB category. For more information about increasing the Solr JVM maximum heap, see WebSphere Commerce Search performance tuning.

• Disable Manual sequencing and featured image features for Commerce Insights
  We can make the manual product sequencing and featured image options unavailable to users in the Commerce Insights Store view. If manual product sequencing and featured image are unavailable, the Edit Content option does not appear in Store view.