Custom CSV Feeds (Dokumentation » APIs)

Create a feed

The creation of a feed is identical for each partner program / network. For this reason we save the explanation with the individual networks (below) and summarize it here. How to get the CSV files of the shops is explained below, separately for each network / shop.

First you have to install our plugin. If you have an active license, you can find it in your Dashboard. Otherwise you can renew your license and use it directly.

In the backend of your website you will now find an entry called “Import / Custom CSV”.

You already know most of the tabs from other interfaces, but we’d like to take a look at each of them here.

Settings: For example you can control the settings:

whether imported products should be published directly
if you want to import a (short) description as well
which data should be updated automatically

Feeds: The heart of the new system are the feeds. You can add new CSV files via the “Add Feed” button. When you click on this button you will get a popup with 3 simple queries.

Name: The name is important for the search. So please do not enter “testfeed_NEW123”, but if you have for example packed all Nike products from the Otto-Shop into one CSV file, best “otto.de – Nike” or if it is the complete feed, only “otto.de”. However, the name is not relevant for the function.
Importer Template: Here you have to choose from which shop / network your CSV file comes, so that we can assign the fields / columns correctly. We will extend this list in the course of time. You can express your wishes in our forum
Feed-URL: Here the link to the CSV file is deposited, which pulls your page daily. Where you can find the CSV file of each shop, you can read below.

In a tabular list below you will find your previous feeds, with some information, such as the number of products, the import status, etc.. Using the icons on the right you can manually renew, edit or delete a single feed.

Search: The search works like any other API. Simply enter your search term, select the feed you want to search and optionally set some filter options on the right side. Then you can import the products from the table below.

API-Log: In this tab you find an overview of the system messages concerning the cronjob.

Buttons: Here you can enter the name of the individual buttons in the short (Grid, Table) and long (List, Single) variants. With the placeholder %s you can display the shop name to give your button the label “buy now at endcore.com“.

Help: As usual you will find more information about the documentation on our site here.

Instruction for AWIN

After the merge of zanox and affilinet, AWIN is the largest German affiliate network and offers you a multitude of shops. As there is no webfeed (API) yet, as it used to be the case with both networks, and AWIN probably doesn’t want to change anything about it, we are now using the CSV file processing solution. How to generate a CSV is now explained to you.

Step 1: First you have to log into the backend of AWIN with your partner account. If you don’t have an account yet, you can log in here.

Step 2: Navigate to “Tools > Create-a-Feed”. (You don’t have this point? Then you do not yet have an active advertiser with the corresponding data for feeds.)

Step 3: In the first step you have to select the desired data (Screenshot). You have the possibility to filter your feed by category, advertiser and brand. You should filter your feeds as much as possible to keep the amount of data low. The smaller the feed, the faster it can be processed.

Step 4: In the next step you still have various options for the content of the feed. We recommend to check “EAN” (Screenshot) in addition to the default settings. You can also add “large_image” under “Images” if the feed does not provide images for all products. Since version 1.4.6 you can use “product_price_old” to get an old price. For “Data feed properties” please make the following settings: (Screenshot)

Format of the data feed: CSV
Field separator: (comma)
Compression type: zip

Step 5: Create a new feed with the template “AWIN” in the backend of the CSV importer and use the copied feed URL.

Instruction for MediaMarkt

After MediaMarkt (and Saturn) had been listed on affilinet and Zanox for a long time, it seems that the merging of the two networks is not what Media-Saturn-Holding imagines for its future. For this reason, there has recently been a separate partner program for the well-known electronics shops.

Step 1: First you have to log into the MediaMarkt Backend with your partner account. If you don’t have an account yet, you can log in here.

Step 2: Then click on “Campaigns > Product data“. Select the desired feed on the left side.

Step 3: You can now filter the feed further in the lower area (Screenshot), e.g. according to a keyword (e.g. TV) or according to a manufacturer (e.g. Apple). You can use a * (asterisk) as wildcard.

Step 4: If you have set a filter, please copy the CSV format URL from the lower text field under the tab “Filtered Feed-Links” (Screenshot). Otherwise please copy the CSV-format URL from the upper area “Standard Feed-Links” (Screenshot)

