Saturday, 8 November 2014

Websphere Commerce Catalog Filter

Catalog Filter and Pricing tool  is used to filter your catalog to a specific set of catalog entries by specifying which categories, catalog entries, attribute dictionary attributes, and catalog entry properties to include or exclude from the catalog filter. Use catalog filters for your product entitlement, that is, to entitle customers to a subset of your catalog. Catalog filters can also be used as one of the price rules conditions when determining the prices for the set of catalog entries your customers are entitled to.

Catalog filtering criteria
When creating catalog filters, you can combine one or more filtering criteria to achieve your business goals. The catalog filtering criteria are:

1. Category-based criteria
You can include or exclude categories from your catalog. If you include a category, any catalog entry and child category under this category is included, unless you explicitly exclude the catalog entry or category. For example, assuming that you include the "Brake Component" parent category in your filter, by default, all the child categories under this category is also included; however, if you explicitly exclude the "Brake pads" child category from the catalog filter, this child category is excluded from the catalog.
When a category or catalog entry is included in the catalog filter, its parent categories become browsable. These automatically added parent categories allow customers to browse your site to find the explicitly included catalog entry.

2. Category-based criteria with conditions

You can apply conditions on the categories that are added to your catalog filter. The condition can be composed of attribute dictionary attributes or catalog entry properties. By default, the following catalog entry properties can be specified: Product Part Number, Manufacture Part Number, and Manufacturer Name.
To apply a condition on a certain category, you must first define a condition group. A condition group is a group of one or more attribute dictionary attributes and catalog entry properties conditions. A category can have one or more condition groups, and each condition group can contain one or more attribute dictionary attribute and property conditions. 

3. Catalog entry-based criteria

You can include or exclude catalog entries from your catalog. The catalog entry-based criteria takes higher precedence over the other filtering criteria. For example, assuming Product A is under Category A, if you exclude Category A and include Product A in your catalog filter, this results in Product A still being included in the catalog filter.

Catalog filter assignment and contracts

To entitle different customers to a subset of your catalog on the storefront, you assign a catalog filter to a contract using WebSphere Commerce Accelerator. This requirement applies to all business models (B2B direct, consumer direct, and extended sites). As a result, customers shopping under the contract are entitled to see and purchase only the set of catalog entries defined in the catalog filter. 

Attribute dictionary attribute and property conditions in catalog filters

When you include or exclude categories in your catalog filter, you can specify which catalog entries properties or attribute to include or exclude. To do this, define conditions on the categories in the catalog filter. A condition can contain attribute dictionary attributes or catalog entry properties.

To apply a condition on a category in your catalog filter:

1.      Add a category to the catalog filter.
2.      Define a condition group.
3.      Specify one or more attribute dictionary attributes or catalog entry property conditions within the condition group.

A category can contain one or more condition groups, and each condition group can contain one or more attribute dictionary attribute and property condition. To add a category to the catalog filter, right click the category that is related to the catalog filter and click include. This will make it possible to insert condition groups to the catalog filter.

Note that conditions can also be applied to the entire catalog. If you use a condition on a category, the filter includes or excludes the products that meet the condition.

In a catalog filter, the whole catalog is included by default. If you put a condition at the top-level (the whole catalog) that said colour equals white , then the filter would include all white products, and nothing else. The result is that everything that is not white is excluded.

Catalog Filter  Tables

CATFILTER - Each row of this table represents a catalog filter.

CATFLTDSC- Each row of this table represents a language specific description of a certain catalog filter.

CFCATGROUP- Each row represents a selected catalog group in the catalog tree.

CFCONDGRP- Each row of this table represents a condition group in a certain catalog filter

CFCOND- Each row of this table represents a condition in a certain condition group

CFCONDVAL- Each row of this table represents the association between a condition and an attribute value.

PRODUCTSET- This table holds the definition of a product set. The actual representation of the product set is held in the PRSETCEREL table.

CFPRODUCTSET- Each row represents the relationship between a catalog filter and a product set used for filtering.



No comments:

Post a Comment