Skip to main content

Elastic export

Use the Data » Elastic export menu to create export formats for price search engines, price comparison portals, markets and affiliate service providers in order to export data to the interface partners. In order to use the elastic export, install the plugin Elastic Export. The Elastic export plugin is available in the plentyMarketplace.

Further export formats for the elastic export are available in the plentyMarketplace. In order to use an export format for the elastic export, install a plugin in your plentymarkets system.

Plugin set linked to default client

Install the plugin Elastic Export and the plugins for the export formats in a plugin set that is linked to the default client.

1. Registering with an interface partner

Before you can transfer your export format to an interface partner, you will have to register on the partner’s website and follow the instructions given there. Refer to Table 1 for links to the price search engines, price portals, markets and affiliate service providers that have a plugin interface in plentymarkets. All data formats, except BolOfferExport and BolItemExport, have to be installed from the plentyMarketplace first.

2. Overview of export formats

Table 1. Export formats for the elastic export
Export format Description

AwinCOM

AWIN offers performance-based online and affiliate marketing.

BasicPriceSearchEngine

Use the format BasicPriceSearchEngine if you do not wish to select a specific price search engine. It can be used for most price search engines.

BeezUp

BeezUp is a tool for managing and improving the way items are presented in price comparison portals, on markets and with affiliate services.

BelboonDE

The affiliate network belboon specialises in the implementation of performance marketing measures.

BilligerDE

billiger.de is a TÜV certified German price comparison portal. The platform also offers test reports and customer reviews. Please note that this website is currently only available in German.

BolItemExport

Items are sold on the market bol.com. This export format is required for your item catalogue to be exported to bol.com. For further information about setting up bol.com in plentymarkets, refer to the Setting up bol.com page of the manual.
The export format BolItemExport is included in the ElasticExport plugin.

BolOfferExport

Items are sold on the market bol.com. This export format is required for your offers to be exported to bol.com. For further information about setting up bol.com in plentymarkets, refer to the Setting up bol.com page of the manual.
The export format BolOfferExport is included in the ElasticExport plugin.

CdiscountCOM

Items are sold on the market Cdiscount. For further information about this market, refer to the Setting up Cdiscount page of the manual.

Check24

Items are sold on the market Check24.

EcondaDE

econda offers a controlling solution for analysing and improving online stores comprehensively.

FashionDE

Fashion.de is a price comparison portal for fashion and lifestyle. Please note that this website is currently only available in German.

GeizhalsDE

Geizhals is an independent price comparison and information platform that specialises in hardware and consumer electronics. The plugin currently only matches the German platform.

GoogleShopping

The price comparison portal GoogleShopping offers search and comparison functions as well as links to the product pages in other online stores. Store owners can display their products in Google Shopping lists within the Google search. Stores are billed for the service per click. This format is based on Google Shopping International.
Therefore, linked property values and availabilities have to be saved in English.

GuenstigerDE

guenstiger.de is a price comparison portal that also offers customer opinions, test reports and seller reviews. Please note that this website is currently only available in German.

IdealoDE

idealo is a German price comparison portal that also offers test reports, price notifications and product comparisons. Please note that this website is currently only available in German.

KaufluxDE

Items are sold on the market Kauflux. For further information about the image gallery, refer to the Setting up Kauflux page of the manual.

KelkooDE

Kelkoo is a price comparison search engine for shopping and travel.

KuponaDE

KUPONA is an agency for online performance marketing. It is active in the fields of display performance advertising, retargeting, affiliate marketing and product data marketing.

MyBestBrandsDE

Mybestbrands is a recommendation platform for discounted fashion and lifestyle products, as well as for electronic products from well-known brand name manufacturers. Please note that this website is currently only available in German.

PreisRoboterDE

PreisRoboter is a product and price search engine that offers full text search and price comparisons. Please note that this website is currently only available in German.

RakutenDE

Items are sold on the market Rakuten. For further information about setting up Rakuten in plentymarkets, refer to the Setting up Rakuten page of the manual.

ShippingProfiles

Use this format to export shipping profiles.

Shopping24DE

shopping24 is a subsidiary of the Otto Group and an online portal for price and product comparisons. Please note that this website is currently only available in German.

ShoppingCOM

Shopping.com is an international product and price comparison service.

ShopzillaDE

Shopzilla is a price comparison platform.

TracdelightCOM

