affilinet Product Data Import

Introduction

Product data is a very attractive feature in addition to classical ads and textlinks. Some of the key facts are:

  • more acceptance of users
  • higher reach of publishers and a
  • higher conversion rate in the order process because of directing the user through to a product specific landing page.

The update of product data occurs on a regular basis. affilinet downloads the data at the advertiser’s given source and imports it in the affilinet data base.

Data record structure

Please note: Read the following instructions attentively to provide all necessary information we need to set up your product data feed properly without problems.

On the publisher’s side, we provide the data as a CSV and XML file and additionally through our affilinet web services (API based).

You can provide one or more files, whichever you prefer. We provide the same amount of files to the publishers. Each feed should contain no more than 1 million products.

Please provide the following information for each of your feeds:

  • URL: Source url to download the file (http, https, ftp, sftp)
  • Interval: every 2nd day, daily, several times a day (e.g. 4:00, 17:00, etc), hourly
  • Format: CSV, XML, TXT
  • Username: if applicable
  • Security: If you have blacklists in place please let us know

We recommend that you provide a demo data file so that we can check the content and can configure our system.

Regardless of if you provide your data feed as XML or CSV, you have to make sure to provide at least the mandatory information set. Otherwise we can’t import the file into our database. Please find the list of data fields on the following pages.

In the following lists below you can find all details for a proper import. If you are an advertiser from the mobile sector, please take note of the additional fields in the next table.

If you have put together all data from your side, please send all requested data to productdata@affili.net.

In case you have additional data fields, you can add them yourself. Beware that these fields will be added at the end of the export, as provided by you.

Data record structure for non-mobile-network-advertiser

