Fetching Product Data from Akeneo to Alumio

Fetching Variants of Product from Akeneo

In Alumio, go to “Integrations → Incoming → Akeneo - Fetch - Products with parent”. We defined variants as the product of a product model. Before we fetch the product model in Akeneo, we need to prepare the variants first (the product of the product model). This Incoming is designed to get products in Akeneo that have parent, so we can be sure this will be a variant from the product model. This Incoming will not create any task but will update the storage of “Akeneo - Update Storage - Product Model Variants - Alumio Base Product” with a list of product data in Alumio base product data.

Akeneo - Prepare Convert - Localizations filter This transformer is configured to permit locales associated with the “eCommerce” channel code. If you require additional channels, please update the values in the Node filter.

Akeneo - Prepare convert - Values - To localizations and custom attributes

This transformer will convert localizations data from Akeneo.
Akeneo giving us some localizations that look like this.

{
  "data": "Samsung Galaxy A5 (2017) SM-A520F 4G 32Go Or",
  "scope": null,
  "locale": "fr_FR",
  "attribute_type": "pim_catalog_text"
}

As this structure is not friendly to Shopware we need to convert them to a more workable structure, that is why we use this transformer to transform it into this instead

{
  "customAttributes": {
    "name": "Samsung Galaxy A5 (2017) SM-A5 ...",
    "form_factor_771": "Barre",
    "second_display_3989": "Non",
    "zoom_capability_472": "Oui"
  },
  "localeCode": "fr_FR"
}

Akeneo - Prepare convert - Product and product model - Categories to Alumio Base

This transformer will convert categories data from Akeneo.
Akeneo giving us some categories that look like this.

{
  "categories": [
    "samsung",
    "smartphones"
  ]
}

As this structure is not friendly to Shopware we need to convert them to a more workable structure, that is why we use this transformer to transform it into this instead

{
  "categories": [
    {
      "categoryCode": "samsung"
    },
    {
      "categoryCode": "smartphones"
    }
  ]
}

Akeneo - Prepare convert - Product and product model - Prices to Alumio Base

This transformer will convert prices data from Akeneo.
Akeneo giving us some prices that look like this.

{
  "price": [
    {
      "amount": "354.00",
      "currency": "EUR"
    },
    {
      "amount": "400.02",
      "currency": "GBP"
    },
    {
      "amount": "318.60",
      "currency": "USD"
    }
  ]
}

As this structure is not friendly to Shopware we need to convert them to a more workable structure, that is why we use this transformer to transform it into this instead

{
  "prices": [
    {
      "amount": "354.00",
      "currencyCode": "EUR"
    },
    {
      "amount": "400.02",
      "currencyCode": "GBP"
    },
    {
      "amount": "318.60",
      "currencyCode": "USD"
    }
  ]
}

Akeneo - Convert - Product - To Alumio Base product This transformer will convert Akeneo product data into Alumio base product data. An example of the Alumio base product data:

{
  "groups": [],
  "prices": [...],
  "categories": [...],
  "identifier": "35523802",
  "localizations": [...],
  "customAttributes": {...},
  "code": "35523802",
  "attributeSetCode": "smartphones",
  "parentCode": "SM-A520F",
  "statusCode": true
}

Akeneo - Update Storage - Product Model Variants - Alumio Base Product This transformer will create a list of variants from the Alumio base product. It will load the previous iteration of this transformer to merge the list or create a new list. Then the list of variants will be saved in the storage “Akeneo - Product Model variants - Alumio Base Product”.

Akeneo - Prepare update - Product Model Variants - Alumio Base Variant merge This transformer will merge the list of variants in the transformer “Akeneo - Update Storage - Product Model Variants - Alumio Base Product” to ensure there will be no duplication based on the product code.

Fetching Parent Product Model from Akeneo

In Alumio, go to “Integrations → Incoming → Akeneo - Product Models without parent”. Parent product model in Akeneo has a probability to have children, which is another product model or variant, which is the product of the product model. This Incoming is designed to get a list of product models that are the top parent or do not have a parent. This Incoming will not create any task but will update the storage of “Alumio - Product Model Parent - Alumio Base Product Model” with parent product model data in the Alumio base product model.

