Tailored import - import any file structure to Akeneo PIM

Summary

Overview

Tailored Imports is a new import profile available to all SaaS users (Enterprise and Growth Edition). It helps you import your product information in an XLSX file with different structures than the PIM usually accepts.  
For instance, let's assume your supplier or brand sends you their product information in different XLSX files, each with different structures:

  • Supplier A sends a file with columns named: "Product ID", "Model Name", "Online description", and "Color".
  • Brand B sends a file with columns named: "Gencod", "Web title", "Long label", "Web description", and "Supplied accessories".

Without  Tailored Import, you must manually modify your spreadsheet to conform with a regular import profile. This includes time spent converting attributes from label to code, transforming labels, converting measurements, and many more manual operations.

Thanks to Tailored Import, you can configure all your needs (mapping, operations) via an import and use it as often as necessary. You no longer need to manually edit your XLSX files when importing product information.

🎓 Put your knowledge into Practice

Please watch our dedicated training to learn more about Tailored Import and how to use this feature.

Course time: 10 min

Start the course

 
 

 

Currently, the following attribute types aren’t available to be mapped: Table, File & Image. In addition, the following system properties aren't available to be mapped: Parent, Family variant, Groups & Associations. Finally, please note we don't currently support media files' import for now.

 

 

Create a Tailored Import profile

To create a new import profile:

  1. Go to Imports
  2. Click on Create import profile
  3. Type a unique import code and a label, then select the job Tailored product import
  1. Save your new import profile

 

Edit a Tailored Import profile

Once you've created your Tailored Import profile, or if you want to edit an existing one:

  1. Go to Imports
  2. Click on the Tailored Import profile that you want to edit
  3. Click on Edit located in the top right corner of the screen

 

Discover the different tabs of this profile

A Tailored Import profile displays the following tabs:

  • Properties: To name your import profile.
  • Permissions: To set permissions to allow specific user groups to execute or edit your import profile (Enterprise Edition only).
  • Global settings: To define the behavior in case an error occurs, you can skip the products (the rows won't be imported) or skip the values only (the faulty cells won't be imported). Please note that in case the issue is not caused by Tailored Import (due to a wrong regex, for instance), whole rows could be skipped, even though "Skip values" is selected.
  • Import structure: To create your import structure (read how to define your import structure).
  • History: To display the modifications made by any user on your export profile.

Define your import structure

In the Import structure tab, you can define the structure of your file so that it matches all the future files you will import. To do that, on the one hand, you will need to import a file to define the structure and then create your mappings and operations by adding PIM attributes and linking them to your file columns. On the other hand, after this initial configuration, you can directly import all the product files that share the same structure.

Please note that once you define and confirm the structure of your import profile, you won't be able to change it. For instance, if the next file you want to import has a different column order or an extra column, you won't be able to use this import profile and will have to create another one.

 

To do this, please follow the steps below:

  1. Under Import structure tab, click on Initialize import structure
  1. Now, upload the file you need to import. This step will help the PIM to assess the structure of your file. Note that the products in the uploaded file won't be imported at this step.   

    Please note that an error message will be displayed if your file contains an incorrect function in a cell, and you won't be able to initialize its structure.

    Limitations have been set for each uploaded file:

     
  1. Once uploaded, you'll have to set different fields:
  • The appropriate sheet in your spreadsheet.
  • The row where the header is located.
  • The row where the first product is displayed.
  • The column where the first product data is displayed.

    Before you click on Confirm, please verify your configuration. Once this step has been confirmed, you won't be able to change it, and you will have to create another import profile if you want to set it differently.

     
  1. Click on Confirm

    Limitations have been set for each Tailored Import profile:

     
  2. Select an identifier as an Import ID

    You can define which identifier attribute will be used as the mapping key for Tailored Import profiles. If the products in your PIM match those from your file, they will be updated; if they don't, they will be created.

    For example, suppose you set the EAN13 as a main identifier in your PIM. However, your supplier, Zaro, sends you new products with GTIN identifiers. You decide to map the GTIN column to your GTIN identifier attribute, and then you set the GTIN as the Import ID. This way, when the GTIN identifiers in the file match the GTIN identifiers in your PIM, the products will be updated, and when they don't match, the products will be created. All this even though you set the EAN13 as a main identifier in your PIM.

     
  3. Click on Confirm
     

 