tracdelight is a network for advertising agencies and publishing companies that focus on fashion and lifestyle.

treepodia

treepodia offers you the possibility to automatically create product videos from item images and to integrate them into the item layouts in the online store.

TwengaCOM

Twenga is an international shopping platform that offers comprehensive price comparisons.

3. Creating export formats

This chapter teaches you how to create new export formats and which settings you can carry out. All data formats, except BolOfferExport and BolItemExport, have to be installed from the plentyMarketplace first.

Creating a new export format:

  1. Go to Data » Elastic export.

  2. Click on New export.

  3. Carry out the settings. Pay attention to the explanations given in Table 2.

  4. Save the settings.
    → The export format is given an ID and it appears in the overview within the Exports tab.

Item filters for the elastic export

Please note that no item filters for the elastic export are set by default. If you do not add any item filters, all items will be exported.

Table 2. Settings for a new export
Setting Description

Settings

Name

Enter a name. The export format is listed by this name in the overview within the Exports tab.

Type

Select the data type that should be exported from the drop-down list.

Format

Select a format for the export from the drop-down list. Only formats that were installed from the plentyMarketplace are available. Exception: BolOfferExport and BolItemExport.

Limit

Enter a number. If you want to transfer more than 9,999 data records to the interface, then the output file is not generated again for another 24 hours. This is to save resources. If more than 9,999 data records are necessary, the setting Generate cache file has to be active.

Generate cache file

Place a check mark if you want to transfer more than 9,999 data records to the interface. We recommend that you do not activate this setting for more than 20 export formats. This is to ensure a high performance of the elastic export.

Provisioning

Select URL, FTP or Admin area.
Different settings appear depending on which option is selected here.
URL: Use this option to generate a token for authentication in order to allow external access.
FTP: Server on which the file is saved.
Admin area: External access is not possible.

Token,
URL

If you have selected the option URL under Provisioning, then click on Generate token. The token is entered automatically. The URL is entered automatically if the token has been generated under Token.

Server,
Port,
User name,
Password,
Path,
Transfer

If you selected the option FTP under Provisioning, then enter the parameters. The standard FTP port is 21.
Transfer: If you selected the option FTP under Provisioning, then select an interval for the export. If you selected the setting Schedule, then select a time frame for the data transfer under Schedule.

File name

If you selected the option Admin area under Provisioning, then enter the file name. The file name has to have the ending of the file format, e.g. use the suffix .csv for a CSV file.

Item filters

Add item filters

Select the items you wish to export. Select an item filter from the drop-down list and click on Add. There are no filters set by default. It is possible to add multiple item filters from the drop-down list one after the other.

  • Variations = Select the variations to be transferred.

    • Transfer all = All variations are transferred.

    • Only transfer main variations = Only main variations are transferred.

    • Do not transfer main variations = Only the other variations of an item are transferred. Main variations are not transferred.
      Tip: Use this option if the main variations are virtual and not for sale.

    • Only transfer single variations = Only those main variations of items are transferred that only have a main variation and no other variations.

  • Markets = Select one market, several or ALL. The availability for all markets selected here has to be saved for the item. Otherwise, the export will not take place.

  • Currency = Select a currency.

  • Category = Activate to transfer the item with its category link. Only items belonging to this category are exported.

  • Image = Activate to transfer the item with its image. Only items with images are exported.

  • Client = Select a client.

  • Stock = Select which stocks you want to export.

  • Flag 1 - 2 = Select the flag.

  • Manufacturer = Select one, several or ALL manufacturers.

  • Active = Only active variations are exported.

  • Positive stock for given warehouse = Select a warehouse from the drop-down list that opens to only export variations with positive stock in this warehouse. Note: This stock filter only applies to FormatDesigner formats of the type Item.

Format settings

Product URL

Choose the URL that you wish to transfer to the interface. You can choose between the item’s URL and the variation’s URL. URLs of variations can only be transferred in combination with the Ceres store.

Client

Select a client. This setting is used for the URL structure.

URL parameter

Enter a suffix for the product URL if this is required for the export. This character string is added to the product URL if you have activated the transfer option for the product URL further up.

Order referrer

Mandatory field
Select the order referrer from the drop-down list. This setting depends on the selected order referrer and is needed for the SKU generation. The selected referrer is added to the product URL so that sales can be analysed later.

Marketplace account

