Change search configuration properties in the STORECONF table

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

Before beginning

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

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 or wc.search.entitlement.

Note:

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';