iMARKET export

Using the standard job “iMARKET Export” you can export products an their product data to the appropriate iMARKET instance. In the “iMARKET Export” section of the iPIM Export module, the export is configured.   

Standard attributes

Mapping principle

In the “Standard attributes” tab, you can map iPIM attributes either directly on products, directly on items or on the appropriate iMARKT core attributes. Core attributes are attributes from the iMARKET standard data model. The mapped attributes are written on the appropriate iPIM properties. This effects that, for the various products in iMARKET, the values of the iPIM attributes are written directly on the products, directly on the items resp. on the iMARKET core attributes when the export is carried out. The transfer is happens via a .xml file that is stored on the dedicated server where it is processed.

The attributes mapped in the first two rows are written directly on the products resp. directly on their subordinate items (variations): 

iMARKET target iPIM property Decription
Product
(attributesidentifierProduct)		 dataexport.imarket.ipim.attributes.product At this point, the attributes are mapped whose values are written directly on products.
Item
(attributesidentifierItem)		 dataexport.imarket.ipim.attributes.item At this point, the attributes are mapped whose values are written directly on items resp. variations of products.

The following table gives an overview of some iMARKET core attributes and the corresponding iPIM properties:

iMARKET core attribute XML name iPIM property Explanation
description Title ipim.core.dataexport.imarket.attribute.with.fallback.title Product name
color Dimension1 dataexport.imarket.ipim.identifier.dimension1 First variation level
dimension1_name VariationVector dataexport.imarket.ipim.identifier.dimension1Value Name of the first variation level
size Dimension2 dataexport.imarket.ipim.identifier.dimension2 Second variation level
dimension2_name VariationVector dataexport.imarket.ipim.identifier.dimension2Value Name of the second variation level
short description ShortDescription dataexport.imarket.ipim.identifiers.with.fallback.product.shortDescription Short description
long description LongDescription dataexport.imarket.ipim.identifiers.with.fallback.product.longDescription Long description
selling_points SellingPoint dataexport.imarket.export.sellingpoints USPs
width Width dataexport.imarket.attribute.width Width
height Height dataexport.imarket.attribute.height Height
depth Length dataexport.imarket.attribute.length Length
gross_weight Weight dataexport.imarket.attribute.weight Weight
brand Brand dataexport.imarket.attribute.brand Brand
manufacturer Manufacturer dataexport.imarket.attribute.manufacturer Manufacturer
BaseColor base_color dataexport.imarket.export.basecolor Base color

An appropriate .xml file might look as follows:

Map attributes

In order to map attributes, proceed as follows:

  1. Activate the “Standard attributes” tab.
  1. Map the first attribute. To do so, click in the appropriate field (in this case “attributeidentifiersProduct”).Chevron rightThe corresponding menu is shown
  1. Select an iPIM attribute from the menu. Optional: Enter a search term in the search field to filter the list of attributes by a search term.
  2. Click on the attribute to select it. In the upper two menus, you can also select multiple attributes.
  3. Click on the  button  to confirm the selection.Chevron rightThe menu closes.
  4. Allocate the appropriate iPIM attributes to further iMARKET attributes.  
  • To finalise the attribute mapping, click on the SAVE button .
    A success message is shown. The mapping is now established.
  • To cancel your settings, click on the CANCEL button .

Custom attributes

This tab shows the custom attributes that are not mapped to iMARKET core attributes but are to be part of the “iMARKET Export” nonetheless. In order to include custom attributes in the “iMARKET Export”, the appropriate attribute property needs to be set for them. This is done in the attribute configuration of iPIM CC. But you can also select attributes in iPIM Export and allocate them to the respective attribute property. Following this, the attribute property is set for the respective attributes.

In the default configuration of iPIM resp. iMARKET, there are the following attribute properties for the “iMARKET Export”:

