Skip to main content

Automatic product and offer data exchange


On this page, you will learn how to create a catalogue for exporting items with the help of an assistant. Furthermore, you will learn how to map data fields in the catalogue to be able to correctly transfer your product and offer data to the marketplace. Afterwards, you only have to set the variation availability and activate the catalogue export.

1. About automatic data exchange

After installing and setting up the plugin, the automatic processes described in Table 1 become available:

Table 1. Frequency of data exchange
Data Interval

Item data

Item export

daily

Stock synchronisation

Every 15 minutes

Price synchronisation

Every 15 minutes

Order data

Order import

Every 15 minutes

2. Setting up the item export

Item data is exported to Conrad via marketplace formats. Go to Data » Catalogues to create catalogues.

If you want to sell your products in multiple Conrad product categories, create a separate catalogue for each of them. Link the Conrad data fields with the item data saved in plentymarkets in the marketplace format afterwards. Once you’ve activated a catalogue, plentymarkets automatically exports the catalogue templates to Conrad on a daily basis.

Error log

If there’s a problem during export, you can find the related log entries on Mirakl and not the plentymarkets log.

2.1. Creating a catalogue in the assistant

Proceed as described below to create a catalogue in the assistant.

Creating a catalogue in the assistant:

  1. Open the menu Setup » Assistants » Plugins » [select plugin set].

  2. Click on the assistant Conrad Catalogue.

  3. Follow the instructions on the screen. If you need additional information about one of the options, expand the Info box below this description ().

  4. In the step Summary, check your settings to make sure they are correct.
    Tip: In the Summary step, click on the arrow () to show the settings.

  5. If everything is as it should be, click on Finalise.
    → The catalogue is created.

  6. Open the catalogue in the Data » Catalogues menu to map the fields.
    Note: Only select bottom level categories. You can find a better overview of the category hierarchy on Miracle by going to My account » My product data settings.

2.2. Mapping data fields in the catalogue

After you have created a catalogue, map the market’s data fields to item data saved in plentymarkets. Check the documentation of the sales channel to find out what data the market expects for the individual data fields.

Using properties

Use properties to export values for marketplace data fields that have no corresponding field in plentymarkets.

Mapping data fields in the catalogue:

  1. Go to Data » Catalogues.

  2. Click on the catalogue.
    → The Mapping tab with the market data fields opens.
    → In the left-hand column, the market’s data fields are listed.
    Tip: Mandatory fields are flagged with an asterisk (*).

  3. Next to the marketplace data field, click on + Add data field.
    → To the left, the list of available plentymarkets data fields are shown in groups.

  4. Map the field:

    • Alternative 1: Map a plentymarkets data field + optional fallback data fields

      1. Click on a group to expand the associated plentymarkets data fields.
        → The data fields are shown.

      2. Click on the plus to the right of the plentymarkets data field you want to select.

      3. Optional: Add one or more fallback data fields. To do so, click on the plus to the right of the plentymarkets data field you want to select.
        → The fallback data field is exported when the first data field does not exist or is empty.
        Note: Even if you assign a fallback data field to a market data field, only one value is exported. The fields are checked in the order in which you mapped them. This means that if the first data field does not provide a value, the first fallback data field is exported etc.

      4. Click on Confirm.

    • Alternative 2: Always export the same value for a market data field

      1. Click on the plus next to Own value at the top of the list.
        → The field for the own value is added to the view.

      2. Enter a value into the input field.
        → This value is exported for all variations.

  5. Continue to map all data fields of the market for which you want to export product information.

  6. Save () the catalogue.
    → The mappings are saved.

Optional: 1:n mappings - 1 marketplace data field, several plentymarkets data fields
  1. Map a plentymarkets data field or an own value to the marketplace data field as described above.

  2. To the right of the mapped plentymarkets data field, click on Add data field ().
    → To the left, the list of available plentymarkets data fields again are shown in groups.

  3. Map one or several additional plentymarkets data fields to the marketplace data field as described above.

  4. Click on Confirm.

  5. To the very right of the row, click on Settings ().

  6. Select a separator from the drop-down list Separator or add a custom separator.

  7. Save the settings.

  8. Save () the catalogue.
    → The mappings are saved.
    → During the export, the content of the plentymarkets data fields is combined and exported as one field.