Start mapping your columns to your attributes

  1. Now it's time to map your file's relevant information to the PIM. To do that, click on Add attribute and select an attribute from the PIM you would like to use, for instance, the "Name" attribute.
  2. Then, you'll see the right panel of this attribute displays three different sections: Target, Source(s), and Operation(s).
    • The target section will display different settings depending on the attribute you selected in the step above. Read more about conditional settings.
    • The Source(s) section displays all the columns in your uploaded spreadsheet.
    • The Operation(s) section will display one or more operation(s) to transform your data, depending on your selected target.
  3. Click on Add a source and select a source listed from your file. The letter between brackets indicates the column in your spreadsheet where this source is located. For instance, choose the one that matches the name of your product, e.g., "Web title".
  4. Look at the "Operation(s)" section, where the first data samples are displayed as a preview. This preview will display random data samples from the uploaded file enabling you to ensure confirmation of the sources that you've added to this target.

Data samples are unique values selected randomly from the first 1,000 rows found in the file uploaded for the configuration.

 
  1. If required, you can add operations under the data samples. Click on Add operation and select the one you'd like. Please note that the operations are available depending on the attribute selected as a target but also depending on previously added operations.
  2. At the end of the operations, an output preview of the sample data will be shown, with changes based on the operations you've added.
  1. Once you're done, click on Save in the top right corner. You're now ready to import your products.

If you didn't set an Import ID in the previous steps, you can do it on this screen as well.

 

Conditional settings

Depending on the target you selected, some other parameters can be displayed:

  • For scopable and/or localizable attributes, you must select to which channel and/or locale you want to import your data.  
  • For collection attributes (multi-select, categories), in case the products in your PIM already exist with a few values, you can choose if you want to add the data from your file to the existing data or if you want to replace the data in the PIM by the one from the file.  
  • For each target, the checkbox "Clear if empty in file" helps you decide if you want to clear the product value in your PIM when the cell in your file to import is empty.  

 

Import your products

To launch your import profile, click on the name of your import profile in the breadcrumb, drag & drop your file, and click on Upload & import now.

Limitations have been set for each uploaded file:

  • Maximum of 500 columns.
  • Maximum 50 MB file size.
 

 

Discover operations

You can use operations to transform the data in order to make the import process easier.

Adding the operations in the correct order is essential. For instance, if you want to import the column "Main color" that contains multiple values in each cell (e.g. "Black, Crow, Charcoal, Obsidian") from your Excel spreadsheet into one multi-select attribute "Color" in our PIM, you need to add the operations in that order: first Split, then Replacement.

 

Depending on the targets that you define, here are the different types of operations that you can add:

Yes/No replacement

This operation is available for Yes/No and Enabled attributes used as a target. It will help you to replace the default values with your own value.

 

Replacement

This operation is available for Simple select, Multi select, Reference entity single link, or Reference entity multiple link attributes used as a target. It will help you to replace the values with your own.

Replacement values are case-insensitive.

 

 

Split

This operation is available for collection attributes used as a target. It will help you to import different values that are located into the same cell of your spreadsheet by splitting these values thanks to a separator: comma (,), semicolon (; ), or pipe (|).

 

Change case

This operation is available for Text and Text Area attributes used as a target. It will help you to change the case by choosing from:

  • Lowercase
  • Uppercase
  • First letter uppercase  
     

 

Clean HTML

This operation is available for Text and Text Area attributes used as a target. It will help you to clean your HTML values with two options:

  • Remove HTML tags
  • Decode HTML characters

 

Remove whitespaces

This operation is available for Text and Text Area attributes used as a target. It will help you to clean the unnecessary whitespaces values with two options:

  • Clean consecutive whitespaces
  • Remove whitespaces at the beginning and the end

 

Search and replace

This operation is available for Text and   Text Area attributes used as a target. It will help you to search for a term and replace it with another one. Note that you can add up to 10 replaced values per operation.

 

Extract with regular expression

This operation is available for Text and Text Area attributes used as a target. It will help you extract a value based on a regular expression of your choice. 

Regular expression operation

Regular expressions mostly start and end with a slash (/) or a tilde (~).  
If you're new to regular expressions, you can use the Autoregex service to generate a regular expression based on a sentence describing your need. 

 

 

Duplicate a Tailored Import profile

If you want to create another import profile based on an existing one, you can duplicate it. Please note that the structure of this import profile will remain unmodifiable. You can only add or remove operations, targets, and sources.

To do this, please follow the steps below:

  1. Select the import profile you would like to duplicate
  2. Click on Edit
  3. In the top right corner, click on the three dots "..." and select Duplicate
  4. Write a label and a code, then click on Save
  • Maximum 500 columns.
  • You can add up to 4 sources in a single column.
  • Text fields are limited to 255 characters.
  • Maximum 500 columns.
  • You can add up to 4 sources in a single column.
  • Text fields are limited to 255 characters.