Use conditions/rules to optimize your catalogue values at every step of your products setting in Lengow and before sending them to a channel :
- At the Categories Matching step
- At the Attributes Matching step
- At the Exclusions step
The process detailed below is the same for all these steps.
"Channels" tab > select a channel > "settings"
How to add a new rule
Select the attribute on which you want to apply a rule > clic on the cog icon (see image) to open the rules settings page.
There is a technical limitation at 50 attributes containing at least one active rule.
Best practice: remember to delete or deactivate your unused rules.
Setting your rule parameters
The setting of a rule in Lengow always follows the same format. Meaning that, to set up a new rule, simply follow the steps below:
2. Select the affected products - "For...All my products/Some of my products"
3. Define a time period to apply
4. Rename your rule
Step 1: Define an action
Tell the system what you want to do with this rule.
I want to...
1.1: Define a value
- Use the dollar ($) symbol to call a field from your product catalogue.
- Directly write the value you want to set.
- Use a function.
Lengow Tip: Add another action to have an impact on multiple attributes and save time on your settings!
1.2: or Empty values
It will not erase any value from your catalogue and you can still use them in other attributes.
1.3: or Convert values
- Select the field of your catalog whose values are to be modified
- The list of values in this field will appear on the left listing
- All that remains is to link your values with those proposed by the channel OR to enter hard-coded values if no value is proposed by the channel
This can be used for example to create a rule for your promotions or to empty some fields for parent products only.
Step 2: Select the affected products
Select the products that will be affected by the rule. Two options are possible:
- All my products: in this case, you just need to click on this option to impact all of your products.
- Some of my products: here we invite you to define precisely which products will be affected by creating a condition (When...).
The condition is based on the values of your product catalogue. There are three items to select:
- The field in your product catalogue where the desired value is located
- The operator. Two types are available:
- numeric operators: to be used for your fields containing only numbers (like the price). Your condition can be set by comparing numerical data. Examples : =, >, etc.
- string operators: for your fields containing text or other alphanumerical data (e.g. SKU). Your condition can be based on the characters present in a field. Examples : Is, Contains, Length=, etc.
- The target value(s), several cases:
- You need to refer to a specific value from your product catalogue: Specify this value and note that the case (upper or lower) and spelling must match exactly.
- You want to target several specific values: Enter these values, one after the other, and separate them using the "pipe" character (|). Example : 3|2|1
- You want to target all the values from a specific field: call up this field dynamically using the dollar ($) symbol.
By combining these three elements, you can select products from your catalogue.
I want to target the promotional products of my catalogue.
So I define the condition (based on my catalogue) as: When "$standard_price" < "$barred_price"
Then I can also add conditions with the "AND" or "OR" operator:
"AND when my category contains the term Clothes "
"OR when my title contains either Sweater, either Tee-Shirt, either Pants "
Step 3: Define rule during specific period
Choose the period of validity of your rule by checking one of the following options:
- "all the time"
- "over a period" and select the period.
Step 4: Rename your rule
Automatically and depending on the choices you have made on your rule (the selection of blocks), a title will be added.
Example: Define values / Some of my products / Over a period
You can rename your rule manually, with a more meaningful title by clicking directly on the title or keep the default title.
Rules always take precedence over the default rule applied to all products. In fact, all new rules will be placed above one to another.
=> If two or more rules impact the same products, the highest rule will take precedence over the others. Meaning that the last created rule will impact the product in case of a conflict between two or more rules.
How does priority work?
2. When a rule is created, it is automatically placed above the default rule. The rate of products covered is immediately re-calculated.
3. Then, all new rules will be placed above one to another, and the system will re-calculate the rate of products covered.
Activating/deactivating a rule
On the page listing your rules, you can select one of the options offered on the right of the panel:
- Disable / Enable