After creating your product catalogs in your activation channel, you can now use your Product Information Management (PIM) system as the main source of truth. This allows you to easily choose, organize, and adjust your product data to meet the specific requirements of the retailer or marketplace.
Overview
The outcome of this functionality is an export of product information from your PIM to your activation channel, making it ready to use. It helps you select, map, and transform your product information to comply with the requirements of retailers or marketplaces.
For example, consider a scenario where multiple retailers require product information but with different attribute structures:
- Retailer A requires the following attributes: "Identifier," "Product Name," "Description," and "Weight (Ounces)."
- Retailer B requires attributes such as "Name in French," "Name in English," "Description 1," "ID," and "Weight (Kilograms)."
From the mapping screen, you can easily and efficiently transform your data using Excel-like functions to meet the unique requirements of each retailer.
The catalog mapping screen in your PIM is automatically synchronized with the activation app, ensuring you always have the latest set of channel requirements. This process can be repeated as often as needed, eliminating the need for manual mapping adjustments every time you export products to a retailer.
Activation and Catalogs for Apps
The Activation app uses the catalogs for apps technology to power its mapping and transformation solution. You will see references and links to the catalogs for apps documentation on this page
Product Information Mapping screen
After creating your product catalogs in the Akeneo Activation app, selecting "Go to Mapping" for a specific catalog will take you directly to the catalog mapping interface within your PIM.
Configure the product data mapping
On the Mapping and Filtering screen, you can choose which products to export and refine your selection using filters. Here, you can also create the structure of your mapping and transform your PIM data.
For any catalog created in your activation channel, you can view the requirements (the list of required and optional attributes) from retailers or marketplaces. This allows you to accurately map and transform the data to meet the specific attributes required by the retailer.
Here are the main features available on the mapping screen:
- Target Name: Corresponds to the expected attribute as specified by the retailer or marketplace.
- Attribute Types: Easily distinguishable by icons next to their names, such as Text, Price, Image, or Measurement.
- Attribute Count: Displays the total number of attributes specific to a given family on the retailer or marketplace.
- Attribute Indicators: Yellow dots indicate required or conditionally required attributes. Conditionally required attributes may not always be obligatory, depending on other attribute values. Once filled, the yellow dot turns green, signifying a fully mapped attribute. Optional attributes do not have colored dots.
- Search Function: Quickly locate a particular attribute by entering its name, even partially, in the search bar.
- Source Information: Shows the source from the PIM that will be used to populate the retailer or marketplace attribute requirements.
- Requirements Helpers: Enable you to select the most appropriate source for each attribute. This information is derived from the retailer or marketplace-specific requirements for a given attribute, facilitating accurate mapping and data transformation.
- Source Designation: For each attribute, you must designate one or more sources by choosing from a dropdown list of attributes from your PIM. The available options may vary depending on the selected attribute, with further operations explained subsequently.
- Source Removal: You can remove a source, allowing you to refine the mapping as needed.
- Save Configuration: Upon completing the mapping and transformation process, clicking the "Save" button will preserve the entire configuration in your PIM, ready to be exported to the retailer or marketplace.
Errors on mapping
While mapping your products, if there are issues with the data you are trying to map and transform, error messages will appear, and red dots will be displayed next to the affected attributes.
Define your export data structure
Targets
We display the retailer or marketplace expected attribute type with iconography to make it easier for you to understand the retailer or marketplace expectations:
- String
- Boolean
- Integer
- Number
- Date
- Url/Links (sometimes used to send images)
- String collection
- Asset Collection
- Measurement
- Price
- Limited List of String (possible values)
Sources
The available list of attributes for the source depends on the format expected by the retailer or marketplace
- Adding a source means selecting an attribute, a system property, or an association type
- You won’t be able to select a string if the retailer or marketplace expects a date for instance
- The goal is to improve the data quality on every channel
- You can add any attribute type from the PIM except the table attribute
- You can add association types: via product SKU or product model code
- You can add PIM properties (family, enabled, categories, identifier)
- You can generate static values
- We can have up to 5 sources per target if you want to concatenate
- Sometimes, based on the retailer or marketplace requirement, possible values are provided to help with the data mapping and transformation (see example below). For a given attribute target, these values are the only values accepted by the retailer/marketplace
- Sometimes, based on the retailer or marketplace requirement, suggested values are provided to help with the data transformation
Source attribute compatibility scenarios while mapping your PIM data
Target attribute expected format | Suggested PIM attribute type and properties |
---|---|
String |
Categories Enabled Family Parents Family variant Quality score Code Reference Entity Single Links Reference Entity Multiple Links Asset Collection Boolean (Yes/No) Date File Identifier Image Measurement Simple Select Multi-select Number Price collection Table Text Text Area |
Limited List of String |
Code Family Simple Select Text Text Area |
String Collection |
Categories Reference Entity Multiple Links Multi-select Text Text Area |
Boolean |
Yes/No |
Number |
Number Simple Select Measurement |
Integer |
Number Simple Select Measurement |
Measurement |
Measurement |
URLs (links) |
Text Image Asset Collection |
Price |
Price Collection |
Once you've added a source, different options are available depending on the attribute you selected. If your attribute has a value per locale or channel, you may need to select which channel and/or locale you want the data to be exported from. For some attributes, additional options are available. For instance, you can choose between exporting the code or the label of the attribute option and select a separator (comma, semi-colon, pipe) if applicable.
For more details on currency, variations mapping, replacement values and sources refer to this article.
Working with data transformation operations on sources
To ensure your PIM data matches what retailers and marketplaces expect, you can use scalable and powerful operations to transform your data.
To do so, you can use the Transformation section. or the mapping screen. Refer to this article for more details.
Operation depends on the selected source attributes. We leverage an easy to use DSL (Domain Specific Language) to give you maximum flexibility when transforming your data. Please review the Akeneo function list page to learn more about transformation functions.
For Activation channels still on the legacy mapping systems, the below operations remain available
Boolean: Yes/No replacement
Replace the default values with your value (only available for the "Yes/No" attribute or the "Enabled" system property).
Replacement values are case-sensitive.
Replacement
Replace the values with your own (only available for simple select, multi-select, reference entities single link or multiple link attributes).
Replacement values are case-sensitive.
Use default value when empty
Define a default value when the source value is empty.
Conversion
Convert measurement units within the same measurement family (only available for measurement attributes used as a source).
Rounding
Round measurement values, choosing from Round, Roundup & Round down, and define the number of digits - up to 12 - after the decimal separator (only available for measurement attributes used as a source).
Concatenation
Concatenate different sources by displaying up to 4 per column. Click on Add text to add more details and create a separation between sources.
Clean HTML tags
Clean all the HTML tags automatically in your text attributes used as a source.
If you added a default value with HTML tags thanks to the Use default value when empty operation, and if you checked Clean HTML tags for the same source, this operation won't clean the HTML tags for the default value.
Truncate
Truncate automatically the value in your text attributes used as a source. You can select after which character you would like to truncate
Case change
You can change the casing of the value in your text attributes used as a source. The different options are available to you:
- Keep current case
- Upper case
- Lower case
- Capital case
- Sentence case
Selection
Select the format of the value you want to map. For instance, you can select the label, code, separator, etc. This operation will allow you to decide exactly what product information you want to transform for each source.
Decimal separator and Separator are two different options. The first one helps you to separate your figures with a dot, a comma, or the Arabic decimal separator. The second one helps you to separate a collection of values for the same attribute; for instance, if you export multiple assets, you can separate them with a comma, a semi-colon, or a pipe.
Configure your catalog product selection
From the filtering screen, you can add selection criteria to create your product selection for the particular family of products you are working with.
By default, your entire product catalog will be selected (the amount of products will be displayed in the top part of the screen)
In clicking “the add selection criteria”, you can filter your selection by the same attribute sources that are available in the mapping screen.
Ex: you can filter by Status, Category, or Family, and add conditions and rules to fetch only specific products.
Refer to this article or more details on the filtering capabilities.
Same product in more than one catalog
We do NOT recommend having the same product in more than one catalog's selection as this creates a risk of overwriting the information when exporting the catalogs to the channel
Once you're done with your selection, mapping, and transformation, enable your catalog and click on Save in the top right corner. This will save your family catalog mapping for the Activation channel you are currently working with. Then, you can go back to the Akeneo Activation, you are ready for the next steps: export your product catalog(s).