Identifier Name Description
IPOEM_EXPORT iMARKET-Export: Is iMARKET feature Generally for attributes that do not belong to the iMARKET standard data model
IMARKET_EXPORT_NO_LANGUAGE_FOR_CUSTOM iMARKET-Export: Custom attribute needs no language tag Attributes without localization (e. g. brand)
IMARKET_UOM_CONVERSION iMARKET-Export: Unit of measurement conversion Deviating units

Set attribute properties in iPIM CC

In order to set the appropriate property for an attribute in iPIM CC, proceed as follows. In this example, the attribute property iMARKET-Export: Is iMARKET feature is set:

  1. Access the iPIM CC module.
  2. Go to the attribute configuration.
  1. Select the desired attribute. To do so, click on the “Select attribute” field to show the corresponding selection menu.
  1. Optional: Enter a search term in the search field to filter the list of attributes by a search term.
  2. Click on the desired attribute to select it.Chevron rightThe menu closes and the data of the selected attribute is shown in the respective fields.
  1. Activate the “Properties” tab.
  1. Click on the ADD button to call up the corresponding dialog box.
  1. Possibly enter a search term in the search field to filter the list of attribute properties by a search term.
  2. Transfer the desired attribute property from the left column to the right column to select it. To do so, click on the attribute property .
  3. Click on the ACCEPT button to finalize the selection of the attribute property.
    The dialog box closes and the selected attribute property is shown in the table.
  1. In the table row of the attribute property, double-click in the table cell of the “Property value” column.
  2. Select the option YES.
  3. Click on the SAVE button to save your settings.
    A success message is shown. The attribute property is now set.

Allocate attributes in iPIM Export

For example, in order to allocate an attribute to the attribute property iMARKET-Export: Is iMARKET feature in iPIM Export, proceed as follows:

  1. Activate the “Custom attributes” tab.
  1. In the line of the attribute property, click on the CONFIGURE button to call up the corresponding dialog box.
  1. Possibly enter a search term in the search field to filter the list of attributes by a search term.
  2. Transfer the desired attribute from the left column to the right column to select it. To do so, click on the attribute .
  3. Click on the ACCEPT button to finalize the attribute selection.
    The dialog box closes and a success message is shown. The attribute is now selected and it is shown among the allocated attributes.

Data transfer profiles

Create data transfer profiles

Data transfer profiles determine the way that product data is transfered to iMARKET. This section shows how to create a SFTP data transfer profile for the transfer of product data. To do so, proceed as follows:

  1. Activate the “Data transfer profile” tab.
  1. Click on the CREATE button in the footer to call up the corresponding dialog box.
  1. Enter an identifier for the data transfer profile in the “ID” field . 
  2. Possibly specify names for the data transfer profile. To do so, click on the More button in the “Name” field . Chevron rightYou are directed to another slider that has input fields for the various languages:
    1. Enter the localized names for the data transfer profiles in the various input fields.
    2. Click on the  BACK button to get back to the previous slider. 
  3. Possibly specify descriptions for the data transfer profile. To do so, click on the More button in the “Description” field . Chevron rightYou are directed to another slider that has input fields for the various languages:
    1. Enter the localized descriptions for the data transfer profiles in the various input fields.
    2. Click on the  BACK button to get back to the previous slider. 
  4. Select the transfer type “SFTP” from the “Transfer type” menu .
  5. Enter a folder name in the “Folder name” field .
  1. Enter a host name in the “Host” field .
  2. Enter a login name in the “Login” field .
  3. Enter the password to the login name in the “Password” field .
  4. Possibly enter a suffix in the “Suffix” field .
  5. Possibly enter the name of the proxy server in the “Proxy server” field .
  6. Click on the ACCEPT button to finalize the creation of the data transfer profile.
    The dialog box closes and a success message is shown. The data transfer profile is now created.

Edit data transfer profiles

