Skip to main content

Elastic export: setup and use

There are many reasons to export data from your plentymarkets system. For example, you might want to:

  • transmit your item and variation data to marketplaces.

  • export a CSV file containing product data, warehouse data, order data etc. Afterwards, you can revise the file and import it again.

The elastic export is a good tool for doing so. It is a free plugin, which you can download from plentyMarketplace and add to your system.

How you proceed depends on what you want to achieve:

  1. Download the necessary plugins:

    1. Elastic Export

    2. So-called data format plugins for your chosen marketplaces.

  2. Configure the elastic export. While doing so, choose the data format for the corresponding marketplace.

  3. Transmit the CSV file to the marketplace.

  1. Download the necessary plugins:

    1. Elastic Export

    2. FormatDesigner

  2. Create so-called data formats with help from the FormatDesigner.

  3. Configure the elastic export. While doing so, choose the data format that you just created.

  4. Export the CSV file, modify it and re-import it into plentymarkets.

1. Downloading the plugins

Which plugins you should download depends on what exactly you want to achieve.

Table 1. Necessary plugins
I want to…​ Which plugins do I need?

Transmit products to marketplaces

Export, modify and re-import data

Plugin set linked to default client

Install the elastic export and the plugins for additional markets in a plugin set that is linked to the default client.

1.1. Elastic Export

The elastic export is a plugin. Download the plugin and install it in your plentymarkets system.

1.2. Plugins for marketplaces

The elastic export includes two so-called “data formats” by default. These data formats allow you to transmit your product and offer data to bol.com. Do you want to transmit data to other marketplaces? Download additional plugins from plentyMarketplace to widen the range of data formats available in Elastic Export.

Deploy the elastic export first

First deploy the elastic export plugin before you add data format plugins for other markets.

Overview of data format plugins

Table 2. Examples of other data formats available in plentyMarketplace
Export format Explanation

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.

CdiscountCOM

Items are sold on the market Cdiscount .

Check24

Items are sold on the market Check24 .

EcondaDE

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

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 characteristic 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 .

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.

RakutenDE

Items are sold on the market Rakuten .

ShippingProfiles

Use the format ShippingProfiles  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.

Have you registered on the marketplace?

Before you can transfer your data to a marketplace, you must have registered with that market.

1.3. FormatDesigner

Do you want to export a CSV file? For example, in order to modify the file and import it back into the system.

Then download the FormatDesigner plugin and use it to create your own, custom data formats. In other words, you’ll use FormatDesigner to decide which data should be exported.

2. Configuring elastic export

2.1. Creating new exports

  1. Go to Data » Elastic export.

  2. Click on New export.
    → The New export tab opens.

  3. Carry out the settings. Note Table 3.

  4. Save () the settings.
    → The export automatically receives a unique ID and is added to the overview.

Table 3. Settings for a new export
Setting Explanation

Name

Enter a name for the export. This is an internal name, i.e. it is not visible to customers. The export format is listed under this name in the overview.

Type

Which type of data do you want to export? Select this data type from the drop-down list.

Note: Additional filters and format settings appear when you select the type. Which exact settings appear depends on the type.

Format

Which data format do you want to export? Select this data format from the drop-down list.

Note: On the one hand, these are the data format plugins that you downloaded from plentyMarketplace. On the other hand, these are the data formats that you created yourself with the FormatDesigner.

Note: Which formats are included in this list depends on which type of data you selected above.

Limit

Enter a number. This number specifies how many data records should be exported at maximum.

Note: Do you want to transmit more than 9999 data records?

  • Then the output file will not be generated again for another 24 hours. This is to save resources.

  • Then also select the option Generate cache file further below.

Generate cache file
(Only for the type Item)

Select this option () if you want to transmit more than 9999 data records. We recommend that you do not activate this option for more than 20 export formats. This is to ensure a high performance of the elastic export.

Provisioning

How should other people access the export file? Select an access method from the drop-down list. The settings change depending on which method you choose.

Method Additional notes

URL

The file can be accessed externally. Third parties access the file with a URL and an authentication token.

Additional settings:

  1. Click on Generate token ().

  2. The token and URL will be entered automatically.

FTP;
FTPS;
SFTP

The file can be accessed externally. The file will be stored on a server.