Step 5: Create a new feed with the template “MediaMarkt” in the backend of the CSV importer and use the copied feed URL.

Instruction for Saturn

You don’t have to explain much more about Saturn. The bottom line is that it’s the same system as MediaMarkt’s only in ~~green~~ um orange.

Step 1: First you have to log into the Backend of Saturn with your partner account. If you don’t have an account yet, you can login here.

Step 2: Then click on “Campaigns > Product data“. Select the desired feed on the left side.

Step 5: Create a new feed with the template “Saturn” in the backend of the CSV importer and use the copied feed URL.

Instruction for Webgains

Also at Webgains we (and many of our users) begged for a long time that they should provide a decent API. Unfortunately without success. So what, with the Custom CSV Importer you can now easily create your own CSV feeds from Webgains and integrate products from all your stores into your affiliate project.

Step 1: First you have to login with your partner account to the Backend of Webgains. If you don’t have an account yet, you can login here.

Step 2: Then click on “Advertising media > Create a product feed”. Select the desired programs whose data you would like to receive.

Step 3: In the step “Category selection” you can filter the data by categories. We recommend to keep the feed as “small” as possible – because many web spaces with large amounts of data might have problems. (Screenshot)

Step 4: In the step “Formatting options” you can edit the columns of the CSV file. We recommend the default setting. (Screenshot)

Step 5: In the last step “Download options” you leave the settings on default (CSV separator: “comma”, compression: “none”) and copy the URL in the lower text field “Download from a URL”. (Screenshot)

Step 6: Create a new feed with the template “Webgains” in the backend of the CSV importer and use the copied feed URL.

Instruction for Otto

Otto has also turned its back on affilinet and now AWIN and launched its own internal partner program. With our new CSV Importer, it only takes a few clicks to bring Otto’s database into your affiliate project. The dashboard is similar to that of MediaMarkt and Saturn.

Step 1: First you have to log into the Backend of Otto with your partner account. If you don’t have an account yet, you can log in here.

Step 2: Then click on “Campaigns > Product data“. Select the desired feed on the left side.

Step 5: Create a new feed with the template “Otto” in the backend of the CSV importer and use the copied feed URL.

Instruction for Cyberport

The procedure is identical to MediaMarkt, SATURN and Otto. Therefore, we have not made any new screenshots.

Schritt 1: First you have to login with your partner account to the Backend of Cyberport. If you don’t have an account yet, you can login here.

Schritt 2: Then click on “Campaigns > Product data“. Select the desired feed on the left.

Schritt 3: You can now filter the feed further in the lower area (Screenshot), e.g. according to a keyword (e.g. TV) or according to a manufacturer (e.g. Apple). You can use a * (asterisk) as wildcard.

Schritt 4: If you have set a filter, please copy the CSV format URL from the lower text field under the tab “Filtered Feed-Links” (Screenshot). Otherwise please copy the CSV-format URL from the upper area “Standard Feed-Links” (Screenshot)

Schritt 5: Create a new feed with the template “Cyberport” in the backend of the CSV importer and use the copied feed URL.

Instruction for Connects

Step 1: First you have to login with your partner account to the Backend of Connects. If you don’t have an account yet, you can login here.

Step 2: Then click on “Programs > My Partnerships“. Select your desired program on the right side and click on “More information”.

Step 3: If this program provides product data, you can click on product data on the left side (Screenshot).

Step 4: Do not change column names, otherwise our script will lose the assignment to the individual columns. Just copy the CSV-URL below and make sure that all check marks are set. (Screenshot).

Step 5: Create a new feed with the template “Connects” in the backend of the CSV importer and use the copied feed URL. In this case, the name of the feed will also be used as the shop name for all products. Make sure that the name is meaningful.

Other Shops?

We know there are a lot of other shops that weren’t mentioned up here. You are welcome to wish for more shops in our forum and we bring new import possibilities in upcoming updates. But since each shop has a completely different CSV, we have to migrate the whole thing with specially built templates into a format that our theme can work with.

War dieser Artikel hilfreich?