Product filters – In detail

Depending on the creditworthiness of the customers (which you can read about here) who have purchased the product, Samba assigns a Price Score (1-100) to each product.

This score is generated by analysing the products purchased from the product category in terms of their selling price. That is, the higher the price score, the more premium the product is to the customer.

You can then filter your products according to this score and recommend, for example, more premium products to creditworthy customers and vice versa.

When filtering, you can choose whether you want the price score of the resulting products to be Less than (and equal to), More than (and equal to), Equal or Between the value you select.

This value is obtained from the PRODUCT_ID field in the product feed.

Using the filter, you can select a product with a specific ID from your database, or multiple products where at least part of their ID matches the substring you selected.

The CATEGORYTEXT field, in your product feed, describes the path through each category. You can then use the category filter to filter your products based on whether they are in the category you selected. You can select multiple categories at once and use the arrow (→) to select subcategories as well.

You can also filter your products based on what margin you have on their sales. Margin is calculated using a formula that includes the PRICE (product price) and PRICE_BUY (product purchase price) values from your product feed:

100*(PRICE-PRICE_BUY)/PRICE)

When filtering, you can choose whether you want the margin percentage for the resulting products to be Less than (and equal to), More than (and equal to), Equal or Between the value you select.

With the TITLE value, which contains the name of the product in the product feed, you can use a filter from your database to select a product with a specific name, or multiple products where at least part of the name matches the substring you selected.

You can also filter your products based on what their markup is. This is calculated using a formula that includes the PRICE (product price) and PRICE_BUY (product purchase price) values from your product feed:

100*(PRICE-PRICE_BUY)/PRICE_BUY)

When filtering, you can choose whether you want the percentage trade markup for the resulting products to be Less than (and equal to), More than (and equal to), Equal to or Between the value you select.

The DESCRIPTION field in the product feed contains a detailed description of your product. You can then select a product with a specific description from your database, or multiple products where at least part of their description matches the substring you selected.

With the PRODUCT_LINE value in the product feed, you can use the same filter to select a product in a specific product line from your database, or products from multiple product lines where at least part of the product line name matches the substring you selected.

Filter your products based on how many units of a given product you currently have in stock.

The filter works with the STOCK value in the product feed.

When filtering, you can select whether you want the stock value for the resulting products to be Less than (and equal to), More than (and equal to), Equal or Between the value you select.

You can also filter between your products that have a percentage discount you select.

The discount is calculated as the difference between the parameters PRICE_BEFORE_DISCOUNT and PRICE.

When filtering, you can choose whether you want the percentage discount for the resulting products to be Less than (and equal to), More than (and equal to), Equal or Between the value you select.

With this filter you can select products from your database that are specific brands. Alternatively, you can select multiple brands, where at least part of their name must match the substring you select.

The filter works with the values in the BRAND field in the product feed.

If you insert a custom parameter into your product feed in the PARAMETER field with the name NAME and value VALUE, you can then use it to filter your products.

We have written a detailed description with all the information about these custom parameters in a separate article here.

In the case of a segment, you can filter your resulting products according to whether they are in a segment you previously saved defined using product filters.