Fetching Product Data and Family Attribute Axes from Akeneo to Alumio

Fetching Families and Attributes 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 a 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

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

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

This transformer will convert localizations data from Akeneo.

{
  "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 BigCommerce, we need to convert it to a more workable structure, which 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 category data from Akeneo.

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

As this structure is not friendly to BigCommerce, we need to convert it to a more workable structure, which 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 price data from Akeneo.

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

As this structure is not friendly to BigCommerce, we need to convert it to a more workable structure, which 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.

{
  "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.

{
  "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 BigCommerce, 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 BigCommerce, 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.

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

Since the original data structure is incompatible with BigCommerce, 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.

{
  "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.

{
    "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 BigCommerce, 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 converts category data from Akeneo.

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

Since the original data structure is incompatible with BigCommerce, 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 converts price data from Akeneo.

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

Since the original data structure is incompatible with BigCommerce, 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 converts Akeneo product model data into 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 fetches the data of the variant that was created from the Incoming “Akeneo - Fetch - Products with parent” and attaches 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 - Filter and prepare update storage - Filter for product model without variants and update parent This transformer filters 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 updates 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 converts localizations data from Akeneo.

{
    "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 BigCommerce, 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.

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

As this structure is not friendly to BigCommerce, we need to convert it to a more workable structure, which 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 price data from Akeneo.

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

As this structure is not friendly to BigCommerce, we need to convert it to a more workable structure, which 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.

{
  "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 will copy the Alumio base product data into the Alumio base product model with variant.
We add the variant code with “-1” to avoid data duplication.

{
  "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 This transformer filters previously created tasks into simple products to avoid duplication.

Fetching Family Attribute Axes from Akeneo

In Alumio, go to “Integrations → Incoming → Akeneo - Fetch - Families”. This incoming is created to get family axes in Akeneo to determine which attribute decides the product variant in BigCommerce. The family axes exist in the family variants, but Akeneo require code in the end point that is why we fetch the family first to get the code. Akeneo - Fetch and update storage - Family Variants - Axes

This transformer is a custom pagination HTTP call to get family variants.
It will then save the family axes in the storage “Akeneo - Family Variants - Axes”.

Automatic Fetching Product Data and Family Attribute Axes from Akeneo to Alumio

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

Templates

​Fetching Families and Attributes from Akeneo

​Fetching Parent Product Model from Akeneo

​Fetching Children Product Model from Akeneo

​Fetching Simple Product from Akeneo

​Fetching Family Attribute Axes from Akeneo

​Automatic Fetching Product Data and Family Attribute Axes from Akeneo to Alumio

Fetching Families and Attributes from Akeneo

Fetching Parent Product Model from Akeneo

Fetching Children Product Model from Akeneo

Fetching Simple Product from Akeneo

Fetching Family Attribute Axes from Akeneo

Automatic Fetching Product Data and Family Attribute Axes from Akeneo to Alumio