Akeneo - Prepare convert - Values - To localizations and custom attributes This transformer will convert localization data from Akeneo. An example of the Akeneo localizations:

{
  "data": "Samsung Galaxy A5 (2017) SM-A520F 4G 32Go Or",
  "scope": null,
  "locale": "fr_FR",
  "attribute_type": "pim_catalog_text"
}

Since the original data structure is incompatible with Shopware, we use this transformer to convert it into a more workable format.

{
  "customAttributes": {
    "name": "Samsung Galaxy A5 (2017) SM-A5 ...",
    "form_factor_771": "Barre",
    "second_display_3989": "Non",
    "zoom_capability_472": "Oui"
  },
  "localeCode": "fr_FR"
}

Akeneo - Prepare Convert - Localizations filter This transformer filters for localizations specifically associated with the “eCommerce” channel. If you require additional channels, please add the corresponding values to the Node filter.

Akeneo - Prepare convert - Product and product model - Categories to Alumio Base This transformer will convert category data from Akeneo. An example of the Akeneo categories:

{
  "categories": [
    "samsung",
    "smartphones"
  ]
}

Since the original data structure is incompatible with Shopware, we use this transformer to convert it into a more workable format.

{
  "categories": [
    {
      "categoryCode": "samsung"
    },
    {
      "categoryCode": "smartphones"
    }
  ]
}

Akeneo - Prepare convert - Product and product model - Prices to Alumio Base This transformer will convert price data from Akeneo. An example of the Akeneo price:

{
  "price": [
    {
      "amount": "354.00",
      "currency": "EUR"
    },
    {
      "amount": "400.02",
      "currency": "GBP"
    },
    {
      "amount": "318.60",
      "currency": "USD"
    }
  ]
}

Since the original data structure is incompatible with Shopware, we use this transformer to convert it into a more workable format.

{
  "prices": [
    {
      "amount": "354.00",
      "currencyCode": "EUR"
    },
    {
      "amount": "400.02",
      "currencyCode": "GBP"
    },
    {
      "amount": "318.60",
      "currencyCode": "USD"
    }
  ]
}

Akeneo - Convert - Product Model - To Alumio Base Product Model This transformer will convert Akeneo product model data into Alumio base product model data. An example of the Alumio base product model data:

{
  "code": "aphrodite",
  "prices": [
    {
      "amount": "299.00",
      "currencyCode": "EUR"
    }
  ],
  "categories": [
    {
      "categoryCode": "women_shirts"
    },
	...
  ],
  "localizations": [
    {...},
    {...}
  ],
  "customAttributes": {
    "washing": "70deg",
    "imported": false,
    "packshot": [...],
    "supplier": "zaro",
    "dry_clean": false,
    "collections": [...]
  },
  "attributeSetCode": "tops",
  "parentCode": null
}

Alumio - Fetch storage - Alumio Base Product Model attach variants This transformer will fetch the data of the variant that was created from the Incoming “Akeneo - Fetch - Products with parent” and attach it as a variant to the Alumio base product model.

{
  "variants": [
    {
      "identifier": "aphrodite_0",
      "categories": [...],
      "groups": [],
      "customAttributes": {...},
      "localizations": [...],
      "prices": [...],
      "code": "aphrodite_0",
      "statusCode": false,
      "attributeSetCode": "tops",
      "parentCode": "aphrodite"
    },
	...
  ]
}

Akeneo - Update storage - Product Model parent - Alumio Base Product Model This transformer will save the product model parent in the storage “Alumio - Product Model Parent - Alumio Base Product Model”.

Fetching Children Product Model from Akeneo

