PCA - Exclude Ineffective Products

Owned by Sylvain Paillard
Last updated: Jan 08, 2021
6 min read

Overview

Remove out-of-stock products, as well as zero or low-value products, low margin, or any other unwanted products.

WPOS

Use Cases

Mode

Requirements

WPOS

Use Cases

Mode

Requirements

ALL

Product Attribute Promoter

FILTER*

You will need to select the name of the product attribute and the value you want to exclude

* the Use Cases configuration is provided as FILTER, which means these products will be completely removed from the returned products. This might not be desirable for WPOs like SEARCH/NAVI as it would completely remove the products from the search results. After copying the JSON, you can move the Use Case to be RANKER which will then simply show these products at the end but will not remove them from the search results.

Variables

  • field: the name of the product attribute

  • value: the value of the product attribute to be excluded

Cases to consider

You might want to configure this Best Practice several times, for example for the following cases

  • Products out of stock (if your product attribute is the stock count, put the value at 0)

  • Products with 0 or low price
    (select the attribute “Price After Discount” and set the value to 0 or under a minimum level ==> then use operator: “greater than”)

  • Products with 0 or low sales
    (select the attribute “Bq Order Count All Time” and set the value to 0 or under a minimum level ==> then use operator: “greater than”)

  • Products with negative, null or low profit
    (select the attribute “Bq Std Margin Amount” and set the value to 0 or under a minimum level ==> then use operator: “greater than”)

  • Products in a category you sell but don’t want to promote

  • Products of a brand you sell but don’t want to promote

How to configure it?

You can import the JSON below directly in the Admin (use the Import button on the top right), as in this screen-shot, you will need to select a field (product attribute) and replace the “{{value}}” with a value

You can use the search icon on the right of the field and values parameter to get help to select the right field and value.

If you would like the products returned to include this attribute value (instead of excluding products having this attribute value), you can change the operator parameter in the Advanced tab from “does not match exactly” to “matches exactly”, as in the screen-shot below.

 

[ { "useCaseModelSource": "library", "useCaseModelId": 1, "useCaseModelVersion": 1, "useCaseModelSubVersion": 1, "name": "Exclude Ineffective Products", "order": 1, "orGroup": null, "fromIndex": -1, "toIndex": -1, "maxWeight": null, "variant": "", "scope": "global", "overwriteLevel": 1, "overwriteLabel": null, "globalTargetTags": [], "active": true, "parameters": [ { "name": "field", "value": { "format": "FieldParameterValue", "value": "{{field}}" }, "scope": "global" }, { "name": "operator", "value": { "format": "StringParameterValue", "value": "does not match exactly" }, "scope": "global" }, { "name": "values", "value": { "format": "FieldValueParameterValues", "values": [ "{{value}}" ] }, "scope": "global" }, { "name": "orCondition", "value": { "format": "BooleanParameterValue", "value": true }, "scope": "global" }, { "name": "boostFilter", "value": { "format": "BooleanParameterValue", "value": false }, "scope": "global" }, { "name": "boostWeight", "value": { "format": "StringParameterValue", "value": "500" }, "scope": "global", "startval": {}, "schema": "" } ], "segmentationIds": [], "segmentationUniqueKeys": [], "CPOInitiativeId": null, "notes": null, "options": { "status": null, "includeWidgets": null, "excludeWidgets": null, "allWidgets": null, "conditionalSegments": null, "conditionalProductSelections": null, "ordering": null, "parameters": [ { "name": "system", "values": [ "false" ] } ], "allLinkedAccounts": null, "accounts": null }, "icons": { "strategy": { "value": "cpo_sales.png", "tooltip": "SALES OPTIMIZATION" }, "level": { "value": "L1", "tooltip": "LEVEL 1 - ONLINE CONVERSIONS" }, "initiative": { "value": "fa-folder", "tooltip": "EFFECTIVE PROMOTIONS" }, "character": { "value": "", "tooltip": "" }, "mode": { "label": "", "value": "", "tooltip": "" } }, "sections": [ { "id": "main", "label": "Values", "active": true }, { "id": "advanced", "label": "Advanced", "active": false } ], "status": false, "isSelected": true } ]