This section explains how to edit an existing data transfer profile. In order to do so, proceed as follows:

  1. Activate the “Data transfer profile” tab.
  1. In the table row of the data transfer profile, possibly click on theChevron right button in the “ID” column to expand the various locales. 
  2. Double-click in the table cell you want to edit.
  3. Make the desired changes.
  4. Leave the table cell.
  5. Possibly make further changes to other table cells.
  6. Click on the SAVE button to save your changes.
    A success message is shown. The data transfer profile is now edited.

Locale Mappings

In this tab, the various iPIM locales are mapped to the appropriate iMARKET country codes. To do so, proceed as follows:

  1. Activate the “Locale mappings” tab. 
  1. In the table row of the first iPIM locale, double-click in the table cell of the “iMARKET” value column .
  2. Enter the appropriate three-digit country code.
  3. Leave the table cell.
  4. Allocate all the further country codes.
  5. Click on the SAVE button to finalise the allocation of the locales.
    A success message is shown. The iPIM locales are now allocated to the appropriate iMARKET country codes.

Asset type mappings

In this tab, the iPIM digital asset types are mapped to the appropriate iMARKET asset types. First, it is determined which iPIM digital asset types are included in the “iMARKET Export”. Then it is specified whether the digital asset types are used on the product level and/or on the item level (variation level).

Using an example, this section shows how to map digital asset types. Hereby, the iPIM digital asset type “Main image” is selected. It is specified that the digital asset type is used on the product level. And eventually, it is specified that the iPIM digital asset type is mapped to the appropriate iMARKET asset type on the product level. To do so, proceed as follows:

  1. First, the digital asset type to be included in the “iMARKET Export” is selected: In the table row “Digital asset types”, double-click in the table cell of the “Property value” column to call up the correponding menu.
  1. Optional: Enter a search term in the search field to filter the list of digital asset types by a search term.
  2. Tick the digital asset type “Main image” .
  3. Tick on the button to confirm your selection. Chevron rightThe menu closes and the selected digital asset type is shown in the table.
  1. Click on the SAVE button to save your settings. Chevron rightA success message is shown.
  1. In this step, it is specified that the digital asset type is used on the product level: In the table row “Product digital asset types”, double-click in the table cell of the “Property value” column to call up the correponding menu.
  1. Optional: Enter a search term in the search field to filter the list of digital asset types by a search term.
  2. Tick the digital asset type .
  3. Tick on the button to confirm your selection. Chevron rightThe menu closes and the selected digital asset type is shown in the table.
  1. Click on the SAVE button to save your settings. Chevron rightA success message is shown.
  1. In this step, the selected iPIM digital asset type is mapped to the appropriate iMARKET asset type on the product level: In the table row “Product Main image”, double-click in the table cell of the “Property value” column to call up the correponding menu.
  2. Enter the name of the iMARKET asset type.
  3. Leave the table cell.
  4. Click on the SAVE button to save your input.
    A success message is shown. The digital asset type is now mapped.

The following table provides an overview of the iMARKET asset types:

Asset type Description
Product Product image
ProductWhite Cut-out product image
BrandLogo Brand logo
Mainview Main image
MainviewWhite Cut-out main image

Price type mappings

In this tab, the iPIM price types are mapped to the appropriate iMARKET price types, whereby the mapping is done in dependence on market places and target countries. Additionally, the default VAT is determined.

Using an example, this section shows how to map price types. Hereby, the iPIM price type “Sales price” is mapped to the market place Amazon DE. For the selected market place, the iPIM price type is mapped to the iMARKET price type “Standard” and the target country “Germany”. And “19%” is specified as the default VAT. To do so, proceed as follows:

  1. Activate the “Price type mappings” tab.
  1. First, select the price type: In the table row “PriceTypes”, double-click in the table cell of the “Property value” column to call up the correponding menu.
  1. Optional: Enter a search term in the search field to filter the list of price types by a search term.
  2. Tick the price type “Sales price” .
  3. Click on the button to confirm your input. Chevron rightThe menu closes and the selected price type is shown in the table. 
  1. Specify the marketplace: In the table row “Sales price Marketplaces”, double-click in the table cell of the “iMARKET value” column .
  2. Enter the marketplace ID.
  3. Leave the table cell.
  4. Click on the SAVE button to to save your input.
    A success message is shown and an additional row is shown in the table.