In Alumio, go to “Integrations → Incoming → Akeneo - Fetch - Product Models with parent”. After we got the parent and the variant for a product model, this is the time to fetch children, product model. This Incoming well get the product model with parent to become a children product model. This Incoming will not create any task but will update the storage of the parent at “Alumio - Product Model Parent - Alumio Base Product Model” with children product model data in the Alumio base product model. Akeneo - Prepare convert - Values - To localizations and custom attributes

This transformer will convert localizations data from Akeneo. An example of the Akeneo localizations:

{
    "data": "Samsung Galaxy A5 (2017) SM-A520F 4G 32Go Or",
    "scope": null,
    "locale": "fr_FR",
    "attribute_type": "pim_catalog_text"
}

Since the original data structure is incompatible with Shopware, we use this transformer to convert it into a more workable format.

{
  "customAttributes": {
    "name": "Samsung Galaxy A5 (2017) SM-A5 ...",
    "form_factor_771": "Barre",
    "second_display_3989": "Non",
    "zoom_capability_472": "Oui"
  },
  "localeCode": "fr_FR"
}

Akeneo - Prepare Convert - Localizations filter

We use this transformer to only allow any localization with a channel code in “eCommerce”, if it has the channel code. If you need another channel code, add the value in the Node filter.

Akeneo - Prepare convert - Product and product model - Categories to Alumio Base This transformer will convert category data from Akeneo. An example of the Akeneo categories:

{
  "categories": [
    "samsung",
    "smartphones"
  ]
}

Since the original data structure is incompatible with Shopware, we use this transformer to convert it into a more workable format.

{
  "categories": [
    {
      "categoryCode": "samsung"
    },
    {
      "categoryCode": "smartphones"
    }
  ]
}

Akeneo - Prepare convert - Product and product model - Prices to Alumio Base This transformer will convert price data from Akeneo. An example of the Akeneo price:

{
  "price": [
    {
      "amount": "354.00",
      "currency": "EUR"
    },
    {
      "amount": "400.02",
      "currency": "GBP"
    },
    {
      "amount": "318.60",
      "currency": "USD"
    }
  ]
}

Since the original data structure is incompatible with Shopware, we use this transformer to convert it into a more workable format.

{
  "prices": [
    {
      "amount": "354.00",
      "currencyCode": "EUR"
    },
    {
      "amount": "400.02",
      "currencyCode": "GBP"
    },
    {
      "amount": "318.60",
      "currencyCode": "USD"
    }
  ]
}

{
  "code": "aphrodite",
  "prices": [
    {
      "amount": "299.00",
      "currencyCode": "EUR"
    }
  ],
  "categories": [
    {
      "categoryCode": "women_shirts"
    },
	...
  ],
  "localizations": [
    {...},
    {...}
  ],
  "customAttributes": {
    "washing": "70deg",
    "imported": false,
    "packshot": [...],
    "supplier": "zaro",
    "dry_clean": false,
    "collections": [...]
  },
  "attributeSetCode": "tops",
  "parentCode": null
}

{
  "variants": [
    {
      "identifier": "aphrodite_0",
      "categories": [...],
      "groups": [],
      "customAttributes": {...},
      "localizations": [...],
      "prices": [...],
      "code": "aphrodite_0",
      "statusCode": false,
      "attributeSetCode": "tops",
      "parentCode": "aphrodite"
    },
	...
  ]
}

Akeneo - Filter and prepare update storage - Filter for product model without variants and update parent This transformer will filter the product model without a variant and will update the parent if not filtered.

Akeneo - Update storage - Alumio Base Product Model update children This transformer will update the parent product model inside the storage “Alumio - Product Model Parent - Alumio Base Product Model” with the product model provided in the data.

Fetching Simple Product from Akeneo

In Alumio, go to “Integrations → Incoming → Akeneo - Fetch - Products without parent”. There is some product data without a product model in Akeneo. This Incoming will duplicate the product data into the Alumio base product model and save it into the storage “Alumio - Product Model Parent - Alumio Base Product Model”. Akeneo - Prepare convert - Values - To localizations and custom attributes

This transformer will convert localizations data from Akeneo. An example of the Akeneo localizations:

