General information about rule format¶
Quick Overview¶
This cookbook is about a feature only provided in the Enterprise Edition.
Enrichment rules allow to set values or properties for products given specific conditions. These rules can be manually applied from the User Interface or run using a cronjob.
File Structure¶
Enrichment rules are defined in YAML format, so the file extension has to be “.yml”. Indentation is mandatory within the file and has to strictly follow the YAML format. You have to import a rule so that it can be used in the PIM.
This file starts with “rules” root element, which contains the list of enrichment rules. This document is about this list. Each rule is referred to by a code and can contain a list of conditions and actions.
# Example of a file with 2 rules
rules:
camera_set_canon_brand:
priority: 0
conditions:
- field: family
operator: IN
value:
- camcorders
- field: name
operator: CONTAINS
value: Canon
- field: camera_brand
operator: NOT IN
value:
- canon_brand
actions:
- type: set
field: camera_brand
value: canon_brand
labels:
en_US: 'Canon brand'
fr_FR: 'Marque Canon'
camera_copy_name_to_model:
priority: 0
conditions:
- field: family
operator: IN
value:
- camcorders
- field: camera_model_name
operator: EMPTY
actions:
- type: copy
from_field: name
to_field: camera_model_name
labels:
en_US: 'Copy name to model'
fr_FR: 'Copie nom vers modèle'
Indentation is mandatory within the file and must be strictly identical to the one shown in the example.
Enrichment Rule Structure¶
- Structure’s elements which define a rule are:
rule’s code (dynamic)*
priority
enabled
conditions*
actions*
labels
- Structure’s elements which define a condition are:
field*
locale
scope
operator*
value*
An enrichment rule is structured as follow:
[free rule code]:
priority:
enabled:
conditions:
- field*:
locale:
scope:
operator*:
value*:
actions:
- type:*
[Various elements depending on the action]
labels:
[locale code]: [label]
Elements with * are mandatory. Fill in the locale and scope elements only if your condition applies on localizable and/or scopable attributes.
Dashes (-) must be placed before an element field and after each element contained in the value part.
Colon (:) mandatory after each structure element.
Tip
For more details you can see the YAML specifications.
Warning
Rules code choice is up to you, however it has to contain only alphanumeric characters, underscores, dashes and be less than 100 characters.
A priority can be given to a rule. Priority will be considered for rules execution order. Without any given priority, a rule has a zero-priority. The higher the priority, the sooner the rule will be executed. Therefore, a 90-priority rule will be executed before 0-priority ones. If two rules have the same priority, they will be executed in a “technical” order. (database reading order)
A status can be defined with the enabled key. When the value is false, the rule cannot be executed neither from cronjob or manually. In the rule import, this key is not mandatory, the rule is enabled, set to true, by default if it’s not specified.
Action’s conditions can be applied on localizable and scopable values. In this case, it has to be specified using and scope elements.
The definition of conditions is very important, make sure you select only products concerned by the rule. Add conditions so the rule(s) will not be executed if needed.
The field “camera_brand” will be updated only if its value is not already equal to “canon_brand”.
rules:
camera_set_canon_brand:
priority: 0
enabled: true
conditions:
- field: family
operator: IN
value:
- camcorders
- field: name
operator: CONTAINS
value: Canon
- field: camera_brand
operator: NOT IN
value:
- canon_brand
actions:
- type: set
field: camera_brand
value: canon_brand
The field “auto_focus_points” will be updated only if its value is not already equal to “4”.
rules:
camera_set_autofocus_point:
priority: 0
enabled: true
conditions:
- field: family
operator: IN
value:
- camcorders
- field: name
operator: CONTAINS
value: Canon
- field: auto_focus_points
operator: !=
value: 4
actions:
- type: set
field: auto_focus_points
value: 4
The field “description” for en_US locale and ecommerce channel will be updated only if its value is EMPTY and if the source field “description” for en_US locale and print channel is NOT EMPTY.
rules:
copy_description_us_to_ecommerce_us:
priority: 0
enabled: true
conditions:
- field: family
operator: IN
value:
- camcorders
- field: description
locale: en_US
scope: ecommerce
operator: EMPTY
- field: description
locale: en_US
scope: print
operator: NOT EMPTY
actions:
- type: copy
from_field: description
to_field: description
from_locale: en_US
from_scope: print
to_locale: en_US
to_scope: ecommerce
Enrichment Rule Definition¶
Available Actions List¶
Akeneo rules engine enables 7 kinds of actions:
Copy¶
This action copies an attribute value into another.
Warning
Source and target attributes should share the same type. If the source attribute is empty, the value “empty” will also be copied.
- Two parameters are required while the four others are optional:
from_field: code of the attribute to be copied.
from_locale: locale code of the value to be copied (optional).
from_scope: channel code of the value to be copied (optional).
to_field: attribute code the value will be copied into.
to_locale: locale code the value will be copied into (optional).
to_scope: channel code the value will be copied into (optional).
Tip
For instance, you have a scopable and localizable attribute called “description”, you can copy its content from en_US locale and print channel to the en_US locale and ecommerce channel. Action will be defined as follows:
actions: - type: copy from_field: description from_locale: en_US from_scope: print to_field: description to_locale: en_US to_scope: ecommerce
Set¶
This action assigns value(s) to an attribute having the type text, textArea, simple select…
- Two parameters are required while the two others are optional.
field: attribute code.
locale: locale code for which value is assigned (optional).
scope: channel code for which value is assigned (optional).
value: attribute value.
Tip
For instance, to set the value “My very new description for purple tshirt” to your description attribute in en_US locale, for ecommerce channel, the action will be as follows:
actions:
- type: set
field: description
locale: en_US
scope: ecommerce
value: "My very new description for purple tshirt"
It can also assign values to the following properties: categories, status (enabled/disabled), groups, family, associations. Beware, the previous values will be replaced by the new ones.
Tip
For instance, the following actions will disable the product and set its family to ‘shoes’. It will also categorize it in “category_code_1” and “other_category_code” (while uncategorizing it from its previous categories), and add it to the “group_code” group (while removing it from its previous groups)
actions:
- type: set
field: enabled
value: false
- type: set
field: family
value: shoes
- type: set
field: categories
value:
- category_code_1
- other_category_code
- type: groups
field: groups
value:
- group_code
Regarding the associations, you can choose to associate any combination of products, product_models or groups for each association type.
Tip
For instance, the following action will replace the associated products for X_SELL, but won’t update associated product models or groups. On the opposite, it will replace its associated product models and groups for UPSELL association, but won’t update associated products.
actions:
- type: set
field: associations
value:
X_SELL:
products:
- product_42
- another_product
UPSELL:
product_models:
- amor
groups:
- tshirts
Add¶
This action allows to add values to a multi-select attribute, a reference entity multiple links attribute or a product to categories or groups.
- Two parameters are required while the two others are optional.
field: attribute code.
locale: locale code for which value is assigned (optional).
scope: channel code for which value is assigned (optional).
items: attribute values to add.
Tip
For instance, to add the category “t-shirts”, action will be as follows:
actions:
- type: add
field: categories
items:
- t-shirts
It can also associate products / product models / groups without removing already associated ones. As for the set action, you can choose to only associate products or product models or groups, or any combination of those.
Tip
For instance, the following action will associate the “product_42” product and the “tshirt” group to your product (while keeping previously associated products and groups), and won’t update the associated product models.
actions:
- type: add
field: associations
items:
X_SELL:
products:
- product_42
groups:
- tshirts
Remove¶
This action removes values from a multi-select attribute, a reference entity multiple links attribute or a product category.
- Two parameters are required while the three others are optional.
field: attribute code or “categories”.
locale: locale code for which value is assigned (optional).
scope: channel code for which value is assigned (optional).
items: values to remove.
include_children: if
true
, then also apply the removal of the children to the given categories. Only applicable iffield
is set to “categories” (optional, defaults tofalse
).
Tip
For instance, to remove the category “t-shirts”, action will be as follows:
actions:
- type: remove
field: categories
items:
- t-shirts
To remove the category “clothing” and its children, action will be as follows:
actions:
- type: remove
field: categories
items:
- clothing
include_children: true
To unclassify products from the whole “Master catalog” tree, action will be as follows:
actions:
- type: remove
field: categories
items:
- master
include_children: true
Warning
In order to fully unclassify a product (i.e. remove all its categories, from every category tree), it is far more efficient to use a set action:
actions:
- type: set
field: categories
value: []
Concatenate¶
This action concatenates at least two blocks into a single value. A block can be an attribute value or a text. You can also use the specific new_line block to start a new line.
- The possible attribute types are:
text
text area
date
identifier
metric
number
price collection
simple select
multi select (values are separated by a comma)
reference entity single link
reference entity multiple links (values are separated by a comma)
- The possible target attribute types are:
text
textarea
By default, a space is added between two attribute value blocks (not between an attribute and a text block, or between two text blocks). You can avoid this behavior by adding an empty text between the two attribute value blocks.
The parameters from and to are required in the format. Depending on the source attribute type, some optional keys can be set:
from |
List of sets for all blocks. A block must contain exactly one single key among the following ones, plus some extra keys defined later:
For localizable and/or scopable attributes:
For date attributes:
For price collection attributes:
For simple select, multi select, reference entity single link and reference entity multiple links attributes:
|
to |
One set of:
|
Tip
For instance, to concatenate the “Brand: ” text, the brand attribute (non-localizable and non-scopable), a line break, the “Model: ” text and the model attribute in en_US locale into the description value in en_US locale, the action will be as follows:
actions:
- type: concatenate
from:
- text: "Brand: "
- field: brand
- new_line: ~
- text: "Model: "
- field: model
locale: en_US
to:
field: description
locale: en_US
To concatenate the model in en_US locale, the color in en_US locale and the year of the release date into the title value in en_US locale, the action will be as follows:
actions:
- type: concatenate
from:
- field: model
locale: en_US
- field: color
- field: release_date
format: Y
to:
field: title
locale: en_US
To build the text “[model], only for [price-in-usd-for-mobile-channel]$!” into the subtitle value in en_US locale and mobile channel, the action will be as follows:
actions:
- type: concatenate
from:
- field: model
locale: en_US
- text: ", only for "
- field: price
scope: mobile
currency: USD
- text: "$!"
to:
field: subtitle
locale: en_US
scope: mobile
Clear¶
This action clears the value(s) assigned to an attribute, product categories, product groups, or product associations.
- The expected values are:
field: attribute code, “categories”, “groups” or “associations”.
locale: the locale code for which the value is assigned (optional).
scope: the channel code for which the value is assigned (optional).
Tip
For instance, to clear the brand in en_US locale, the action will be as follows:
actions:
- type: clear
field: brand
locale: en_US
To clear all the categories linked to products, the action will be as follows:
actions:
- type: clear
field: categories
To clear all the product associations, the action will be as follows:
actions:
- type: clear
field: associations
Calculate¶
This action allows calculating numeric attribute values, with simple mathematical operations (addition, subtraction, multiplication, and division)
This action only accepts number, measurement or price collection attributes for both the source and the destination.
The action is split into 3 required steps, and 1 optional:
destination: the value you want to update. It is composed of:
field: the attribute code (required)
locale: locale code if the attribute is localizable (optional)
scope: channel code if the attribute is scopable (optional)
currency: currency code if the attribute is a price collection (optional)
unit: unit code if the attribute is a measurement (optional, the default measurement unit of the attribute will be used if not set)
source: the first operand of the operation. It requires at least either a value or a field and additional items. For instance, you can have:
value: a constant numeric value - decimal separator: dot, no thousands separator, e.g:
1515.14
(required)
OR:
field: attribute code of the source value (required)
locale: locale code if the attribute is localizable (optional)
scope: channel code if the attribute is scopable (optional)
currency: currency code if the attribute is a price collection (optional)
operation_list: the list of operations to execute (at least one operation is required)
It is exactly the same format as the source
property, with an additional required field:
operator: can be either
add
,subtract
,multiply
ordivide
(required)Warning
The operations are applied in the order they are provided, regardless of any mathematical priority. For instance, 5 - 3 + 2 x 5 will result in ((5 - 3) + 2) x 5) = 20
If a product value required in an operation is empty, or if a division by zero occurs, the product won’t be updated.
round_precision (optional): rounds the final result of the operation(s)
If this parameter is not specified or if the value is null, the final result will not be rounded. The round precision can be:
a positive number: it represents the number of decimals to keep
0: rounded with no decimal
a negative number: the rounding will occur before the decimal point (example with precision of -1: 81 becomes 80, with precision of -2: 81 becomes 100)
If the destination attribute does not allow decimals, the action can be applied only when the result is an integer. This behavior can be changed by setting up the round_precision to 0: the result will be rounded and the action will be applied.
Tip
For instance, in order to calculate the volume of a cone (volume = (π x R² x h) / 3), given a radius and a height, you can use the following action:
actions: - type: calculate destination: field: volume unit: CUBE_CENTIMETER source: value: 3.14 operation_list: - operator: multiply field: radius - operator: multiply field: radius - operator: multiply field: height - operator: divide value: 3
The following action will calculate a price in euros, based on the price in dollars and a ratio, and round the result to the nearest integer value:
actions: - type: calculate round_precision: 0 destination: field: price scope: ecommerce currency: EUR source: field: price scope: ecommerce currency: USD operation_list: - operator: multiply field: ratio
Warning
When using measurement attributes, their value will be converted to the default measurement unit defined for the attribute. For instance, a Length attribute can have a ‘CENTIMETER’ default unit and yet its value for the product is 1 INCH. In that case, the value will be converted to 2.54 (1 inch = 2.54 cm).
Warning
Also, no consistency check is performed regarding the units, you can perfectly multiply a frequency by a length, and put the result in a price attribute, even if it makes no sense :)
Fields¶
Created¶
Operator |
|
Value |
date format:
If the operator is EMPTY or NOT EMPTY, the value will be ignored. The “relative date format” only works with the <, >, = and != operators |
Examples |
- field: created
operator: =
value: "2015-01-23 00:00:00"
- field: created
operator: <
value: "-10 days"
|
Updated¶
Operator |
|
Value |
date format:
If the operator is EMPTY or NOT EMPTY, the value will be ignored. The “relative date format” only works with the <, >, = and != operators |
Examples |
- field: updated
operator: =
value: "2015-01-23 00:00:00"
- field: updated
operator: >
value: "-1 year"
|
Note
The “relative date format” allows to specify dates that are relative to the rule execution’s date, it is formatted as follows:
<+/-><count> <unit>, with:
“+” means a date in the future, “-” a date in the past
count is an integer
unit is one of the following values: minute, hour, day, week, month or year with an optional final s
For instance, +1 month means in one month, and -2 days means 2 days ago
Warning
Obviously, for the “created” and “updated” properties, the only relevant relative date format is the “past” relative date
Enabled¶
Operator |
|
Value |
activated => “true” deactived => “false” |
Example |
field: enabled
operator: =
value: false
|
Completeness¶
Operator |
|
Value |
Percentage. /!\ locale and scope elements are mandatory. |
Example |
field: completeness
locale: fr_FR
scope: print
operator: =
value: "100"
|
Family¶
Operator |
|
Value |
Family code. If operator is EMPTY or NOT EMPTY, value element will be ignored. |
Example |
field: family
operator: IN
value:
- camcorders
- digital_cameras
|
Family variant¶
Operator |
|
Value |
Family variant code. If operator is EMPTY or NOT EMPTY, value element will be ignored. |
Example |
field: family_variant
operator: IN
value:
- clothing_by_color
- shoes_by_size
|
Entity Type¶
Operator |
|
Value |
FQCN of the entity. It can be either
|
Example |
field: entity_type
operator: =
value: Akeneo\Pim\Enrichment\Component\Product\Model\ProductInterface
|
Parent¶
Operator |
|
Value |
Product model codes. If operator is EMPTY or NOT EMPTY, value element will be ignored. |
Example |
field: parent
operator: IN
value:
- model_pants_blue
- model_pants_black
|
Groups¶
Operator |
|
Value |
Group code. If operator is EMPTY or NOT EMPTY, value element will be ignored. |
Example |
field: groups
operator: IN
value:
- oro_tshirts
- akeneo_tshirts
|
Categories¶
Operator |
|
Value |
Category code |
Example |
field: categories
operator: IN
value:
- C0056
- F677
|
Attribute Types¶
Text / Textarea¶
Operator |
|
Value |
Text, with or without quotation marks. If operator is EMPTY or NOT EMPTY, value element will be ignored. |
Example |
field: description
operator: CONTAINS
value: "Awesome product"
|
Metric¶
Operator |
|
Value |
Numeric value and measure unit code. Dot “.” is the decimal separator. No space between thousands. If operator is EMPTY or NOT EMPTY, value element will be ignored. |
Example |
field: weight
operator: =
value:
amount: 0.5
unit: KILOGRAM
|
Boolean¶
Operator |
|
Value |
Yes => “true” No => “false” |
Example |
field: shippable_us
operator: =
value: false
|
Simple select list / Reference entity single link¶
Operator |
|
Value |
Option code. If operator is EMPTY or NOT EMPTY, value element will be ignored. NOT IN (red, blue) means != red and != blue. |
Example |
field: size
operator: IN
value:
- xxl
|
Multiselect List / Reference entity multiple links¶
Operator |
|
Value |
Option code. If operator is EMPTY or NOT EMPTY, value element will be ignored. NOT IN (red, blue) means != red and != blue. |
Example |
field: material
operator: IN
value:
- GOLD
- LEATHER
|
Number¶
Operator |
|
Value |
Number. If operator is EMPTY or NOT EMPTY, value element will be ignored. |
Example |
field: min_age
operator: =
value: 12
|
Date¶
Operator |
|
Value |
date format:
If the operator is EMPTY or NOT EMPTY, the value will be ignored. The “relative date format” only works with the <, >, = and != operators |
Examples |
- field: release_date
operator: =
value: "2015-01-23"
- field: creation_date
operator: >
value: "-6 months"
|
Note
The “relative date format” allows to specify dates that are relative to the rule execution’s date, it is formatted as follows:
<+/-><count> <unit>, with:
“+” means a date in the future, “-” a date in the past
count is an integer
unit is one of the following values: day, week, month or year with an optional final s
For instance, +1 month means in one month, and -2 days means 2 days ago
Warning
The calculated dates are relative to the current UTC date.
Price¶
Operator |
|
Value |
Numeric value and currency code. Dot “.” is the decimal separator. No space between thousands. If operator is EMPTY or NOT EMPTY, value element will be ignored. |
Example |
field: basic_price
operator: <=
value:
amount: 12
currency: EUR
field: null_price
operator: NOT EMPTY
value:
amount: null
currency: EUR
|
Picture or file¶
Operator |
|
Value |
Text. If operator is EMPTY or NOT EMPTY, value element will be ignored. |
Example |
field: small_image
operator: CONTAINS
value: ../../../
src/PimEnterprise/Bundle/
InstallerBundle/Resources/
fixtures/icecat_demo/images/
AKNTS_PB.jpg
|
Found a typo or a hole in the documentation and feel like contributing?
Join us on Github!