Select the marketplace account from the drop-down list.

Language

Select the language from the drop-down list.

Item name

Select Name 1, Name 2 or Name 3. These names are saved in the Texts tab of the item.
Enter a number into the Maximum number of characters (def. text) field if desired. This specifies how many characters are exported for the item name.

Preview text

Select the text that you want to transfer as preview text.
Enter a number into the Maximum number of characters (def. text) field if desired. This specifies how many characters are exported for the preview text.
Activate the option Remove HTML tags if you want HTML tags to be removed during the export.
If you only want to allow specific HTML tags to be exported, then enter these tags into the field Permitted HTML tags, separated by comma (def. text). Use commas to separate multiple tags.

Description

Select the text that you want to transfer as description.
Enter a number into the Maximum number of characters (def. text) field if desired. This specifies how many characters are exported for the description.
Activate the option Remove HTML tags if you want HTML tags to be removed during the export.
If you only want to allow specific HTML tags to be exported, then enter these tags into the field Permitted HTML tags, separated by comma (def. text). Use commas to separate multiple tags.

Target country

Select the target country from the drop-down list.

Barcode

Select the ASIN, ISBN or an EAN from the drop-down list. The barcode has to be linked to the order referrer selected above. If the barcode is not linked to the order referrer, it will not be exported.

Image

Select Position 0 or First image to export this image.
Position 0 = An image with position 0 is transferred.
First image = The first image is transferred.

Image position of the energy label

Enter the position of the energy label. Every image that should be transferred as an energy label must have this position.

Stock buffer

The stock buffer for variations with limitation to the net stock.

Stock for variation without stock limitation

The stock for variations without stock limitation.

Stock for variations with no stock administration

The stock for variations without stock administration.

Live currency conversion

Activate this option to convert the price into the currency of the selected country of delivery. The price has to be released for the corresponding currency.

Retail price

Select gross price or net price from the drop-down list.

Offer price

Activate to transfer the offer price.

RRP

Activate to transfer the RRP.

Shipping costs

Activate this option if you want to use the shipping costs that are saved in a configuration. If this option is activated, then you are able to select the configuration and the payment method from the drop-down lists.
Activate the option Transfer flat rate shipping charge if you want to use a fixed shipping charge. If this option is activated, a value has to be entered in the line underneath.

VAT note

Enter text. This amount includes the VAT but does not include shipping.

Item availability

Activate the overwrite option and enter item availabilities into the fields 1 to 10. The fields represent the IDs of the availabilities. This overwrites the item availabilities that are saved in the menu System » System settings » Item » Availability.

4. Editing export formats

All of the export formats that you created are displayed in the overview in the Data » Elastic export » Tab: Exports menu. Use the Customise the layout function to select the columns to be displayed. Point your cursor over the tool bar and click on Customise the layout. A Customise the layout window opens and you can activate or deactivate the columns. The following columns are available:

  • ID

  • Name

  • Download

  • Type

  • Format

  • Limit

  • Last export change

  • Export created at

  • Delete

Open an export format to check or edit its settings.

Editing an export format:

  1. Go to Data » Elastic export.

  2. Open the export format.

  3. Carry out the desired changes. Pay attention to the explanations given in Table 2 and Table 3.

  4. Save the settings.

An export format’s tool bar
Figure 1. An export format’s tool bar
Table 3. An export format’s tool bar
Icon Description

Save

Save the settings.

ID

ID of the export format. The ID is assigned automatically.

Copy

Copy the export format with all of its settings.

Download

Download the export file.

Last export change

Date and time when changes were last made.

Export created at

Date and time when the export was created.

Delete

Delete the export format.

5. Filtering export formats

You can use specific criteria to filter your export formats. This helps to reduce the results displayed in the Exports tab.

Filtering export formats:

  1. Go to Data » Elastic export.

  2. Carry out the settings in the Filter section. Pay attention to the explanations given in Table 4.

  3. Click on Search.

Table 4. Filter settings in the Data » Elastic export menu
Filter Description

ID

Enter the ID to search for the variation with this ID.

Name

Enter part of a name or the full name.

Type

Select the type item or All from the drop-down list.

Format

Select a format from the drop-down list. A list of all the export formats that match the selected format will be displayed.

Deleting search criteria

Click on Reset to delete the search criteria. Then click on Search again. All of your export formats will be displayed in the overview and you can select new filters.

To top