Mapping Adobe Commerce Configurable Products with Akeneo Product Models
In the context of the Akeneo Connector for Adobe Commerce, Adobe Commerce configurable products are linked to Akeneo Product Models. This connection is established through a mapping process, which ensures that the two systems work harmoniously. Here is how the mapping is done :
Product models with 1 level of variation
- PIM product models common layer is mapped with Adobe Commerce Configurable product
- PIM product models variation level 1 part is mapped with Adobe Commerce Simple product
Product models with 2 levels of variation
As Adobe Commerce only manages 1 level of variation, for PIM Product models with 2 levels of variation, Akeneo Connector for Adobe Commerce concatenates attribute data from common and level 1 layer of product models.
The impact for mapping is as follows:
- PIM product models common part + variation level 1 are mapped with Adobe Commerce Configurable product
- PIM product models variation level 2 is mapped with Adobe Commerce Simple products
Feel free to explore this informative PIM article for a deeper understanding of product models and variations, specifically focusing on how they relate to products with variants. For further insights, refer to the article titled : What about products with variants?
Configurable product attributes and default values
Within the connector configuration page, in Products, you have the flexibility to establish distinct rules for PIM attributes that you intend to import into Adobe Commerce for your configurable products. This empowers you to specify how these attributes should function within the context of configurable products.
| Connector parameter | Attribute | Type | Value |
|---|---|---|---|
| Configurable | Attribute code | Type from the list (see "Types" below) | Value (can be empty) |
Starting from version 100.2.6 of the Akeneo Connector for Adobe Commerce, the Type column has been introduced to enhance the management of configurable product attributes and ensure better clarity in their configuration.
Types:
First Variation value
Declare each PIM variation specific attributes you want to be imported in the Adobe Commerce configurable products. The value of the first variation associated to the product model will be inserted in the corresponding Adobe Commerce configurable product attribute. Leave the value field empty.
Example: First Variation value - Import weight from first variation
| Connector parameter | Attribute | Type | Value |
|---|---|---|---|
| Configurable | PIM "weight" attribute ID (ex: weight) | First Variation value | Empty |
It will import the weight of the first variation associated to your product model in the configurable product in Adobe Commerce
Mapping
Declare each PIM common attributes you want to be mapped with another Adobe Commerce attribute. Fill the value field with the corresponding Adobe Commerce attribute. Example: Attribute = name_product_model and Value = name
Example: Mapping - Map a product model common attribute to an Adobe Commerce name attribute
| Connector parameter | Attribute | Type | Value |
|---|---|---|---|
| Configurable | PIM "product name" attribute ID (ex: product_model_name) | Mapping | Adobe Commerce "product name" attribute ID (ex: name) |
If a variation specific attribute is already mapped with the Adobe Commerce "name" attribute in the "Attribute mapping" section, both mappings will be applied respectively.
If you map a variation specific attribute and a product model common attribute to the same attribute in Adobe Commerce, please make sure that those two attributes are configured the same way in Akeneo for: Value per channel and Value per locale.
SQL Statement
Use a SQL statement in the value field for custom value assignation from Akeneo Connector temporary tables. Example: Attribute = url_key and Value = LOWER(url_key)
Example: SQL statement to manipulate configurable product attribute value
You can set an SQL statement in the value column to manipulate a Adobe Commerce configurable product attribute value from the connector import tables. The alias for product model table is "v." and the one for temporary table is "e."
| Connector parameter | Attribute | Type | Value |
|---|---|---|---|
| Configurable | PIM "weight" attribute ID (ex: weight) | SQL Statement | SQL statement (ex: e.weight/1000) |
Default value
Fill the value field to assign a constant default value for a given attribute. Example: Attribute = is_new and Value = 0
Example: Set default value to a Adobe Commerce configurable product attribute - Disable all configurable products
Use the value column to force the value for all configurable products for a specific attribute.
| Connector parameter | Attribute | Type | Value |
|---|---|---|---|
| Configurable | is_new | Default value | 0 |
Product Model value
Deprecated since version 101.0.0
Declare each PIM common attributes you want to be imported in the Adobe Commerce configurable products. Leave the value field empty.
Example: Product Model value - Declare PIM common attributes to be imported to configurable products
| Connector parameter | Attribute | Type | Value |
|---|---|---|---|
| Configurable | PIM "product name" attribute ID (ex: name) | Product Model value | Empty |
If the "name" attribute is filled in your product model, it will be set to the configurable product.
Before the 101.0.0 version of the Akeneo Connector for Adobe Commerce, if a product model common attribute was not defined in the attribute column, it would not be imported for the configurable product.
Visibility mapping
Adobe Commerce has a native “visibility” attribute which defines where the product is visible on the website.
To know how to manage Product models and Product variants visibility, please refer to this article as the feature impacts all product types: Map products
Find my product models on Adobe Commerce
To find your product models on Adobe Commerce :
- Open Adobe Commerce CATALOG menu
- Click on Products
All product types are displayed together.
