Feature Pack 7 or later

Changing search configuration properties in the STORECONF table

To change search configuration properties in the STORECONF table, you must run an SQL statement to the desired values.

Before you begin

To understand the search-related properties that the STORECONF table contains, see Search configuration properties in the STORECONF table.

Procedure

  1. Run the following SQL statement to update search-related properties in the STORECONF table: 
    
UPDATE STORECONF SET VALUE='searchPropertyValue' WHERE STOREENT_ID=TargetStoreId AND NAME='searchProperty'
    Where:
    searchPropertyValue
    The new value of the search property.
    TargetStoreId
    The store ID that the search property change applies to.
    searchProperty
    The search property to change. For example, wc.search.priceMode or wc.search.entitlement.
    Note:
  2. Restart the WebSphere Commerce server.
  3. Restart the WebSphere Commerce search server.

Example

To change a starter store's price mode to 2 (Mixed), with a STOREENT_ID of 715838534:

UPDATE STORECONF SET VALUE='2' WHERE STOREENT_ID=715838534 AND NAME='wc.search.priceMode';
To enable entitlement check for a starter store with a STOREENT_ID of 715838534:

UPDATE STORECONF SET VALUE='1' WHERE STOREENT_ID=715838534 AND NAME='wc.search.entitlement';