Additional settings:

  1. Enter the access data for the server:

    1. Server: Which server should the file be stored on?
      Example: ftp.YourDomain.com

    2. Port: The standard FTP port is 21.

    3. User name/Password: Enter your access data.

    4. Path: Where should the file be saved? Enter the file path.

  2. Transfer How often should the data be transmitted? Select the option Schedule if you want to specify the exact times when data should be transferred.

Admin area

The file can not be accessed externally.

File name

Enter the file name and extension.

Note: Use placeholders to automatically add further information to the file name. For example, you can add the current date to the file name. The following placeholders are available: $name, $type, $format, $timestamp, $datetime, $year, $day, $hour, $minute, $numberRange

Examples:

  • file-name.csv

  • file-name_2020_10_25.csv

  • file-name_$year_$month_$day.csv

Placeholder number range

You can only use this option if the file name includes the placeholder $numberRange. Enter the highest value for the number range.

Filters and format settings

Which filters and format settings need to be configured depends on which type you selected. Expand the info boxes below () to learn more about the additional settings for each type.

No filters are set by default

Which data records should be exported? Use filters to limit which data is transferred. Otherwise, all data records will be transferred during export.

  1. Select a filter from the drop-down list.

  2. Click on Add.

  3. Define the filter settings.

  4. Repeat the process to add as many filters from the drop-down list as needed.

Attribute
Filter Explanation

Attribute

Limits the export to a specific attribute.

Language

Limits the export to attribute names saved in a specific language.

Category
Filter Explanation

Level

Limits the export to categories saved on a specific level.

Client

Limits the export to categories saved for a specific client.

Language

Limits the export to categories saved in a specific language.

Type

Limits the export to a specific category type.

Contact

The following filters are available:

  • Export all contact addresses

  • Rating

  • Owner

  • Referrer ID

  • IBAN

  • Contact ID

  • Contact group

  • Country

  • Direct debit mandate

  • Client

  • Type

Newsletter recipient

The following filters are available:

  • Contact group

  • Newsletter folder

Item
Item filters
Filter Explanation

Active

Limits the export to variations that are either active or inactive.

Category

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

Client

Limits the export to items that are available for a specific client.

Created date of the item

Limits the export to items that were created on a specific date.

Currency

Select a currency.

Default, bundle, bundle item

Limits the export to default items, bundles and bundle components.

Flag 1;
Flag 2

Limits the export to items that have a specific flag.

Image

Limits the export to items, which have an image saved for them.

Item type

Limits the export to a specific type of item.

Manufacturer

Limits the export to items that were manufactured by a specific company.

Markets

Limits the export to items that are available for a specific market.

Positive stock for given warehouse

Select a warehouse from the drop-down list. Limits the export to variations that are stored in this warehouse and have positive stock.

Positive physical stock for given warehouse

Select a warehouse from the drop-down list. Limits the export to variations that are stored in this warehouse and have positive physical stock.

Prices

Limits the export to items with a specific price.

Option Explanation

Without price

Items that don’t have a price will be transferred.

With price

Items that have a price will be transferred.

With price lower

Enter a price. Items that have a lower price will be transferred.

With price higher

Enter a price. Items that have a higher price will be transferred.

With price between

Enter a lower limit and upper limit. Items with a price between the two values are exported.

Stock

Select which stocks should be exported.

Tag (AND mode)

Enter one or more tag names. Items that are linked to all of the selected tags are exported.

Tag (OR mode)

Enter one or more tag names. Items that are linked to at least one of the selected tags are exported.

Updated date of the item

Limits the export to items that were last modified on a specific date.

Variations

Which type of variation should be transferred?

Option Explanation

Transfer all

All variations are transferred.

Only transfer main variations

Only main variations are transferred.

Do not transfer main variations

Only the item’s sub-variations are transferred. Main variations are not transferred. This option is useful 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.

Format settings
Setting Explanation

Product URL

Should the item’s URL or the variation’s URL be transferred? URLs of variations can only be transferred in combination with the Ceres online 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 will be added to the product URL if you selected the option Item URL or Variation URL 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 defines 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 Remove HTML tags option 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 * Permitted HTML tags, separated by comma (def. text)* field. 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 Remove HTML tags option 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 * Permitted HTML tags, separated by comma (def. text)* field. 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. Otherwise, the barcode 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 has to have this position.

Stock buffer

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

Stock for variations 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.

Sales 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, 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 Setup » Item » Availability menu.

Manufacturer
Filter Explanation

