WebSphere Commerce Version 7.0.0.7WebSphere Commerce Version 7.0.0.6

Enabling interim fix JR48904

Interim fix JR48904 adds a new filter to improve the performance of e-Marketing Spot recommendations. The filter is added so that the entitlement check that is performed by marketing for any catalog entry or category recommendations can be disabled.

You can improve runtime performance by disabling the entitlement check. B2C business model stores typically do not require entitlement checking. The new filter is named removeIfNotEntitled and is supported on FilterCatalogEntryTaskCmd and FilterCategoryTaskCmd.

For more information about filter recommendations, see Management Center: Setting up filters to control whether to display marketing information in an e-Marketing Spot

Before you begin

Install the cumulative interim fix for your fix pack level. JR48904 is included in the cumulative.

Procedure

  1. Open a connection to your database.
The following SQL example turns off all filtering for category entries and categories for store 10101.
  1. Update the CMDREG table:
    INSERT INTO CMDREG (STOREENT_ID, INTERFACENAME, CLASSNAME, PROPERTIES) values 
    (10101, 'com.ibm.commerce.marketing.commands.marketingspot.FilterCatalogEntryTaskCmd', 
    'com.ibm.commerce.marketing.commands.marketingspot.FilterCatalogEntryTaskCmdImpl', 
    'removeIfNotEntitled=0&removeIfNotInCurrentCatalog=0&removeIfPastEndDate=0&removeIfNoInventory=0&removeIfExistInShopcart=0&removeIfExistInPurchaseHistory=0')
    
    INSERT INTO CMDREG (STOREENT_ID, INTERFACENAME, CLASSNAME, PROPERTIES) values 
    (10101, 'com.ibm.commerce.marketing.commands.marketingspot.FilterCategoryTaskCmd', 
    'com.ibm.commerce.marketing.commands.marketingspot.FilterCategoryTaskCmdImpl', 'removeIfNotEntitled=0&removeIfNotInCurrentCatalog=0')