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
Procedure
-
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
orwc.search.entitlement
.
Note: - Restart the WebSphere Commerce server.
- 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';