KUPONA

Download KUPONA plugin

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

1. Registering with Kupona.de

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

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

By installing this plugin you will receive the export format KuponaDE-Plugin. Use this format to exchange data between plentymarkets and KUPONA 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 KuponaDE-Plugin. For more information on export formats, see the elastic export page.

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

Creating a new export format:

Go to Data » Elastic export.
Click on New export ().
Carry out the desired settings. Pay attention to the information given in Table 1.
Note: There are no item filters set by default. If you do not add any item filters, all items are exported.
Save () the settings.
→ The export format KuponaDE-Plugin is given an ID.
→ The export format is shown in the Exports overview.
Save the URL displayed in the URL field at KUPONA.

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

Table 1. Format settings and recommended item filters for the format **KuponaDE-Plugin**
Setting	Explanation
Settings
Name	Enter a name. The export format is listed under this name in the overview in the Exports tab.
Type	Select the type item from the drop-down list.
Format	Select KuponaDE-Plugin.
Limit	Enter a number. If you want to transfer more than 9,999 data records to the interface, the output file will not be generated again for another 24 hours. This is to save resources. If more than 9999 data records are necessary, activate the option Generate cache file.
Generate cache file	Activate this option if you want to transfer more than 9999 data records to the interface. *Note:* 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	Select URL. Use this option to generate a token for authentication in order to allow external access.
Token, URL	Click on Generate token. → The token is entered automatically. → A URL is created in the field URL.
File name	The file name must have the ending .csv or .txt for KUPONA to be able to import the file successfully.
Item filters
Add item filters	Select the items you wish to export. Select one or more of the following item filters from the drop-down list and click on Add. There are no filters set by default. It is possible to add all of the item filters listed below 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 variations of an item are transferred. Main variations are not transferred. *Tip:* Use this filter option if the main variations are virtual and not for sale. Only transfer single variations = Only the main variations of items are transferred that have only a main variation and no other variations. Markets = Select one or more order referrers. The selected order referrer has to be active at the variation for the item to be exported. Currency = Select a currency. Category = Activate to transfer the item with its category link. Only items that belong to this category are exported. Image = Activate to transfer the item with its image. Only items with images are transferred. Client = Select a client. Stock = Select which stocks should be exported. Flag 1-2 = Select a flag. Manufacturers = Select one, several or ALL manufacturers. Active = Activate if you only want to export active variations.
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. *Note:* 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 is added to the product URL if you have activated the transfer option for the product URL further up.
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 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. 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 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) field. Use commas to separate multiple tags.
Target country	Select the target country from the drop-down list.
Barcode	Select the ASIN, ISBN or a GTIN from the drop-down list. *Note:* The barcode has to be linked to the order referrer selected above. Otherwise, the barcode will not be exported.
Image	Select First image.
Image position of the energy label	This option does not affect this format.
Stock buffer	This option does not affect this format.
Stock for variation without stock limitation	This option does not affect this format.
Stock for variations with no stock administration	This option does not affect this format.
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	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 flat rate shipping charge. If this option is activated, a value has to be entered in the line underneath.
VAT note	This option does not affect this format.
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.

3. Available columns for the export file

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

Downloading the export file:

Go to Data » Elastic export.
In the line of the format KuponaDE-Plugin, click on Download ().
→ The file is downloaded and saved on your computer.
Open the export file with an appropriate program.

Table 2. Available columns of the export file for the export format **KuponaDE-Plugin**
Column header	Explanation
prod_number	The variation ID of the variation
prod_name	According to the format setting Item name.
prod_price	The sales price of the variation
prod_price_old	The sales price of the variation. If the RRP is activated in the format setting and is higher than the sales price, the RRP is exported.
currency_symbol	The ISO3 Currency code of the prices
prod_url	The URL path of the item depending on the chosen client in the format settings
category	The names of the categories that are linked to the variation, separated by >
category_url	Empty
valid_from_date	Empty
valid_to_date	Empty
prod_description	According to the format setting Preview text
prod_description_long	According to the format setting Description
img_small	The image preview URL. Variation images are prioritised over item images.
img_medium	The image middle URL. Variation images are prioritised over item images.
img_large	URL of the image. Variation images are prioritised over item images.
ean_code	According to the format setting Barcode
versandkosten	According to the format setting Shipping costs
lieferzeit	The name of the item availability saved in the Setup » Item » Availability menu or the translation according to the format setting Overwrite item availability
platform	Empty
grundpreis	The unit price information in the format `price / unit` *Example:* 10.00 EUR / kilogram

4. License

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