Do not map plentymarkets data fields to the following marketplace data fields for the market Conrad:

  • Product image 1

  • Product image 2

  • Product image 3

  • Product image 4

  • Product image 5

You can ignore the warning shown when you save the mapping.

Table 2. Conrad mappings
Marketplace data field plentymarkets data field

Brand

Create a property of type Text for this marketplace data field. Create a property value for each type of unit that you use for your products. Be sure to enter the code, not the label.

Tip: Use the attribute help tool to find all possible values.

Note: For this marketplace data field, you cannot use properties of the type Multiple selection. Mapping a property of the type Multiple selection in the catalogue will cause an incorrect transfer.

Product title

Map one or more of the following plentymarkets data fields to this marketplace data field. Use at least 20 and not more than 100 characters.
Note: You can only transfer plain text. HTML tags are not allowed.

  • Name 1

or

  • Name 2

or

  • Name 3

or

  • Property

Manufacturer Part Number

Map the following plentymarkets data field to this marketplace data field:

  • Variation No.

Sales quantity unit

Create a property for this marketplace data field. Create a property value for each type of unit that you use for your products. Be sure to enter the code, not the label.

Tip: Use the attribute help tool to find all possible values.

Tip: If all your variations for this catalogue have the same sales unit, you can export your own value instead of creating a property. For example, to export the unit “pieces” for every variation, enter ST in the field Own value.

Weight unit

Create a property for this marketplace data field. Create a property value for each type of unit that you use for your products. Be sure to enter the code, not the label.

Tip: Use the attribute help tool to find all possible values.

Tip: If all your variations for this catalogue have the same weight unit, you can export your own value instead of creating a property. For example, to export the unit “gram” for every variation, enter unece.unit.GRM in the field Own value.

Variation group

The data field Variantengruppe (variation group) is used to group products, i.e. to tell the market what a number of products have in common. As such, map the plentymarkets data field Item ID to this field.

Variation

The data field Variante (variation) is used to differentiate products. It tells the market in what ways a number of products are different from each other. That’s why you map this field to the property you previously created for variations.

Tip: If you distinguish your variations only by a single attribute, you can also map the Attribute value name.

2.3. Creating additional properties

If you’ve defined more than one attribute for any of your variations, create a property that combines these attributes. For example, if you distinguish a variation both by colour and by size, you can create a property called “Grey XL”. Then, link these properties to the respective variations.

In addition to the properties described previously, you need properties for all data fields of the marketplace whose data you want to export, but that don’t exist in plentymarkets by default. You can see by the data fields in the catalogue which properties you need. Is this your first time working with properties? For further information, refer to the item Properties page.

After you created a marketplace format for Conrad with the ConradExtension Catalog assistant or manually, the property Conrad is created in your plentymarkets system. A new selection value is added to the Conrad category group property for each category selected in the Settings step of the assistant. In order for your variations to be exported in the appropriate catalogue, they have to be linked to the Conrad category group property in the Properties tab of a variation.

Linking a variation to a category:

  1. Go to Item » Edit item » [Open item].

  2. Click on the Variations tab.

  3. Open the variation that should be linked.

  4. Open the Properties tab.

  5. In the Variation properties area, select the property Conrad category group from the Properties drop-down list and click on Add ().
    → The property is added.

  6. Select the desired category group from the Value drop-down list for the Conrad category group property.
    → The variation will be exported in this catalogue.
    Example: If you pick the value VHS cassettes, the catalogue variation is exported for the VHS cassettes category.

  7. Repeat steps 5 and 6 for all categories where you want to offer the variation.

  8. Save () the settings.

  • via import: Go to Setup » Settings » Properties » Configuration, open the property ConradExtension category mapping and click on Values. You can find there the selection value IDs that are needed for the import.

  • via REST API: Use the REST routes from the areas Property  and Item  to link the catalogue with the variation.
    Note: If no marketplace category is available in the assistant ConradExtension Catalog, you might have entered the wrong API environment in the Authentication step of the assistant ConradExtension.

