Registering the inventory product property in the database

In this lesson, the inventory product property is registered in the WebSphere Commerce database. As a result, the Management Center search property service is able to return the inventory property in search rules.

Procedure

Run the following SQL queries:


INSERT INTO srchattr (SRCHATTR_ID, INDEXSCOPE, INDEXTYPE, IDENTIFIER, OPTCOUNTER) 
VALUES (10101, '0', 'CatalogEntry', '_cat.Inventory', 0);
INSERT INTO srchattrprop (SRCHATTR_ID, PROPERTYNAME, PROPERTYVALUE, OPTCOUNTER) 
VALUES (10101, 'merchandising-Filter-Numeric', 'inventory', 0);
INSERT INTO srchattrprop (SRCHATTR_ID, PROPERTYNAME, PROPERTYVALUE, OPTCOUNTER) 
VALUES (10101, 'merchandising-Rank-Numeric', 'inventory', 0);
INSERT INTO srchattrdesc (SRCHATTR_ID, LANGUAGE_ID, DISPLAYNAME, DESCRIPTION, OPTCOUNTER) 
VALUES (10101, -1, 'Inventory', null, 0);

Restart your WebSphere Commerce server.
Verify that the inventory product property displays in the Management Center under the Change Search Result Order and Add or Replace Search Criteria actions: