Mouseflow:
top of page

Feed - Ecommerce

AD SPECIFICATIONS

Converto's Feed Specifications

Information

With the following checklist, your Display ads are ready to be promoted through Converto's Grid20 Solution. Please follow the guidelines accordingly. Unfortunately, Converto's Team can not make any adjustments to the Design or correct any misprogramming in the technical implementations. Please mind the Guidelines.


Introduction

Product information are imported regularly from the advertiser source URL into the CONVERTO database.

These product data can be submitted in one or more feeds. Each feed can contain tens of thousands of products.

Please provide your account manager with these data:

  • URL: we collect the feed on this URL

  • Interval: in this time interval we collect the feed (daily, weekly, monthly)

  • Import time: what time should we update the feed for the specified interval

  • Format: CSV

Our product database contains obligatory as well as optional fields. It has to be ensured that at least the obligatory fields are filled in. Otherwise your data cannot be imported. Please find hereafter a description of all fields.

Data Set design for product feeds

To guarantee a correct import the design should be as described below.


Column:

id

Description: unique ID – e.g. article number

Type: string

Max Length: 255 Characters

Mandatory: Yes

Uniqueness: Yes

 

Column:

name

Description: product name

Type: string

Max Length: 65535 characters

Mandatory: Yes

Uniqueness: No

 

Column:

description

Description: product description (short)

Type: string

Max Length: 65535 characters

Mandatory: No

Uniqueness: No

 

Column:

brand

Description: brand

Type: string

Max Length: 255 characters

Mandatory: No

Uniqueness: No

 

Column:

brand_url

Description: link to the brand logo (absolute http://..)

Type: string

Max Length: 255 characters

Mandatory: No

Uniqueness: No

 

Column:

currency

Description: currency – e.g. CHF

Type: string

Max Length: 255 characters

Mandatory: Yes - Default = CHF

Uniqueness: No

 

Column:

price

Description: price, including VAT

Type: decimal point

Max Length: --------.--

Mandatory: yes

Uniqueness: No

 

Column:

old_price

Description: old price, including VAT

Type: decimal point

Max Length: --------.--

Mandatory: No

Uniqueness: No

 

Column:

image_url

Description: link to product picture (absolute http://..)

Type: string

Max Length: 65535 characters

Mandatory: Yes

Uniqueness: No

 

Column:

click_url

Description: deep link to product (absolute http://..)

Type: string

Max Length: 65535 characters

Mandatory: Yes

Uniqueness: No

 

Column:

ean

Description: product ean (different from id)

Type: string

Max Length: 255 characters

Mandatory: No

Uniqueness: No

 

Column:

shop_product_number

Description: shop product number

Type: string

Max Length: 255 characters

Mandatory: No

Uniqueness: No

 

Column:

manufacturer_code

Description: the code of the manufacturer

Type: string

Max Length: 255 characters

Mandatory: No

Uniqueness: No

 

Column:

availability_status

Description: e.g. new, in stock, out of stock, etc.

Type: string

Max Length: 255 characters

Mandatory: No

Uniqueness: No

 

Column:

categories

Description: product category e.g. man shoes

Type: string

Max Length: 255 characters for single category. Max number of categories = 3.

Mandatory: No

Uniqueness: No

 

Column:

display_info

Description: Field for the display type of or other custom informations

Type: string

Max Length: 255 characters

Mandatory: No

Uniqueness: No

General information about the file design of CSV feeds

  • In order to separate columns only the pipe symbol "|" is allowed. Please notice that this symbol cannot be used in the file for reasons other the separating the columns. That symbol is allowed exclusively if the whole column value is between double quotes (“)

  • For the reason above, double quotes (“) can’t be used in any text value (e.g product title or description).

  • Preferably the URL have to be a direct link to the file, but is also allowed an URL that is a script which generates the CSV-file. Example: http://www.your-url.es/ script.php?name=productdata&dummy=.csv

  • The csv must contain the column header as first line

  • Every line must have the same number of columns

  • Every data record must be transferred in one line

  • The decimal separator may only be a comma (,)

  • Numbers (>= 1000) may not contain 1000 separator signs


Special features of individual fields

id

  • The id must be an alphanumeric input which is unique

  • The same id can’t be reused in different version of updated feed for different products, but only for the same one.

name and description

  • These fields must not contain any HTML tags (except <br>).