Data Mapping

Summary

Mapping

Native fields

The mapping section will let you map all necessary fields to match your Shopify data with your PIM source data.

It means that App will populate the data from the chosen PIM's attribute into the Shopify target field (e.g. in the PIM, you use the My_short_description attribute to fill in the description of your products, then you will map it with the Description field in your Shopify instance).

The drop-down list will be automatically populated with data from your PIM.

 

Different types of mapping for Shopify native fields

Akeneo App for Shopify allows you to manage your mapping in two different ways:

  • Simple mapping - if your data modelization in the PIM is based on the same attributes for all PIM families then you can map one particular data source to match all your products (eg. If you use the "My_short_description" field to fill in your description for all of your products independently on their family, then you will map it using simple mapping.
  • Complex mapping - this option allows you to map a Shopify target field differently for each product family. See more details in the "Complex mapping" section.

Be aware that you can combine both types of mapping depending on your needs. If you wish to use the complex mapping for a specific field, all you need to do is to check the corresponding checkbox and click on ‘MANAGE FAMILY MAPPING’ to access complex mapping for this specific field.

 

Be careful if you opt for a complex mapping for the Title field (mandatory): make sure that your mapping is completed for all concerned families before launching your first import in order to avoid unnecessary errors.

You need to click on the SAVE button in the top right corner of the page to save the changes.

 

 

Simple mapping for native fields

 

For a moment, the following native target fields are available for mapping:

 

Native fields for simple products

Native fields   Supported PIM attributes Limitations
BASIC INFORMATION      
Title - mandatory field

Yes

Identifier, Text 255 max characters length
Description

Yes

Text area, Text 512 KB max size
MEDIA      
Images

Yes

Image, Asset collection The limitation depends on the media source:

• 15 image attributes max
• 5 asset collections max
Videos

No

   
Image alt texts

No

   
PRICING      
Price

Yes

Number, Price Values cannot be negative
Compare at Price

Yes

Number, Price  
Taxable

Yes

Yes/No  
Cost per item

Yes

Number, Price Values cannot be negative
INVENTORY      
SKU

Yes

Identifier, Text 255 max characters length
Barcode

Yes

Identifier, Text 255 max characters length
Inventory setting

No

   
SHIPPING      
Physical

Yes

Yes/No  
HS code

Yes

Identifier, Text between 6 and 13 digits
Weight

Yes

Measurement, Number 2 000 000 000 unit max
Country/Region of origin

No

   
SEARCH ENGINE LISTING      
Page title

Yes

Text 70 max characters length
Meta description

Yes

Text, Text area 320 max characters length
URL handle

Yes

Text 255 max characters length
PRODUCT ORGANIZATION      
Product type

Yes

Text, Simple select 255 max characters length
Vendor

Yes

Text, Simple select 255 max characters length
Tags

Yes

Simple select, Multi select 250 tags max

 

Native fields for product models

Native fields   Supported PIM attributes Limitations
BASIC INFORMATION      
Title - mandatory field

Yes

Identifier, Text 255 max characters length
Description

Yes

Text area, Text 512 KB max size
MEDIA      
Images

Yes

Image The limitation depends on the media source

• 15 image attributes max
• 5 asset collections max
Videos

No

   
Image alt texts

No

   
SEARCH ENGINE LISTING      
Page title

Yes

Text 70 max characters length
Meta description

Yes

Text area, Text 320 max characters length
URL handle

Yes

Text 255 max characters length
PRODUCT ORGANIZATION      
Product type

Yes

Text, Simple select 255 max characters length
Vendor

Yes

Text, Simple select 255 max characters length
Tags

Yes

Simple select, Multi select 250 tags max

 

Native fields for product variants

Native fields   Supported PIM attributes Limitations
MEDIA      
Image

Yes

Image, Asset collection

The limitation depends on the media source:

• 1 image attribute max
1 asset collection max

PRICING      
Price

Yes

Number, Price Values cannot be negative
Compare at Price

Yes

Number, Price  
Taxable

Yes

Yes/No  
Cost per item

Yes

Number, Price Values cannot be negative
INVENTORY      
SKU

Yes

Identifier, Text 255 max characters length
Barcode

Yes

Identifier, Text 255 max characters length
Inventory setting

No

   
SHIPPING      
Physical

Yes

Yes/No  
HS code

Yes

Identifier, Text between 6 and 13 digits
Weight

Yes

Measurement, Number 2 000 000 000 unit max
Country/Region of origin

No

   

 

Media mapping

Media mapping allows you to map PIM images or PIM asset collections to Shopify images. By choosing PIM images, you will map & synchronize PIM image attributes to Shopify. If you select PIM asset collections, you will map and synchronize a specific asset attribute from the related asset family to the asset collection to Shopify.

The App allows you to map asset attributes of two types: media link or media file. Only asset attributes whose media type is image are selectable. If the asset attribute you want to map does not appear, please check the asset family settings to make sure it belongs to the right type.

 

How to map media?

Follow these steps to map your images:

 

  1. In the Native fields tab, click on EDIT MEDIA MAPPING  
     
  2. Now, choose a media source. You can choose between images and asset collections.
     

    It is not possible to map a mix of images and asset collections.

     

    Image attributes  
     
  3. You can now select an image attribute that you want to map.   
     


    Asset collections  
     
  4. You can now select an asset collection that you want to map.    
    Then, select the asset attribute in the asset family related to your asset collection that you want to import.  
     

    The App supports up to 5 asset collections to synchronize and map 1 asset attribute for each asset collection at the product level.    
    This corresponds to a maximum of 250 images per product.    
    Please note that it is only possible to map 1 asset collection at the variant level.

     
  5. Click on Save to save the mapping.

    Please note that it is possible to change the order of your media. To do this, simply select your media - click on the icon with three stripes - and drag the asset to the desired position.

     

 

 

 

Complex mapping for native fields

Complex mapping allows you to map Shopify target fields differently for each product family. Depending on your data modelization strategy, it can be used for each target field or only for one or a few of them.

If you wish to use a complex mapping for one of the Shopify target fields, please check the box below the drop-down list. Then, the button ‘MANAGE FAMILY MAPPING’ appears.

To define your family-by-family mapping, please click on ‘MANAGE FAMILY MAPPING’. An additional family-by-family mapping modal will appear.

All PIM families will be retrieved from your PIM and displayed in the PIM family column.

Same as for the Simple mapping - see above -, PIM attributes will be prepopulated for each dropdown list. The attribute type allowed does vary and depends on the Shopify target value - see the general mapping page.

On the top of the page, you will see the progression bar of your family-by-family mapping.

Please keep in mind that to avoid any errors during your import, if you decide on the Family to Family mapping for Title, you should complete your mapping for all concerned families before launching your first import.

 

 

Metafields mapping

Thanks to metafields you can map the following attributes types from your Akeneo PIM into Shopify:

  • Date (format: YYYY/DD/MM/)
  • Identifier
  • Multi-select
  • Simple select
  • Measurement (format: value + unit)
  • Number
  • Price
  • Text
  • Text area
  • Boolean

 

You can create up to 250 Metafield definitions into Shopify with the App.

 

Each attribute type is transformed when synchronizing with Shopify. Please see the transformation of each attribute in the table below.

Akeneo PIM attribute type Shopify metafield type
Date Date
Identifier Single line text
Simple select Single line text
Multi-select Single line text - list of values
Measurement Single line text
Number Decimal
Price Money
Text Single line text
Text area Multi-line text
Boolean True or false

 

  • The translated label of your attribute will be imported as the attribute name.
  • The App does not impact the import order of metafields in Shopify.
  • If you delete product attributes in your PIM or in the App interface, those will be removed automatically from your product page in Shopify during the next import.
 

 

Follow these steps to map your Metafields:

  1. Go to: Metafield mapping >> Click on Manage Metafields
  2. Select PIM attributes that you want to map
  3. Validate your choice by clicking on Confirm selection

 

Follow these steps to remove some of the metafields from the mapping:

  1. Go to: Metafield mapping >> Click on Manage Metafields
  2. Deselect PIM attributes that you want to remove from your mapping
  3. Validate your choice by clicking on Save selection