{
    "data": "Samsung Galaxy A5 (2017) SM-A520F 4G 32Go Or",
    "scope": null,
    "locale": "fr_FR",
    "attribute_type": "pim_catalog_text"
}

Since the original data structure is incompatible with Shopware, we use this transformer to convert it into a more workable format.

{
  "customAttributes": {
    "name": "Samsung Galaxy A5 (2017) SM-A5 ...",
    "form_factor_771": "Barre",
    "second_display_3989": "Non",
    "zoom_capability_472": "Oui"
  },
  "localeCode": "fr_FR"
}

Akeneo - Prepare Convert - Localizations filter We use this transformer to only allow any localization with a channel code in “eCommerce”, if it has the channel code. If you need another channel code, add the value in the Node Filter.

Akeneo - Prepare convert - Product and product model - Categories to Alumio Base This transformer will convert category data from Akeneo. An example of the Akeneo categories:

{
  "categories": [
    "samsung",
    "smartphones"
  ]
}

Since the original data structure is incompatible with Shopware, we use this transformer to convert it into a more workable format.

{
  "categories": [
    {
      "categoryCode": "samsung"
    },
    {
      "categoryCode": "smartphones"
    }
  ]
}

Akeneo - Prepare convert - Product and product model - Prices to Alumio Base This transformer will convert price data from Akeneo. An example of the Akeneo price:

{
  "price": [
    {
      "amount": "354.00",
      "currency": "EUR"
    },
    {
      "amount": "400.02",
      "currency": "GBP"
    },
    {
      "amount": "318.60",
      "currency": "USD"
    }
  ]
}

Since the original data structure is incompatible with Shopware, we use this transformer to convert it into a more workable format.

{
  "prices": [
    {
      "amount": "354.00",
      "currencyCode": "EUR"
    },
    {
      "amount": "400.02",
      "currencyCode": "GBP"
    },
    {
      "amount": "318.60",
      "currencyCode": "USD"
    }
  ]
}

Akeneo - Convert - Product - To Alumio Base Product This transformer will convert Akeneo product data into Alumio base product data. An example of the Alumio base product data:

{
  "groups": [],
  "prices": [],
  "categories": [],
  "identifier": "35523802",
  "localizations": [],
  "customAttributes": {},
  "code": "35523802",
  "attributeSetCode": "smartphones",
  "parentCode": "SM-A520F",
  "statusCode": true
}

Akeneo - Convert - Alumio Base Product - To Alumio Base Product Model with variants This transformer copies the Alumio base product data into the Alumio base product model with a variant. We add the variant code with “-1” to avoid data duplication. An example can be found below:

{
  "code": "78409316",
  "groups": [],
  "prices": [...],
  "categories": [...],
  "identifier": "78409316",
  "parentCode": "78409316",
  "statusCode": true,
  "localizations": [
  	{...},
	{...}
  ],
  "attributeSetCode": "headphones",
  "customAttributes": {...},
  "variants": [
    {
      "code": "78409316-1",
      "groups": [],
      "prices": [...],
      "categories": [...],
      "identifier": "78409316",
      "parentCode": "78409316",
      "statusCode": true,
      "localizations": [...],
      "attributeSetCode": "headphones",
      "customAttributes": {...}
    }
  ]
}

Akeneo - Filter - Simple Product
We use this transformer to filter previously created task simple products to avoid duplication

Automatic Fetching Product Data from Akeneo to Alumio

In Alumio, go to “Integrations → Schedulers → Akeneo - Fetch complex products”.
Set a schedule expression and enable the configuration.

Templates

​Fetching Variants of Product from Akeneo

​Fetching Parent Product Model from Akeneo

​Fetching Children Product Model from Akeneo

​Fetching Simple Product from Akeneo

​Automatic Fetching Product Data from Akeneo to Alumio

Fetching Variants of Product from Akeneo

Fetching Parent Product Model from Akeneo

Fetching Children Product Model from Akeneo

Fetching Simple Product from Akeneo

Automatic Fetching Product Data from Akeneo to Alumio