All properties, sales prices and barcodes that you have created for mapping them in the catalogue now need to be linked to the variations that you want to export to the market. This is described on the Item pages of the manual:

4. Activating the catalogue export

You have set up Conrad and created a catalogue for exporting your item data? Then start the export of your item data.

Activating the catalogue export to Conrad:

  1. Go to Data » Catalogues.
    → The catalogues are listed.

  2. Scroll to the Conrad catalogue.

  3. In the Active/Inactive column, move the toggle button to the right ().
    → The catalogue is active.
    → The catalogue data is exported to Conrad daily.

4.1. Transferring marketplace-specific values

The marketplace requires specific values for most of the attributes in order to be able to transfer product data. Currently, these values are, however, not yet saved at the variation.
Example: For example, it is not allowed to enter test for the attribute Brand. You have to transfer the corresponding code in this case - in this example BRAND_12345678.

5. Using the attribute help tool

The so-called attribute help tool allows you to search for the different attributes. The tool then returns the values that are currently valid for the attributes. To use this tool, the assistant ConradExtension must have been completed. You can find the tool under the following URL: domain/Conrad_extension/attribute_values. Replace domain with your plenty domain. For example, if your domain was called https:://www.my-plenty-domain.com, the URL would be set up as follows:
https://www.my-plenty-domain.com/conrad_extension/attribute_values.

Go to the attribute help tool and enter SAP.TaxIndicator in the search field to find the valid values for VAT class. Enter SAP.BaseUnits to find the valid values for Sales unit.

Attribute values will be displayed on following day

The table of the valid attribute values is updated over night. Once the plugin has been installed for the first time, the valid values will not be displayed until the following day.
In case you entered the wrong API environment and/or the wrong API key, the valid values cannot be loaded.

In the catalogue you will find the names of the marketplace attributes, such as Brand. To find out which values are valid for a specific attribute, proceed as follows.

Using the attribute help tool:

  1. Call the URL as described above.

  2. Enter the name of the attribute into the search or use Strg+F or Cmd+F to browse the list of results.
    → The attribute is shown in the Attribute label column.
    → The column Value Code lists the valid values that have to be transferred for the attribute values listed in the Value Label column.

5.1. Mapping and transferring valid attribute values

In case there are different attribute values that might be valid depending on the variation that you want to transfer, the first question is how you keep your item data up-to-date. If you manage your item data manually, it is recommended to use a property of the type Selection. You can save a description for the selection here. This description will then be shown in the property overview at the variation. Once the code was mapped to the property, you can use the real name of the variation in the field Description. This means the code is transferred via the catalogue and the real name is shown in brackets behind.

Tip: If you always want to transfer only one single value for an attribute, e.g. you want to use always BRAND_12345678 for the brand, you can use the option Own value in the catalogue.

6. Transferring product and offer data

The listing process at Conrad takes place in two steps: First, the products are created. Then, after the marketplace has approved the product data, offers for the created products can be activated. Both export processes, their requirements as well as transfer options are described in the following sub-chapters.

6.1. Transferring product data

In this chapter, you will learn how to transfer product data to the marketplace and which requirements have to be met. This data comes from the catalogue ConradExtension Catalog that you created.

6.2. Requirements for transferring product data

  • The plugins Conrad  and Mirakl Connector were purchased and downloaded from plentyMarketplace and installed in a plugin set.

  • The order referrers Conrad and Mirakl were activated in the Setup » Orders » Order referrer menu.

  • The basic settings were carried out in the Setup » Assistants » Plugins » [select plugin set] » ConradExtension menu. In order to transfer product data, activate the option Export products in the step data exchange.

  • In the Setup » Item » Sales prices menu, the order referrers Mirakl and ConradExtension have been activated on an existing price or a new sales price has been created for which the order referrers Mirakl and ConradExtension were activated.

  • You already created a catalogue for the data transfer.

What connection exists between the offer fields, the product export field and the marketplace SKU at the variation?

