Displaying Search Facets in WCS FEP5

Until about FEP4, the search facets data was in SRCHATTR and SRCHATTRPROP tables. SRCHATTR defines the search attributes and SRCHATTRPROPS defines the properties for the attributes (like facetable, displayable, searchable etc). 

In Feature pack 5, two new tables for facets are available namely, FACET and FACETDESC. 

As an example, to make price facets work for a different currency that is not supported out of the box, like AUD, we first need to create a search attribute (SRCHATTR table) with IDENTIFIER _cat.OfferPrice_AUD 

For the above search attribute, create a search attribute property name “facet” and property value “price_AUD:{* 100} 100;{100 200} 200;{200 300} 300;{300 400} 400;{400 500} 500;{500 *}” (adjust the range of facet as required)

Now add a row in FACET table with a reference to SRCHATTR_ID created in previous steps. Add appropriate descriptions to FACETDESC table.

Update registry and clear cache and should be able to view the facet on the storefront.

Ref: http://pic.dhe.ibm.com/infocenter/wchelp/v7r0m0/index.jsp?topic=%2Fcom.ibm.commerce.developer.doc%2Ftasks%2Ftsdsearchenableattr.htm

Loading Attribute Dictionary Attributes

Create two csv files as below

AttributeDictionaryAttributeAndAllowedValues.csv 

This contains the attribute name and allowed values AttributeDictionaryAttributeAndAllowedValues,,,,,,,,,,,,
Identifier,Type,AttributeType,Sequence,Displayable,Searchable,Comparable,Name,AllowedValue1,AllowedValue2,AllowedValue3,AllowedValue4,AllowedValue5,Delete

DRColour,STRING,AllowedValues,1.0,true,true,true,Colour,Black,Silver,,,,
DRTuner,STRING,AllowedValues,2.0,true,true,true,Tuner,Single tuner USB HDD PRV,,,,, 

• The first two lines constitute the header.
• The first column is an identifier for the attribute.
• The 2^nd column defines the type of the attribute value (STRING, DECIMAL, WHOLE NUMBER)
• The 3^rd column specifies the attribute type. Two types are possible (AllowedValues, AssignedValues). Using AllowedValues, business user can select one of the available values for an attribute. Using AssignedValues, business users can enter the value for the attribute. AllowedValues can be reused and assigned to a different catentry. This column will in most cases be AllowedValues.
• The 4^th Column is Sequence which defines the ordering of attributes. (1.0, 2.0, etc)
• The 5^th, 6^th and 7^th columns are the displayable, searchable and comparable field which is set to either true/false.
• The 8^th column defines the name of the attribute (like Colour, Size, etc)
• Columns from 9 onwards to 13 represent the possible allowed values for an attribute.
• Column 14 defines if the attribute has to be deleted by setting the Delete to 1 

CatalogEntryAttributeDictionaryAttributeRelationship.csv 

CatalogEntryAttributeDictionaryAttributeRelationship,,,,,,
PartNumber,AttributeIdentifier,ValueIdentifier,Value,Usage,Sequence,Delete
P_NZ40006688,DRColour,Black,,Descriptive,1,
P_NZ40006688,DRTuner,Single tuner USB HDD PRV,,Descriptive,2,

• The first two lines constitute the header.
• The 1^st column defines the partnumber of the catentry to which an attribute is to be associated
• The 2^nd column is an identifier that identifies the attribute that needs to be associated with the catentry
• The 3^rd column is the identifier that identifies the value (an attribute can have multiple values) that needs to be associated with a catentry
• The 4^th column represents the value. (can be same as value identifier or empty)
• The 5^th Column defines the usage which can either be “Descriptive” or “Defining”. For SKU’s use Defining
• The 6^th column defines whether the association has to be deleted. Specifying 1 will delete any existing row. This can be 0 or empty for loading attributes.

TABLES AFFECTED 

ATTR – Contains the attribute definition
ATTRVAL – contains the attribute values
CATENTRYATTR – Contains the link between the catentry and the attribute

Note: These attributes are loaded to the store that owns the master catalog. In case of extended sites store it is the ExtendedSites CAS (Master catalog store entity)

Viewing and publishing Madisons Store in v7 FEP 5 (Developer Environment)

By default, in WCS Feature pack 5, the Madisons Store archives are not displayed in the publish wizard in administration console. These can be made available by following the steps below

Create a folder structure “conf/sar” inside WCDE_installdir/

Go to the starterstores folder in WCDE_installdir/starterstores and copy over any sar that is not available for publish in the wizard (like MadisonsStorefrontAssetStore-FEP.sar) from ExtendedSites folder to the conf/sar folder created above

Open the administration console and use the publish wizard and you should be able to see the sar file in the “Default” option of the publish wizard.

NoSuchMethodError for getBIProvider()

After migrating from version 6 to version 7 of IBM Websphere Commerce, an exception is generated during the invocation of a getBIProvider() method when business user selects a store in Management Center.

The getBIProvider() method was introduced in version 7 of WCS. After the migration from v6 to v 7 of WCS, the coremetrics.jar file doesn’t get removed from the Stores/WEB-INF/lib directory.  Once removed, the latest coremetrics related class files are loaded.

Reference

http://www-01.ibm.com/support/docview.wss?uid=swg21503410