Create a product filter rule
Create a product filter rule in ServiceNow CPQ to dynamically include or exclude products from the quote catalog based on managed table data and transaction context.
Before you begin
The enableCatalogFilter tenant setting must be enabled. Submit a request to DevOps to enable this setting.
A managed table containing the reference data for filtering must exist. For more information, see the managed table configuration steps in Advanced product filtering for quotes.
Role required: admin
Procedure
Navigate to Products > Product Filter Rules.
Before creating a filter rule, define or verify the managed table that contains the reference data for filtering.
Navigate to the Tables tab in ServiceNow CPQ Admin.
Create or upload a table containing the business logic, such as region-to-product mapping or availability flags.
Verify that the table includes at least one column that can be mapped to the product catalog, such as Region, SKU, or Product Family.
Deploy the table to make it available for use in filter rules.
Select Create New Rule.
Enter a Rule Name, a Variable Name, and a Description for the rule.
In the Reference Table field, select the managed table that contains the filtering reference data.
Define the filter conditions using fields from the managed table and transaction data to specify when the rule applies.
Map the columns by matching the reference table columns to the corresponding product catalog columns.
For example, map the
Regioncolumn in the managed table to theRegioncolumn in the product catalog.Set the rule behavior.
- Select Include to show only products that match the filter condition.
- Select Exclude to hide products that match the filter condition.
- Select Save to store the rule.
Toggle the Active button to mark the rule as ready for deployment.
Select Deploy to apply the rule.
The rule is active. Only products matching the filter logic are displayed when users open the catalog from within a quote.