Manufacturer ID

Limits the export to manufacturers with a specific ID.

Position

Limits the export to manufacturers with a specific position number.

Item images

The following filters are available:

  • Item ID

  • Type

  • Markets

Order
Order filters

The following filters are available:

  • Order status

  • Update date

  • Order ID

  • Order type

  • Creation date

  • Referrer ID

  • Contact ID

  • Contact group

  • Warehouse

  • Delivery country

  • Shipping profile

  • Completion date

  • Method of payment

  • Payment date

  • Payment status

  • Estimated delivery date

Format settings
Setting Explanation

Change order status

If a status is selected, then all of the exported orders will be changed to this status.

Order item
Order item filters

The following filters are available:

  • Order status

  • Order item update date

  • Order update date

  • Order ID

  • Order referrer

  • Order type

  • Order creation date

  • Order item referrer

  • Manufacturer

  • Order item warehouse

  • Order warehouse

  • Delivery country

  • Order item type

  • Variation ID

  • Variation number

  • Shipping profile

  • Order completion date

  • Estimated delivery date

Format settings
Setting Explanation

Change order status

If a status is selected, then all of the exported orders will be changed to this status.

Property
Filter Explanation

Section

Limits the export to properties for a specific section.

Data type

Limits the export to a specific type of properties.

Warehouse

The following filters are available:

  • Warehouse

Listing

The following filters are available:

  • Item ID

  • Transmit item number type

  • Stock dependence

  • Error code

  • Error text

  • Error type

  • Enabled

  • Referrer ID

  • Unit combination ID

  • Account ID

  • LID

  • Warehouse

  • Layout template ID

  • Listing type

  • MLID

  • List with all variations

  • Verified

  • Language

  • Variation ID

  • Shipping profile

  • Directory ID

  • eBay category ID 1

  • eBay category ID 2

  • eBay shop category ID 1

  • eBay shop category ID 2

Active listings

The following filters are available:

  • Item ID

  • Transmit item number type

  • Stock dependence

  • End time

  • External listing ID

  • Error code

  • Error text

  • Error type

  • Enabled

  • Referrer ID

  • Unit combination ID

  • Account ID

  • LID

  • Warehouse

  • Layout template ID

  • Last sale

  • Listing type

  • MLID

  • List with all variations

  • Verified

  • Language

  • Start time

  • Status

  • Variation ID

  • Shipping profile

  • Directory ID

  • eBay category ID 1

  • eBay category ID 2

  • eBay shop category ID 1

  • eBay shop category ID 2

Stock

The following filters are available:

  • Active

  • Manufacturer

  • Warehouse

  • Flag 1

  • Flag 2

Stock movement

The following filters are available:

  • Item ID

  • Warehouse

  • Variation ID

Facet

The following filters are available:

  • Facet ID

  • Position

  • Type

Facet value

The following filters are available:

  • Facet ID

Facet value reference

The following filters are available:

  • Facet ID

  • Facet value ID

  • ID

  • Type

2.2. Searching for and editing existing exports

Open the menu Data » Elastic export » Tab: Exports to see an overview of all your previously created exports. You can use filters to limit which exports are shown.

Searching for and opening exports:

  1. Go to Data » Elastic export.

  2. Choose filters in the left column. Note Table 4.

  3. Click on Search ().
    → The results are shown on the right.

  4. Click on an export in the overview to open it and edit its settings.

Table 4. Filter settings for the elastic export
Filter Explanation

ID

Enter a number. The search results include the export with this ID.

Name

Enter a name or part of a name. The search results include exports with this name.

Type

Select a type from the drop-down list. The search results include exports with this type.

Format

Select a format from the drop-down list. The search results include exports with this format.

Resetting the search criteria

Click on Reset () to delete the search criteria. You can now start the search again.

Show and hide columns in the overview

You can decide which columns should be displayed. Point your cursor over the title bar and click on Customise the layout (). Activate or deactivate column names in the new window.

Toolbar

elastischer export symbolleiste
Figure 1. An export’s toolbar
Option Explanation

Save ()

Saves the settings.

ID

The export automatically receives this ID when it is created. It serves as a unique identifier and cannot be changed.

Copy ()

Creates a copy of the export with the same settings.

Download ()

Downloads the export file.

Last export change

Date and time when the export was last changed.

Export created at

Date and time when the export was created.

Delete ()

Deletes the export.

To top