How to configure products?
#"Attribute type" mapping
By default, Akeneo Connector for Magento 2 supports all native PIM attribute types. In addition, you could still map a PIM attribute type and a Magento attribute type in the event of a custom attribute type in your PIM.
Do not map native Akeneo attribute types with native Magento types, as this mapping will automatically be handled by the Connector. This mapping is only necessary for custom Akeneo attribute types.
In the connector configuration page, in Attributes, you can choose how to convert some specific PIM attribute types to Magento attribute types:
| Connector parameter | PIM Information | Magento information |
|---|---|---|
| Additional types | PIM attribute type ID | Magento attribute type |
For example, you can manage the Flagbit or Webkul table attribute bundles and retrieve table attribute JSON structure as a Magento 2 text area attribute type.
For Webkul table attribute:
| Connector parameter | PIM Information | Magento information |
|---|---|---|
| Additional types | pim_catalog_table | Text area |
For Flagbit table attribute:
| Connector parameter | PIM Information | Magento information |
|---|---|---|
| Additional types | flagbit_catalog_table | Text area |
#"Website" attribute mapping
Since the 100.2.1 version of the Akeneo Connector for Magento 2, you can choose how to associate your products to your websites using a select or multiselect attribute in the connector configuration page, in Products:
| Connector parameter | Magento information |
|---|---|
| Website Attribute | PIM "website association" attribute ID (ex: website_association) |
The attribute code given must be a valid Akeneo select or multiselect attribute.
The code of its options in Akeneo must match your Magento 2 websites codes.
You can find your Magento 2 websites codes in Store > Configuration.
Before the 101.0.0 version of the Akeneo Connector for Magento 2, do not forget to add all attributes responsible for the website association to the list of Configurable attributes
You can find that list under Configuration -> Akeneo Connector -> Products -> Configurable.
Your products will be assigned to the websites selected in the given attribute. If the value for this attribute is empty for a product, it won't be assigned to any website.
If this configuration is empty, your products will be assigned automatically following your Website Mapping found in Akeneo API Configuration.
#Default product status
Since the 100.4.2 version of the Akeneo Connector for Magento 2 (CE & EE), you can choose to enable or disable new products in the connector configuration page, in the Products section.
During product updates, already imported products will keep their old status, unless the product is disabled in Akeneo PIM.
| Connector parameter | Magento information |
|---|---|
| Enable new products | Yes or No |
If a product is "enabled" in Akeneo PIM, it will be created with the status defined in the configuration.
During updates, his current status won't be modified.
If a product is "disabled" in Akeneo PIM, it will be disabled in Magento 2, regardless of the configuration.
Akeneo PIM "enabled" status is a system attribute value that should not define the activation of a product in Magento 2.
#"Attribute" mapping
In the connector configuration page, in Products, you can choose how to map a PIM attribute with a Magento attribute:
| Connector parameter | PIM Information | Magento information |
|---|---|---|
| Attribute mapping | PIM attribute ID | Magento attribute ID |
You don't need to map attributes with the same code in Akeneo and Magento 2, the Connector will automatically transfer the data without mapping.
This mapping only copies the value from an attribute to another. Make sure to map two attributes of the same type.
Example: My Akeneo description attribute doesn't have the same code than the Magento 2 description attribute
If your description attribute in Akeneo is called "description_web", you can map the native Magento 2 "description" attribute with your "description_web" attribute from Akeneo in the mapping as follows:
| Connector parameter | PIM Information | Magento information |
|---|---|---|
| Attribute mapping | PIM "description" attribute ID (ex: description_web) | description |
Example: SEO - How to set a product name as a URL?
Set the "Attribute mapping" parameter as follows:
| Connector parameter | PIM Information | Magento information |
|---|---|---|
| Attribute mapping | PIM "product name" attribute ID (ex: name) | url_key |
#Metric Attributes
Since the 100.3.0 version of Akeneo Connector for Magento 2 in the connector configuration page, in Products, you can configure the behavior of your Metric attributes :
| Connector parameter | Akeneo Metric Attribute | Used As Variant | Concat Metric Unit |
|---|---|---|---|
| Metric Attributes | PIM attribute ID | Set to "Yes" if the metric attribute is used as a variant | Set to "Yes" if you want to concat the metric unit to the value imported in Magento 2 |
By default, if a Metric attribute is not declared in this configuration, it will be created as a Text attribute in Magento 2 containing the numeric metric value.
It won't be usable as a variant.
Setting an Akeneo Metric attribute as variant will make this attribute a Select attribute in Magento 2.
Options will be dynamically added during product import and will either contain the metric unit or not depending on the value of the "Concat Metric Unit" field.
Setting the Concat Metric Unit option to "Yes" will work for both metric attributes created as Text attribute and Select attribute.
If you already imported a Metric attribute as a Text attribute in Magento 2, you will not be able to configure it as a variant attribute and change its type to Select attribute.
To do so, you will have to delete the previously imported attribute and import it again.
#Default tax class for a Website
In the connector configuration page, in Products, you can choose the default tax class for a specific Magento 2 Website:
| Connector parameter | Magento information |
|---|---|
| Default Tax Class | None |
| Taxable Goods | |
| Refund Adjustments | |
| Gift Options | |
| Order Gift Wrapping | |
| Item Gift Wrapping | |
| Printed Gift Card | |
| Reward Points |
Custom tax classes created in Magento 2 will automatically appear in this field so you can assign them to your products.
#Configurable product attributes and default values
In the connector configuration page, in Products, you can define additional rules for PIM attributes you want to import in the Magento 2 configurable products.
| Connector parameter | Attribute | Type | Value |
|---|---|---|---|
| Configurable | Attribute code | Type from the list (see "Types" below) | Value (can be empty) |
Since the 100.2.6 version of the Akeneo Connector for Magento 2, the Type column has been added to this configuration in order to provide better understanding and management of configurable product attributes.
Types:
- (Deprecated since version
101.0.0)Product Model value: Declare each PIM common attributes you want to be imported in the Magento configurable products. Leave the value field empty. First Variation value: Declare each PIM variation specific attributes you want to be imported in the Magento configurable products. The value of the first variation associated to the product model will be inserted in the corresponding Magento configurable product attribute. Leave the value field empty.Mapping: Declare each PIM common attributes you want to be mapped with another Magento attribute. Fill the value field with the corresponding Magento attribute. Example: Attribute = name_product_model and Value = nameSQL 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)Default value: Fill the value field to assign a constant default value for a given attribute. Example: Attribute = enabled and Value = 0
(Deprecated since version 101.0.0) 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 Magento 2, if a product model common attribute was not defined in the attribute column, it would not be imported for the configurable product.
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 Magento
Example: Mapping - Map a product model common attribute to Magento name attribute
| Connector parameter | Attribute | Type | Value |
|---|---|---|---|
| Configurable | PIM "product name" attribute ID (ex: product_model_name) | Mapping | Magento "product name" attribute ID (ex: name) |
If a variation specific attribute is already mapped with the Magento "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 Magento, please make sure that those two attributes are configured the same way in Akeneo for: Value per channel and Value per locale.
Example: Set default value to a Magento 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 | enabled | Default value | 0 |
Example: SQL statement to manipulate configurable product attribute value
You can set an SQL statement in the value column to manipulate a Magento configurable product attribute value from the connector import tables. Alias for product model table is "v." and alias 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) |
#Configure Related, Upsell and Cross-sell products
Since the 101.2.0 version of the Akeneo Connector for Magento 2, you can configure the code of the associations to map with Related, Upsell and Cross-sell products in Products:
| Connector parameter | PIM information |
|---|---|
| Akeneo association code for Related products | Association code from Akeneo |
The default value for this configuration is: SUBSTITUTION
| Connector parameter | PIM information |
|---|---|
| Akeneo association code for Upsell products | Association code from Akeneo |
The default value for this configuration is: UPSELL
| Connector parameter | PIM information |
|---|---|
| Akeneo association code for Cross-sell products | Association code from Akeneo |
The default value for this configuration is: X_SELL
This configuration cannot handle quantity associations, please only use 2-way associations or default associations
To know how to manage association with quantity, please read this documentation.
#Product Model Batch Size and Product Model Update Length
These configurations has been removed since the 101.0.0 version of the Akeneo Connector for Magento 2 due to the Family by Family import for product models that gathers the data automatically
From the 100.3.3 to before the 101.0.0 version of the Akeneo Connector for Magento 2, you can adjust Product Model Batch Size and Product Model Update Length to prevent database limitations from happening.
In the case of catalogs with a huge number of attributes and product models, some users might have experienced MYSQL errors related to the size of the updates during the Product Model import job. Those configurations allow you to manage the size of Product Model import batches and the size of the MYSQL updates statements.
Product Model Batch Size
Product Model Batch Size will define the number of Product Models inserted / updated during each database update.
Setting this configuration to 1 will import product models one by one and reduce the amount of data sent to MYSQL during each batch.
Setting this configuration to 0 will import product models one by one, reduce the amount of data sent to MYSQL during each batch and slice each database update with the length defined in the Product Model Update Length configuration.
The default value for this configuration is: 500
Product Model Update Length
If the above Product Model Batch Size value is set to 0, the database command to insert product models will be sliced into separate statements no bigger than the given value.
Slicing database updates will also reduce the size of each updates and prevent potential MYSQL limitations regarding row sizes.
The value for this configuration must be superior to 1000.
The default value for this configuration is: 5000
#Import file attributes
Since the 100.4.2 version of the Akeneo Connector for Magento 2, you can enable the download of your file attributes from Akeneo PIM to Magento 2.
| Connector parameter | Magento information |
|---|---|
| Import File Attributes | Yes or No |
After enabling file attributes import, you have to choose which attributes you want to download in the "Akeneo File Attributes" configuration :
| Connector parameter | Akeneo Attribute |
|---|---|
| Akeneo File Attributes | Attribute code of the File attribute(s) to download |
All files will be downloaded in the "pub/media/akeneo_connector/media_files" folder. The Magento media_files path will be linked at a text attribute to the corresponding products.
The path of each file will be imported to the corresponding product text attribute in your products.
If "Import File Attributes" is disabled, the connector won't override previously imported values from your file attributes declared in "Akeneo File Attributes"
#Does Akeneo data override content staging
Since the 100.5.2 version of the Akeneo Connector for Magento 2 (the 100.4.4 version for the Community Edition), you can configure the connector's behavior depending on Magento 2 content staging feature , in the connector configuration page, in Products:
| Connector parameter | Magento information |
|---|---|
| Does Akeneo data override content staging | Yes or No |
Note that this parameter will only be relevant on Magento 2 Enterprise Edition, as the content staging feature is specific to this version.
Magento 2 content staging is used to create scheduled versions of products.
If set to Yes, Akeneo PIM data will override all product versions no matter what changes was scheduled.
Products will still have scheduled versions in Magento 2, but if an attribute in Akeneo PIM has been modified in the scheduled versions, the value will be overridden by the data imported from Akeneo PIM.
If set to No, Akeneo PIM data will only update the "base" version of the products and not the scheduled versions.
#Regenerate URL rewrites
In the connector configuration page, in Products, you can enable to regenerate URL rewrites for Magento 2 products:
| Connector parameter | Magento information |
|---|---|
| Regenerate URL rewrites | Yes or No |