In general, the offer fields sku and product-id are always filled with the value that has been defined for the marketplace at the variation in the field Marketplace SKU. The offer field product-id-type is transferred with the value SHOP_SKU by default.

The product export field Product-ID (of the seller) is filled depending on the catalogue settings. During the first data transfer which takes place overnight, in plentymarkets, the marketplace SKU at the variation is automatically created from the Variation ID. Alternatively, the marketplace SKU can be defined via import or manually.

6.3. Updating product data

You can update the product data at any time. However, this does not apply to the following product data:

  • Packaging units

  • Manufacturer Part Number

  • Seller’s item number (Variation ID)

If you want to adjust one or several of the above-mentioned fields, you have to delete the product first and then transfer it again. To do so, proceed as follows.

Updating product data:

  1. Go to Setup » Settings » Properties » Configuration.

  2. Create a property of the type Text.

  3. Enter a name, for example Delete marketplace product.

  4. Go to Data » Catalogues.

  5. Open the corresponding catalogue.

  6. Map the property that you just created for deleting the product to the data field Invalidation Marking or InvalidationFlag.

  7. Open the assistant.

  8. Go to the step Offer properties mapping.

  9. Map the data field update-delete to the property Conrad Update-Delete.

  10. At the variation that you want to delete, select the selection value delete.
    Note: A change in stock or price at the variation may take some time. Alternatively, you can change it manually.

  11. Wait until the next offer transfer.
    → This can take up to 15 minutes.

  12. Deactivate the market availability for the marketplace and Mirakl at the variation.

  13. Remove the property for the catalogue link from the variation.

  14. Manually delete the product’s offer in the back end of the marketplace.

  15. At the respective variation, activate the property that you created for deleting the product and enter the value kill.

  16. Activate the property for the catalogue link at the variation.

  17. Wait until the next product transfer.
    → This takes place over night.

  18. Once you have deleted the product, you need to wait 24 to 48 hours until you can use the same Product ID again.

  19. As soon as the waiting time is over, remove the property that was created for deleting the product from the variation.

  20. Activate the market availability again for the marketplace and Mirakl.

6.4. Transferring order data

In this chapter, you will learn how to transfer order data to the marketplace and which requirements have to be met. The data comes from the ConradExtension assistant which you already completed.

6.5. Requirements for transferring order data

  • The plugins Conrad  and Mirakl Connector were purchased and downloaded from plentyMarketplace and installed in a plugin set.

  • The order referrers Conrad and Mirakl were activated in the Setup » Orders » Order referrer menu.

  • The basic settings were carried out in the Setup » Assistants » Plugins » [Select plugin set] » ConradExtension menu.

    • Synchronise stock is activated in the step data exchange so that the offers are transferred correctly.

  • In the Setup » Item » Sales prices menu, the order referrers Mirakl and Conrad have been activated on an existing price or a new sales price has been created for which the order referrers Mirakl and Conrad were activated.

Order data is transferred every 15 minutes. Only items that meet the following requirements are transferred:

  • The order referrers Mirakl and Conrad are activated at the variation.

  • A price that was activated for Conrad, Mirakl and WEB API is active at the variation.

  • A shipping profile that has been activated for Conrad, Mirakl and WEB API is active at the variation.

  • A value is specified for Conrad as marketplace SKU at the variation.

  • The stock or the price was changed at the variation within the last 15 minutes.

    • Setting a new time stamp via the group function or batch processing also results in a transfer of the variation. Thus, the stock limitation To net stock or None has to be selected at the variation and the variation needs to have positive stock.

What connection exists between the offer fields, the product export field and the marketplace SKU at the variation?

In general, the offer fields sku and product-id are always filled with the value that has been defined for the marketplace at the variation in the field Marketplace SKU. The offer field product-id-type is transferred with the value SHOP_SKU by default.

The product export field Product-ID (of the seller) is filled depending on the catalogue settings. During the first data transfer which takes place overnight, in plentymarkets, the marketplace SKU at the variation is automatically created from the Variation ID. Alternatively, the marketplace SKU can be defined via import or manually.

