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>).