The following steps are required to create a Product Advisor search space
using the sample utility. This utility includes SQL statements that refer to
data such as product and category ID's. Before running the utility, you
will have to update some statements to reflect your own product data.
Note: This information does not apply to
iSeries users. Instead, refer to creating a Product
Advisor search space using an XML file.
- Decide on a category for which you want to enable a Product Advisor search.
- Change to the following directory:
/WC_installdir/samples/pa/bin
\WC_installdir\samples\pa\bin Edit the following file:
Note: Oracle is not supported on the Linux platform.
createsearchspace.sh
createsearchspace.bat
There are comments in the file to show you sections of the process where changes are required. The following steps will use the NT file name. Substitute the correct file name as appropriate. - Run the createsearchspace utility by entering the following:
createsearchspace.bat dbnamestore_numbercategory_number
lang1 lang2 lang3 attr1 attr2 attr3where:
- dbname
- is the name of the WebSphere Commerce database
- store_number
- is the store reference number of the store for which the search space is being created
- category_number
- is the category reference number (also referred as the catgroup) of the category for which the search space is being created
- lang1, lang2, lang3
- are language IDs of the languages for which the search space is being created. The utility can create a search space for three languages simultaneously. If you require fewer languages, use the same ID for each parameter
- attr1, attr2, attr3
- are common product attributes for the category. The utility accepts up to 3 attributes that are of type String. Integer and float attributes are also supported. Examples are contained in comment blocks in the utility.
Oracle users must write the SQLs required to create Product Advisor search space using the sample utility.
Note: This utility is only a sample that illustrates how to create a search space. If you have a large number of products or categories, or concerns about performance, you should create a custom version of this utility.