The following table provides an exemplary overview of some of the marketplace IDs:

Market place ID
AboutYou.de 82
AMAZON_DE 4
EBAY_DE 12
OTTO_DE 1
  1. Map the iMARKET price type for the selected market place: In the table row “Sales price for marketplace x”, double-click in the table cell of the “Property value” column to call up the corresponding menu.
  2. Select the iMARKET price type “Standard” from the menu. To do so, click on the appropriate option.
  3. Specify the target locale: In the table row “Sales price for marketplace x”, double-click in the table cell of the “Country Value” column to call up the corresponding menu.
  4. Select the target country “Germany” from the menu. To do so, click on the appropriate option.
  5. Click on the SAVE button to to save your input.
    A success message is shown. The price type is now mapped.

Carry out the “iMARKET Export”

In this step, the “iMARKET Export” is carried out in order to export products ans their product data to the appropriate iMARKET instances. To do so, proceed as follows: 

  1. Call up the iPIM CC module.
  2. Go to the “Job Administration” area of the “Jobs & Processes” section.
  1. Optional: Enter a search term in the search field to filter the list of jobs by a search term.
  2. Move the mouse cursor over the table row of the “iMARKET Export” job . Chevron rightA menu bar with multiple buttons is shown.
  3. Click on the Execute button  to trigger the export. Chevron rightA success message is shown and the export is run in the background.

FAQ

What can you do using the standard job “iMARKET Export”?

Using the standard job “iMARKET Export” you can export products and their product data to the appropriate iMARKET instance. This export is configured in the “iMARKET Export” section of the iPIM Export module.

How is the transfer of product data to iMARKET technically implemented?

The transfer happens via a .xml file that is stored on the dedicated server where it is processed. This file provides a structured representation of the products, including their attributes, variations, and allocated values.

What is the purpose of the “Standard attributes” tab?

In the “Standard attributes” tab, you can map the relevant iPIM attributes either directly on products, directly on items or on the appropriate iMARKET core attributes. Core attributes are attributes from the iMARKET standard data model.

What happens to the mapped iPIM attributes in the background?

The mapped iPIM attributes are written on the appropriate iPIM properties. This effects that, when the iMARKET export is carried out, the values of the iPIM attributes are written directly on the products, directly on the items, resp. on the mapped core attributes for the various products in iMARKET.

What is the purpose of the “Custom attributes” tab?

This tab shows the custom attributes that are not mapped to iMARKET core attributes but are to be part of the iMARKET export nonetheless. In order to include an attribute as a custom attribute, the appropriate attribute property needs to be set for it.

What is the purpose of data transfer profiles in the iMARKET export?

Data transfer profiles determine the way that product data is transferred to iMARKET. One example is setting up a SFTP data transfer profile for the transfer of product data.

What is configured in the “Locale mappings” tab?

In this tab, the various iPIM locales are mapped to the appropriate iMARKET country codes. To do so, you double-click in the table cell of the “iMARKET” value column for each iPIM locale and enter the appropriate three-digit country code.

What is specified in the “Asset type mappings” tab?

In this tab, the iPIM digital asset types are mapped to the appropriate iMARKET asset types. First, it is determined which iPIM digital asset types are included in the iMARKET export, and then it is specified whether they are used on the product level and/or on the item level (variation level).

What is configured in the “Price type mappings” tab?

In this tab, the iPIM price types are mapped to the appropriate iMARKET price types, whereby the mapping is done in dependence on marketplaces and target countries. Additionally, the default VAT is determined here.

How do you manually carry out the “iMARKET Export” job?

To do so, you call up the iPIM CC module and go to the “Job Administration” area of the “Jobs & Processes” section. Moving the mouse cursor over the table row of the “iMARKET Export” job shows a menu bar with action buttons that let you trigger the export.