Skip to main content

billiger.de

Download billiger.de plugin

To export item data to billiger.de, you need the plugins billiger.de  and Elastic export. You can download the plugins in the plentyMarketplace .

1. Registering with billiger.de

billiger.de is a German price comparison portal certified by TÜV. The platform also offers test reports and customer reviews. This website is currently only available in German. In order to set up the billiger.de plugin in plentymarkets, you have to register with billiger.de  first.

2. Setting up the data format BilligerDE-Plugin in plentymarkets

By installing this plugin you will receive the export format BilligerDE-Plugin. Use this format to exchange data between plentymarkets and billiger.de using the elastic export. You also need to install the plugin Elastic export from the plentyMarketplace first before you can use the format in plentymarkets.

Once both plugins are installed in your plentymarkets system, you can create the export format BilligerDE-Plugin. For more information on export formats, see the elastic export page.

billiger.de retrieves item data via an URL. To make sure that your item data can be exported to billiger.de, you have to save the URL at billiger.de.

Creating a new export format:

  1. Go to Data » Elastic export.

  2. Click on New export ().

  3. Carry out the desired settings. Pay attention to the information given in Table 1.

  4. Save () the settings.
    → The export format BilligerDE-Plugin is given an ID.
    → The export format is shown in the Exports overview.

  5. Save the URL displayed in the URL field at billiger.de.

Table 1 lists details for settings, format settings and recommended item filters for the format BilligerDE-Plugin.

Table 1. Format settings for BilligerDE
Setting Explanation

Settings

Name

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

Type

Select the type item from the drop-down list.

Format

Select BilligerDE-Plugin.

Limit

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

Generate cache file

Activate if you want to transfer more than 9999 data records to the price search engine. 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. Use this option to generate a token for authentication in order to allow external access.

Token, URL

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

File name

The file name must have the ending .csv for billiger.de to be able to import the file successfully.

Item filters

Add item filters

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 = Transfer all or Only transfer main 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 will be transmitted.

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

  • Client = Select a client.

  • Stock = Select which stocks you want to export.

  • Flag 1 - 2 = Select a flag.

  • Manufacturer = Select one, several or ALL manufacturers.

  • Active = Only active variations will be exported.

Format settings

Product URL

Choose the URL that you wish to transfer to the price search engine. 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. If you activated the transfer option for the product URL further up, then this character string is added to the product URL.

Order referrer

Select the order referrer that should be assigned during the order import from the drop-down list. The selected referrer is added to the product URL so that sales can be analysed later.

Marketplace account

Select a 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. The 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 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 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 First image.

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.

Sales price

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

Offer price

This option does not affect this format.

RRP

Activate to transfer the RRP.

Shipping costs

The shipping costs according to the format setting Shipping costs will be transferred.

VAT note

This option does not affect this format.

Item availability

The name of the item availability in the Setup » Item » Availability menu.
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.

3. Available columns for the export format

Open the export format BilligerDE-Plugin in the Data » Elastic export menu to download and edit the export file.

Downloading the export file:

  1. Go to Data » Elastic export.

  2. In the line of the format BilligerDE-Plugin, click on Download ().
    → The file is downloaded and saved on your computer.

  3. Open the export file with an appropriate program.

Table 2. Available columns of the export file for the export format BilligerDE-Plugin
Column header Explanation

aid

Mandatory field
The SKU based on the variation ID, if no SKU was configured before.

brand

Mandatory field
The name of the manufacturer of the item. The external name saved in the Setup » Item » Manufacturers menu is preferred if existing.

mpnr

Mandatory field
The model of the variation.

ean

Mandatory field
According to the format setting Barcode.

name

Mandatory field
According to the format setting Item name.

desc

Mandatory field
According to the format setting Description.

shop_cat

Mandatory field
Category path of the standard category for the Client configured in the format settings.

price

Mandatory field
The sales price of the variation.

ppu

Mandatory field
The base price of the variation.

link

Mandatory field
The product URL of the variation.

images

Mandatory field
First image of the variation.

dlv_time

Mandatory field
According to the format setting Item availability.

dlv_cost

Mandatory field
According to the format setting Shipping costs.

pzn

Mandatory field
The value of the characteristic pzn.

promo_text

The value of the characteristic promo_text.

voucher_text

The value of the characteristic voucher_text.

eec

The value of the characteristic eec.

light_socket

The value of the characteristic light_socket.

wet_grip

The value of the characteristic wet_grip.

fuel

The value of the characteristic fuel.

rolling_noise

The value of the characteristic rolling_noise.

hsn_tsn

The value of the characteristic hsn_tsn.

dia

The value of the characteristic dia.

bc

The value of the characteristic bc.

sph_pwr

The value of the characteristic sph_pwr.

cyl

The value of the characteristic cyl.

axis

The value of the characteristic axis.

size

The value of the characteristic size.

color

The value of the characteristic color.

gender

The value of the characteristic gender.

material

The value of the characteristic material.

class

The value of the characteristic class.

features

The value of the characteristic features.

style

The value of the characteristic style.

old_price

The price of the variation compared to the RRP. The higher price will be preferred.

images

Further images of the variation (separated by comma).

own_brand

yes if no ean was found, otherwise no.

delivery_sop

The value of the characteristic delivery_sop. The name of the characteristic in the plentymarkets back end is Available for sale, under SOP (Solute Order Platform).

stock_quantity

Limitation: from 0 to 9999
Content: The net stock of the variation. If a variation is not limited to its net stock, the stock is set to 999.

4. License

This project is licensed under the GNU AFFERO GENERAL PUBLIC LICENSE. Find further information in the file LICENSE.md .

To top