Parameter Description Type of data
(character limit)
ArtNumber required Unique ID – i.e. article number (if possible the same ID as provided in the web shop) String (50)
Category required Path of product categories - i.e.: Women > Clothing > Skirts String (250)
Title required Product name String (250)
DescriptionShort Product description (short String (500)
Description required Product description String (4500)
PricePrefix Additional text, placed in front of the price String (25)
Price required Price inc. VAT Decimal symbol
PriceSuffix Additional text, placed behind the price String (50)
PriceOld Old price OR retail price incl. VAT Decimal symbol
Currency EUR, GBP, CHF; used for product price, shipping cost and base price, if applicable. String (3)
(ISO 4217)
ImgUrl required Link to product image (absolute http(s)://...) String (200)
Deeplink1 required Deeplink to the product (absolute http(s)://...) String (1500)
Deeplink2 Additional deeplink (absolute http(s)://...) String (1500)
Keywords Keywords, relevant for the product String (250)
Manufacturer e.g Nestlé String (100)
Brand e.g. Nespresso String (100)
Distributor Distributor – i.e. for books or DVDs String (100)
ValidFrom Start of offer yyyy-mm-ddThh:mm:ss
ValidTo End of offer yyyy-mm-ddThh:mm:ss
EAN required 13- or 14-digits EAN-ID of the product (European Article Number) String (14)
ShippingPrefix Text in front of shipping cost String (25)
Shipping required Shipping cost Decimal symbol
ShippingSuffix Text behind of shipping cost String (50)
BasePricePrefix Text in front of the BasePrice String (25)
BasePrice* Price per unit (if mandatory by law) Decimal symbol
BasePriceSuffix Definition of the unit i.e. per 100ml String (50)
EfficiencyClass** e,g, „A+++“, „B“ or „C“, String (6)
Availability Availability of the article String (50)
DeliveryTime Delivery time String (25)
ISBN For books only String (17)
Size Size of the item String (50)
Gender Gender String (50)
Color Color String (50)
NutritionInformation Nutrition information String (200)

  • * Mandatory at products with legal requirement (base price)
  • ** Mandatory at products on statutory labeling requirement.
  • * and ** legal requirements in Germany

Additional dataset for mobile phone / mobile network advertiser

Parameter Description Type of data
(character limit)
phone_model Model – e.g. „8800“ String (50)
phone_operator required Mobile network provider – Please use this syntax only!: t-mobile“/“o2“/„vodafone“/„eplus“ String (50)
base_fee e.g.. „19.90“ Decimal symbol
free_minutes Free minutes / month - e.g. „100“ Decimal symbol
free_texts Free-SMS / month- e.g. „20“ Decimal symbol
contract_obligation Binding contract – „yes“ or „no“ String (50)
number_portability number Portability – „yes“ or „no“ String (50)
contract_duration Contract length (in Months, e.g. „12“) Decimal symbol
starting_balance Start account balance – e.g. „9.99“ Decimal symbol
clockrate Clocking – e.g. 60/60 String (50)
charge_landline Price per minute landline – e.g. „0.09“ Decimal symbol
charge_other_networks Price per minute foreign networks– e.g. „0.12“ Decimal symbol
charge_own_network Price per minute home network – e.g. „0.09“ Decimal symbol
texts_charge Price per SMS – e.g. „0.15“ Decimal symbol
commission Deposit for device Decimal symbol
service_fee Access fee Decimal symbol

Basic Guideline

Creating a CSV file

  • For import only CSV or TXT is allowed (no Excel)
  • It’s possible and recommended to upload compressed (.gz / .zip) files. If you use compressed files, then the URL needs to end in .gz or .zip.
    Example: ttp://www.yoururl.de/productdata.csv.gz.
    The same rules apply to scripts that provide the file.
    Example: http://www.ihre-url.de/script.php?name=Filename.gz
  • Zip-Files can only contain one (1) file. Subfolders are not allowed.
  • The first row needs to contain headlines for each column.
  • Every row needs to have the same amount of columns.
  • For each dataset you need to use one (1) row.
  • For the column separator you can use semicolon, tabulator, comma, pipe (|), caret (^), $ and hashtag (#).
  • All cells containing strings need to be covered by a text delimiter (e.g. " or '). Ideally all cells (including cells with decimal values) should be covered by a text delimiter.
  • Don’t forget to have a pair of text delimiters after a column separator. Example (text delimiter " and column separator | ): "0/8/15"|"A nice product."|"12.00"|“http://www.yoururl.de//bild.jpg“. Remember, you are not allowed to use the column separator in the content. If so you have to mask it. (Recommended separator: Pipe (|), tabulator or caret (^))
  • For a decimal symbol only dot (.) or comma (,) is allowed.
  • Numbers bigger than 1000 are not allowed to contain a thousand separators.
  • In fields where values are expected (allowed: numbers, comma (,), dot (.), minus (-) or plus (+)) all other characters will be ignored.
    Example: EUR11 = 11 or 11,- = 11)).

Creating a XML file

  • If you import data by an xml file, then this needs to end with.xml or .XML
  • It’s possible and recommended to upload compressed (.gz / .zip) files. If you use compressed files, then the URL needs to end with.gz or .zip.
    Example: http://www.yoururl.de/produktdaten.xml.gz.
    The same rules apply to scripts that provide the file.
    Example: http://www.ihre-url.de/script.php?name=Filename.gz
  • Zip-Files can only contain one (1) file. Subfolders are not allowed.
  • If you provide xml feeds already in other affiliate networks, then you can normally use this also with affilinet.
  • In the structure of the feed, each item needs to contain all information of itself.

    Example:

    		<Product> 
    			<ArticleNumber>0000</ArticleNumber> 
    			<Title>Productname</Title> 
    			<Price>123,45</Price> 
    			... 
    		</Product>
    		<Product> 
    		...
    		</Product>
    		

    NOT this way:

    		<Prices> 
    			<Product id=0000>123,45</Product>
    			<Product id=0001>98,76</Product> 
    			...
    		</Prices> 
    		<Titles> 
    			<Product id=0000> Productname 1</Product> 
    			...
    		</Titles>
    		

    The same tag name can’t be used for different purposes. Structures like this are NOT allowed.

    		<Product> 
    		   <Image> 
    		      <URL>http://....</URL> 
    		   </Image> 
    		   <Deeplink>
    		      <URL>http://....</URL> 
    		   </Deeplink>
    		 ...
    		</Product>
    		

  • For decimal symbols,only dot (.) or (comma (,) are allowed.
  • Numbers bigger than 1000 are not allowed to contain a thousand separators.
  • In fields where values are expected (allowed: numbers, comma (,), dot (.), minus (-) or plus (+)) all other characters will be ignored.
    Example: EUR11 = 11 or 11,- = 11)).
  • Properties of items can be provided either in form tags (e.g. <ProductName>Nokia 8880</ProductName>) or as properties (e.g.: <Product name=“Nokia 8880“>)
  • XML feeds need to contain at least two (2) items.

Special features for individual fields

Category

If a category contains several steps, then you need to provide the whole path divided by a delimiter that you must let us know. In this case you need to provide the path in this order: ‚MainCat > SubCat > DetailCata‘. Delimiter „>“ (greater than).

If your data set contains additional categories, then you need to provide them in a separate column. In this case you have to use the following order: MainCat, SubCat, DetailCat (seperator „;“ semicolon).

PricePrefix and PriceSuffix

If you have legal requirements to show additional price information in the price tag, then you can provide them here.

Example:
PricePrefix: “up to”
Price: “19.99”
PriceSuffix: “incl. VAT”

We provide not only the field price but also the „DisplayPrice“. Publishers can / should use this price to provide the price exactly as given with your price pre and suffix. It shows as PricePrefix, Price, PriceSuffix and currency symbol.

ImageURL

All URLs need to be absolute (http://www.your-url.de/pics/handy123.jpg).

Please provide us only the biggest image. We will resize it and provide the resized versions on our servers. In addition we provide the original link for the publishers.

The hosting server should support https requests in any case! Only then you can guarantee that images will be served if publishers try to modify the url to a secure connection. Another option is to provide all images via https urls by default.

Base price

Many countries do have legal rules to provide a base price.
Please check your local laws to make sure you provide the correct data.

Example:
UnitPricePrefix: „equivalent “ UnitPrice: „5.99“ UnitPriceSuffix: „per 100 ml“

Title and Description_short

In these cells, no HTML is allowed. Except: <br> or </br>.

Description

If this field already contains html where a link could be inside, then you need to make sure that it’s an absolute link. Furthermore the links should use the “target=_blank“.

Compressed (zipped) files

It’s possible and recommended to upload compressed (.gz / .zip) files. If you use compressed files, then the URL needs to end with .gz or .zip.

Example: http://www.yoururl.de/productdata.csv.gz.

The same rules apply to scripts that provide the file.
Example: http://www.yoururl.de/script.php?name=Filename.gz

Zip-Files can only contain one (1) file. Subfolders are not allowed.

Changes to the file structure

Please note: If there are any kind of feed changes required, read the following instructions and send your request immediately to productdata@affili.net.

If there are changes to the file structure, then you must inform affilinet immediately and ideally before you apply your new URL link to the server!

Please try to avoid any major changes, especially with regards to the order of the columns in CSV files.

If you have to add additional columns in your CSV file, please add them only at the end of the structure. Please inform us immediately, that we can adjust the system settings.

Changes will be reviewed and approved by affilinet. After this process the new structure is available for publishers. Please keep in mind that this is a manual process, so please understand that this may take some time.

Please take care that no changes will go live from your side, without any information being passed through to affilinet. Worst case scenario, the feed data will be corrupt and publishers will be unable to download the file – hence affilinet will have to deactivate the feed.

Logos

Logos can be uploaded in the advertiser interface. You can store several sizes within the settings in „product list options“. Logos are mandatory.

http://advertiser.affili.net/ProductData/Productfeedsettings.aspx?nr=1&pnp=60
(Link works only if you are logged in already in the advertiser interface.)

Download times and intervals

To provide the most up to date data to your publishers, we recommend you to set the file upload for our system after the refresh in your system has been finished.

You can specify the interval by yourself.

Example: every second day, once a day, two times a day (e.g. 4 am, 5 pm), hourly

Please set the import times as detailed as necessary due to the massive traffic load.