Further data fields that are transmitted during the offer transfer

  • sku and product-id: These fields are automatically filled with the value that has been specified as marketplace SKU at the variation.

  • product-id-type: This field is filled with the value SHOP_SKU by default.

  • price: This field is automatically filled with the value hat has been defined at the variation for the price that was activated on the marketplace. In case several sales prices were defined at the variation that are also available for the marketplace, the price with the lowest ID will be exported.

  • quantity: This field will be automatically filled with the net stock or the total net stock from the warehouses that have been selected in the ConradExtension assistant in the step Warehouse Selection.

  • min-quantity-alert: This field will be automatically transferred with the value 1.

  • state: This field will be automatically transferred with the value 11.

  • available-start-date: This field will be automatically transferred with a timestamp.

  • price-ranges: In this field, one or several sales prices will be transferred.

  • allow-quote-requests: This field will be automatically transferred with the value false.

  • logistic-class: This field is empty by default. If no value is transferred, the variation is linked to the free shipping profile Free shipping. In the assistant step Offer properties mapping you can map a property in order to transfer a different value per variation. You can find the valid shipping profile codes in the Conrad back end under Platform settings » Shipping. The codes are displayed in parentheses.

  • leadtime-to-ship: This is a mandatory field, which is empty by default. In the assistant step Offer properties mapping you can map a property in order to transfer a different value per variation. Only integers between 1 and 45 are valid here.

  • reversecharge: This is a mandatory field, which is empty by default. In the assistant step Offer properties mapping you can map a property in order to transfer either true or false per variation.

7. Setting the variation availability

You need to activate the variations that you want to sell on Conrad. This is done in the Availability tab of a variation within the Item » Edit item » [Open item] » [Open variation] menu.

Activating variation availability

Do not activate the availability on the variation until a marketplace SKU has been defined on the variation or the variation has been transferred via the product export.

Making a variation available for Conrad:

  1. Go to Item » Edit item » [Open item] » [Open variation] » Tab: Settings.

  2. Open the variation that you want to sell on Conrad.
    Tip: To sell all variations of an item on Conrad, carry out the settings for the item’s main variation. This activates the availability of all variations of the item.

  3. In the Availability area, activate the option Active.

  4. Click on the Availability tab.

  5. In the Markets area, click in the selection field.
    → A list of all available markets is displayed.

  6. Activate the option Conrad.

  7. Activate the option Mirakl.

  8. Click on Add ().
    → The market is added.

  9. Save () the settings.
    → The variation is available for Conrad.

The variation group function allows you to edit several variations at once. You select the variations that you want to edit.

Making several variations available for Conrad using the variation group function:

  1. Go to Item » Edit item.

  2. Set the filter Table type to Variations.

  3. Choose additional filters on the left if needed and click on Search ().

  4. Select () the variations to be edited from the overview on the right.

  5. Click on Variation group function.
    → The Variation group function window opens.

  6. Navigate to the area Market availability.

  7. Activate the checkbox to the left of the option Conrad.

  8. Activate the checkbox to the right of the option Conrad.

  9. Activate the checkbox to the left of the option Mirakl.

  10. Activate the checkbox to the right of the option Mirakl.

  11. Navigate to the area Availability.

  12. Activate the checkbox to the left of the option Active.

  13. Activate the checkbox to the right of the option Active.

  14. Click on Execute to apply the settings.

Batch processing allows you to edit several variations at once. You use filters to limit which variations are edited.

Making several variations available for Conrad using batch processing:

  1. Go to Item » Batch processing.

  2. Click on the tab Variations in the upper left corner.

  3. Use the filters on the left to specify which variations should be processed.

  4. Navigate to the area Market availability.

  5. Activate the checkbox to the left of the option Conrad.

  6. Activate the checkbox to the right of the option Conrad.

  7. Activate the checkbox to the left of the option Mirakl.

  8. Activate the checkbox to the right of the option Mirakl.

  9. Navigate to the area Availability.

  10. Activate the checkbox to the left of the option Active.

  11. Activate the checkbox to the right of the option Active.

  12. Click on Apply to apply the settings to the variations.


To top