Guideline feed optimization

The basis for a conversion-strong and successful listing of your offers is a high-quality data delivery. For example, if your landing page doesn‘t match the data in the feed, users are much more likely to leave your site without buying anything.

This document is intended to assist you in selecting the relevant columns for your assortment(s) to provide the best data quality. This enables solute GmbH to optimally present your offers on billiger.de and other distribution channels and to show the users the offers that most closely match the search query.

Submit all of the REQUIRED attributes listed in our feed specification that apply to your items. Don‘t let the sheer number of possible columns unsettle you. There are some columns that are REQUIRED for all assortments, others only for certain assortments. For some assortments, certain information is required by law.

However, it makes sense in any case to provide as detailed information as possible. We also advise you to specify as many RECOMMENDED attributes as possible. To give you an overview and help you select the columns required for your assortment, there is a glossary in table form at the beginning of this document in which all columns are provided with assortment-specific notes on necessity. You can go from any column to the detailed description.

In addition, please make sure that you only submit offers whose data comply with our guidelines. The order of the columns and the column captions do not need to correspond to the proposal below, but the captions must be unique. If you adhere to our guidelines, this facilitates automatic integration and prevents unnecessary interruptions to listing during structural adjustments in your feed.

These basic conditions must be met:

  • The complete offer data must be available in one feed, please combine several files.
  • The feed must be in CSV, JSON or XML format and can be compressed in all common formats.
  • The different information must not be contradictory.

Ideally, a CSV feed should look like this:

  • The feed must always have a header that describes the fields it contains.
  • Each variant of an article must be submitted as a separate offer in the feed.
  • All rows should have the same number of columns (if a field is not to be filled, it remains empty, that is, there are two column separators next to each other).
  • Column separator: , Comma. Example: name,brand,price,desc,...
  • If a separator (see example below: „ ) occurs in one of the fields, it must be escaped with double
  • quotation marks, or the whole field must be enclosed by double quotation marks.
    Example: Column name: „Flatscreen 25“ Screen diagonal“ becomes „Flatscreen 25“ Screen diagonal
  • The last column does not end with a column separator.
  • List separator: ; (semicolon) Example: Properties column: vegan; gluten-free; sugar-free
  • Encoding UTF-8
  • Further information can be foundhere.


Notes on assortment-specific columns:

  • For some assortments, additional information in extra columns is helpful or even required by law. Specifying this information additionally optimizes the assignment and the filter functions.
  • We would like to point out to you the legal necessity to indicate shipping costs, delivery times and base prices (for articles for which the indication of the base price is required by applicable law) and urge you to deposit these in your offer data file.
  • Additional requirements apply to tyres, rims, vehicle wear parts, contact lenses, pharmacy products / pharmaceutical articles and electronical devices. Please note that certain information such as dioptres, energy efficiency classes, EU labels, consumption values, PZN etc. must be shown in separate columns for each article in order to enable optimum integration.


These contents must be clearly marked in the „condition“ column:


These contents may not be contained in feed:

  • illegal content
  • BDSM content


Information on the protection of minors

FSK18 or USK18 goods must be specified explicitly in the age_rating field.


Notes on international listing

All information in the feed must be in the local language or a supported language for the desired sales country. The feed may only contain one language. Please note that using a supported language instead of the local language may result in you limiting your potential customers in that country, as not every customer is multilingual.


Notes on price transmission

All data and prices in the feed must be end customer prices (including the legal VAT, except for small entrepreneurs) and in the currency of the desired country of sale.


Any questions? Your direct contact to solute GmbH

If you have any questions regarding export/import or the assortment-specific columns, we will be happy to support you individually. You can reach our shop data management at cnfgsltd.

Attributes

LEGEND:

REQUIRED
These attributes are indispensable for a listing

RECOMMENDED
These attributes allow an optimal presentation of the articles

EXAMPLE
Optimal data formatting

LINK
References/dependencies within the document or to external sources

Attributes – Overview

Attributes – Detailed view

The following table shows the required and recommended attributes:

General

DESIGNATION

DETAILS

NOTE

aid (auch: sku / ID)

REQUIRED

einzigartige Artikelnummer

EXAMPLES
123456
13AB53Y
254863-XY

Maximal 50 Zeichen

Schema.org SKU

A unique value must be used
for each article and its variants.

May not be reused

Only valid Unicode characters

    asin

    RECOMMENDED

    Amazon standard
    identification number

    Max. 10 characters
    alphanumeric

    A unique value must be used
    for each article and its variants.

    May not be reused


    GTIN (for Europe: EAN)

    REQUIRED
    FOR ALL NEW ARTICLES WITH A
    MANUFACTURER ASSIGNED GTIN

    The GTIN/EAN of your article

    EXAMPLE
    4032314030349

    Max. 14 numeric characters per
    value - additional spaces and
    hyphens are ignored

    SUPPORTED VALUES
    EAN (in Europa/GTIN-13)
    13-digit number like 3001234567892
    ISBN (for books)
    13-digit number like e.g. 978-1455582341. 
    ITF-14 (for Multipacks/GTIN-14)
    14-digit number like 10856435001702
    UPC (in North America/GTIN-12) 
    12-sdigit number like 323456789012

    Schema.org isbn
    Schema.org gtin8
    Schema.org gtin12
    Schema.org gtin13
    Schema.org gtin14 

    For compatible articles: Submit
    the GTIN of the manufacturer
    that has produced the
    compatible article

    For multipacks (several identical
    articles in one packaging unit):
    Use the GTIN that refers to the Multipack

    For sets (main article bundled
    with other articles):
    Please do not use the GTIN of
    the main item in the set

    Multiple GTINs separated with ;


    mpn (auch: mpnr)

    REQUIRED
    IF THE ARTICLE DOES NOT HAVE A GTIN
    ASSIGNED BY THE MANUFACTURER

    The MPN of your article (Modelnumber,
    manufacturer article number)

    EXAMPLE
    12mx200hl

    Max. 64 alphanumeric characters

    schema.org mpn

    Only from manufacturer

    assigned MPNs

    MPNs as accurate as possible

    Identical articles in different
    colors, for example, should be
    marked with different MPNs.

    name (auch: title)

    REQUIRED

    article name

    EXAMPLE
    Apple iPhone 8 64GB Space Grau

    Max. 200 characters

    Schema.org Name

    The following formula is used
    for orientation: (<series>)
    <modelname> < Model
    number> < Product type>
    (<Quantity>) < Properties>

    In the case of product variants,
    at least the minimum quantity
    of properties such as colour
    and size should be specified in
    order to be able to distinguish
    between the various variants.

    For variants with distinguishing
    features such as color or size

    brand

    REQUIRED
    FOR EACH ARTICLE WITH A CLEARLY
    ASSIGNED BRAND OR MANUFACTURER OF
    THE ARTICLES BRAND.

    The brand name of your article

    EXAMPLE
    solute

    Max. 70 characters

    Schema.org Brand

    Use your store name for the
    brand attribute if you make the
    item yourself or if your item is
    a white label item. For example,
    you can use your store name
    as a brand when you sell
    personalized jewelry or items
    made by someone else that you
    give a new brand name.

    For compatible items, the brand
    of the manufacturer who made
    the compatible item must be
    transferred.

    Do not specify original suppliers
    brand to indicate product
    compatibility.

    Further information can be
    found here

    desc

    REQUIRED

    Description of the item

    EXAMPLE
    The digital compact camera with a
    maximum resolution of 20 million pixels
    and a 10x optical zoom supports the
    following storage media: SDHC


    Max. 4.000 characters                        

    Schema.org Description

    Article description, free of advertising
    texts

    Only give descriptive information
    about the article (no html
    code, links)

    link

    REQUIRED
    TO TAKE THE USER DIRECTLY TO THE OFFER

    Link to the offer in the shop (with
    parameters)

    EXAMPLES
    https://shop-name.de/product/15153 ?utm_
    source=billiger.de&utm_medium=cpc&utm_
    campaign=Preisvergleich&ref=132

    https://beispieltracker.com/xfgrkgmAfGeBLhG

    https://shop-name.de/product/15153


    Max. 750 characters

    Schema.org URL

    Link with tracking parameters
    for traffic analysis

    no obligation to register or
    search page to see price and
    details on the landing page of
    the offer

    all information on the landingpage
    must match the
    information in the feed

    target_url

    REQUIRED,
    TO TAKE THE USER DIRECTLY TO THE OFFER

    Link to the offer in the shop (with parameters)

    EXAMPLE
    https://shop-name.de/product/15153


    Max. 750 Zeichen

    must correspond to the shop URL

    Link with tracking parameters

    Parameters for controlling
    specific prices can be transferred as well.

    no obligation to register or
    search page to see price and
    details on the landing page of
    the offer

    all information on the Landingpage
    must match the information in
    the feed

    images

    REQUIRED 

    The URL of the main image

    RECOMMENDED 
    The URLs of other images with
    separate-character separated

    EXAMPLE [AN IMAGE]
    http://www.example.com/image1.jpg

    EXAMPLE [SEVERAL PICTURES]
    http://www.example.com/image1.jpg; http://
    www.example.com/image2.jpg; http://www.
    example.com/image3.jpg

    Max. 500 characters

    Schema.org Image 

    JPEG (.jpg/.jpeg) or WebP (.webp) non-animated GIF (.gif), PNG (.png)

    The URLs should not contain a timestamp

    Multiple images separated wit separator, first image is main image.
    Alternatively several columns with ideally the following designations: images_front, image_back, image_side,
    image_oblique, image_top,
    image_detail, image_milieu

    Image size: min. 500 x 500 pixels (max. 2048 x 2048 pixels) for good individual display of the images for offers

    Please note that more and more more users are using devices with high-resolution displays devices. Therefore the transmission of images with 1,000 x 1,000 pixels for the zoom zoom function is desirable.

    Cropped images or
    Image background pure white (Hex#FFFFFF or RGB 255-255-255)

    Do not submit a placeholder and no generic image

    Product is on the main image completely and in the frontal view

    Only the product to see, no color or size variants,
    no parts that are not included in the scope of delivery
    (Example tires with rims,
    umbrella stand with base plates base plates, etc.)

    No borders, frames, logos,
    watermarks or other graphics
    graphics

    Prices

    DESIGNATION

    DETAILS

    NOTE

    price

    REQUIRED

    Article price

    EXAMPLE
    15.00

    Schema.org Price Specification 

    Price incl. VAT

    Must be transmitted without currency symbol

    Must match the price on the
    landing page

    Must be clearly visible on the
    target page of your shop

    Must be visible without
    registration

    Must be denominated in the
    currency of the country of
    distribution

    Price <= 0.00 is not allowed and
    leads to rejection of the article.

    old_price

    RECOMMENDED

    The strike price of your article

    EXAMPLE
    19.99

    Schema.org Price Specification 

    Price originally called up for the
    article in the shop.

    Is optically highlighted

    and displayed with percentage
    savings

    Must be transmitted without currency symbol

    voucher_price

    REQUIRED
    IF VOUCHER_TEXT IS PASSED

    EXAMPLE
    5.99

    Schema.org Price Specification 

    The price reduced by the value
    of the voucher.

    Must be transmitted without currency symbol

    ppu (auch: base_price)

    REQUIRED
    IF THE BASIC PRICE IS SPECIFIED AFTER
    LOCAL LAWS AND REGULATIONS
    IS NECESSARY, OTHERWISE

    RECOMMENDED

    Price per unit of measure

    EXAMPLES
    perfume:
    59.90€ / 100 ml
    pet food:
    0.80€ / 100 g

    Max. 32 characters

    Schema.org Price Specification 

    The basic price is used to
    display comparable values for
    different package sizes on the
    basis of a unit measure.

    Hint:
    For Google PLA only the
    columns unit_pricing_measure
    and unit_pricing_base_measure
    are supported.

    unit_pricing_measure

    REQUIRED
    IF THE BASE PRICE SPECIFICATION
    ACCORDING TO LOCAL LAWS AND
    REGULATIONS IS NECESSARY, OTHERWISE

    RECOMMENDED

    Measure for basic price
    In the format: [number] [unit].

    EXAMPLE
    500 ml

    SUPPORTED VALUES
    Weight: oz, lb, mg, g, kg
    Volume (US imperial): floz, pt, qt, gal
    Volume (metric): ml, cl, l, cbm
    Length: in, ft, yd, cm, m
    Area: sqft, sqm
    Per unit: ct

    Schema.org Price Specification 

    Specifies the content quantity
    or dimensions of the article.

    Is specified with a standard
    dimension for comparison
    purposes.

    find further information here

    unit_pricing_base_measure

    REQUIRED
    IF THE BASE PRICE SPECIFICATION ACCORDING
    TO LOCAL LAWS AND REGULATIONS IS
    NECESSARY, OTHERWISE

    RECOMMENDED

    Standard measurement for basic price
    In format: [number] [unit]

    EXAMPLES
    100 ml, 100 g

    SUPPORTED VALUES
    Weight: oz, lb, mg, g, kg
    Volume (US imperial): floz, pt, qt, gal
    Volume (metric): ml, cl, l, cbm
    Length: in, ft, yd, cm, m
    Area: sqft, sqm
    Per unit: ct

    SUPPORTED NUMBERS
    1, 10, 100, 2, 4, 8
    ADDITIONAL SUPPORTED VALUES
    75 cl, 750 ml, 50 kg, 1.000 kg

    Schema.org UnitPriceSpecification 

    The unit_pricing_base_measure
    attribute lets you include the
    denominator for your unit
    price. For example, you might
    be selling 150ml of perfume,
    but users are interested in
    seeing the price per 100ml.

    If you submit unit_pricing_
    measure     attrubute, then use
     unit_pricing_base_measure
    to specify the unit of
    measurement on which the
    price per packaging unit is
    based. To make the unit prices
    more comparable for all ads
    on a page, your ad might show
    a different base measure than
    what you provide here.

    Use the same type of units
    as you used for unit_pricing_
    measure    . For example, if you
    use sqm for unit_pricing_
    measure    , then use sqm for
    unit_pricing_base_measure.

    find further information here

    Term-dependent costs

    DESIGNATION

    DETAILS

    NOTE

    subscription_cost_period

    REQUIRED
    FOR ARTICLES WITH TERM CONTRACTS

    accounting period

    EXAMPLE
    month

    Duration of a single payroll
    period (either month or year).

    Further information can be
    found here.

    subscription_cost_period_length

    REQUIRED
    FOR ARTICLES WITH TERM CONTRACTS

    subscription period

    BEISPIELE      
    12

    Number of payroll periods
    (months or years)

    Further information can be
    found here.

    subscription_cost_amount_value

    REQUIRED
    FOR ARTICLES WITH TERM CONTRACTS

    Monthly amount

    EXAMPLE
    25

    Amount the buyer has to pay
    monthly

    Further information can be
    found here.

    installment

    RECOMMENDED

    monthly installment and term

    EXAMPLE 
    12:35,00

    35.00 € monthly fee for a
    Term of 12 months

    Details of the installment
    amount and term can be
    specified for articles for
    installment payment

    Availability and delivery time

    DESIGNATION

    DETAILS

    NOTE

    dlv_cost

    REQUIRED

    Shipping costs of the article to the
    destination country

    EXAMPLE
    5.99
    free of shipping costs:
    0.00

    10 characters

    Must be transmitted without currency symbol

    Shipping costs of the respective
    article when shipping within the
    destination country

    If you are shipping free of charge
    from a certain value of goods and
    the offer exceeds this limit, please
    enter the value 0.00.

    Missing shipping costs lead in
    most cases to purchase aborts

    dlv_cost_AT

    RECOMMENDED

    Shipping costs of the item from
    stock to Austria

    EXAMPLE
    7.99
    free of shipping costs
    0.00

    Shipping costs of the respective
    article when shipping to Austria

    If you are shipping free from a
    certain value of goods and the
    offer exceeds this limit, please
    enter the value 0.00.

    Missing shipping costs lead in
    most cases to purchase aborts

    dlv_time

    REQUIRED

    Delivery time of the article

    EXAMPLE
    2 working days
    1-3 days

    80 characters

    Delivery time of the article from
    the time of order acceptance or
    complete payment.

    Always specify with unit,
    otherwise days are assumed.

    availability

    RECOMMENDED

    Availability of the article

    EXAMPLE
    in stock

    SUPPORTED VALUES
    in stock
    out of stock
    preorder
    backorder

    Schema.org Availability

    Availability of the article

    The specification must match
    the availability on the target
    page.

    availability_date

    RECOMMENDED
    FOR ARTICLES THAT CAN BE ORDERED IN
    ADVANCE

    Date from which a pre-ordered
    Article available

    EXAMPLE
    2019-02-24 [JJJJ-MM-TT]

    Schema.org AvailabilityStarts

    Schema.org AvailabilityEnds

    Use this attribute when
    submitting the value preorder
    for availability

    This information is decisive for
    the purchase

    Catergory

    DESIGNATION

    DETAILS

    NOTE

    shop_cat

    REQUIRD

    Unique category of the article in
    the shop in the language of the
    country of sale.

    EXAMPLE
    Kitchen, Household & Living
    > coffee, tea & espresso
    > Espresso maker

    Enter the category path of the
    offer from your shop

    No general terms such as
    „Sale Offer“, „Top Deal“

    Without additives from
    manufacturer and model data

    Categories must be in the
    language of the country of sale,
    alternatively in a supported
    language.

    google_product_category

    RECOMMENDED

    Unique category of the article at
    Google in the language of the sales
    country

    EXAMPLE
    Clothing & Accessories > Clothing >
    Outerwear > Coats & Jackets

    Enter the category path of the
    offer at Google

    No general terms such as
    „Sale Offer“, „Top Deal“

    Without additives from
    manufacturer and model data

    Categories must be in the
    language of the country of sale,
    alternatively in a supported
    language.

    Find out more here.

    google_product_category_ID

    RECOMMENDED

    The Google-defined numeric ID of
    the product category for your item.

    EXAMPLE
    499676

    Enter the numeric category ID
    of the offer at Google

    Find out more here.

    Promotions and vouchers

    DESIGNATION

    DETAILS

    NOTE

    promo_text

    RECOMMENDED

    EXAMPLE
    - Pick-up in a retail shop possible (01234
    Beispielhausen)
    - 5 € voucher for newsletter registration
    - 10% discount for new customers

    Max. 100 characters text, no html
    code

    Display of e.g: Voucher actions,
    new customer discount, special
    delivery conditions (e.g. delivery
    up to site, two-man service),
    special payment methods
    (financing, etc.)

    voucher_text

    RECOMMENDED

    EXAMPLE
    7 SAVINGS (7% discount from 1 EUR - 10.000
    EUR Cost value, not redeemed for books)

    max. 100 characters text, no html
    code

    Used exclusively for displaying
    coupon codes

    The coupon code must be at
    the beginning, followed by a
    space and the coupon text in
    brackets.

    No formatting and line breaks

    For affected offers MUST be
    passed in the column price
    or an additional column
    (e.g voucher_price the price
    reduced by the value of the
    voucher).

    The voucher_text should only
    be transmitted during the
    promotion period. Before and
    after this, the column should
    remain empty, not deleted.

    special

    RECOMMENDED

    Marked articles for focused push

    EXAMPLE
    Top seller
    Season
    High margin
    Deal
    Action
    Push
    Top
    Sale



    Tagging items via this field/column
    allows solute to promote and push
    selected items in a targeted manner.

    Only one value per article.

    The values must be speaking.
    Values like "x" or "1" are not supported.

    Energy efficiency (EU label)

    DESIGNATION

    DETAILS

    NOTE                                                                              

    energy_efficiency_class 


    min_energy_efficiency_class 


    max_energy_efficiency_class

    special case luminaires:
    energy_efficiency_class_illuminant

    REQUIRED
    FOR SUBJECT TO MANDATORY LABELLING
    ARTICLES
    IN COMPLIANCE WITH LOCAL LAWS OR
    REGULATIONS

    The energy efficiency class of your
    article

    EXAMPLES
    ENERGY_EFFICIENCY_CLASS
    A+

    MIN_ENERGY_EFFICIENCY_CLASS
    A+

    MAX_ENERGY_EFFICIENCY_CLASS
    D

    Specify the attribute

    SUPPORTED VALUES
    A+++
    A++
    A+
    A
    B
    C
    D
    E
    F
    G

    If your products target
    any of the EU member states or Switzerland, consider the legal requirements on this
    matter defined in the national implementation acts of the EU directive 2017/1369 and any
    other applicable local law.

    The min_energy_efficiency_class
    value must be smaller than the
    max_energy_efficiency_class
    value. For example, your scale must run from A to D rather than D to A.

    The energy_efficiency_class
    value you provide must be
    within the range of the
    min_energy_efficiency_class value and the
    max_energy_efficiency_class value.

    For example, if your range runs
    from A to D, your energy_efficiency_class
    value may not be G.

    It’s strongly recommended that
    you submit energy_efficiency_
    class    , min_energy_efficiency_
    class    , and max_energy_
    efficiency_class     for applicable
    products. You might need
    provide this class for these
    types of products:

    • Refrigerators

    Freezers
    Washing machines
    Tumble dryers
    Combined washer dryers
    Wine-storage appliances
    Dishwashers
    Ovens
    Water heaters
    Air conditioners
    Televisions

    Special case:
    For lamps with built-in illuminant, please enter the energy efficiency
    class of the illuminant in the
    additional column „energy_efficiency_
    class_illuminant    “                           

    eprel_reg_no

    REQUIRED
    for articles with energy consumption labeling

    EPREL-ID of your article

    EXAMPLES
    2103368

    EPREL Public website


    Detailed article description

    DESIGNATION

    DETAILS

    NOTE

    condition

    REQUIRED
    FOR USED GOODS

    state

    EXAMPLE
    new
    refurbished
    used

    If no specification is made, new
    is assumed by default.

    Further information can be
    found here

    item_group_id

    REQUIRED
    WITH VARIANTS

    ID for a group of variants that are
    available in different versions.

    EXAMPLE
    AB12345

    Max. 50 alphanumeric characters

    The item_group_id stands
    for a unique ID for a group
    of variants that are available
    in different versions
    (distinguishing features)

    Use an item group ID for a
    group of variants that has
    at least one of the following
    attributes:

    color, size, pattern, material,
    age group, gender

    For each individual group of
    variants, use a unique value,
    preferably the parent item
    number.

    For each item in the group
    of variants, enterthe same
    attributes. For example, if an
    item is available in different
    sizes and colors, submit the
    size and color attributes to
    the item_group_id attribute
    for each item with an identical
    value.

    Further information can be
    found here

    compatible_products

    RECOMMENDED

    Compatible Articles

    EXAMPLE
    DCP 130;330;540;750;FAX 1360;1460; MFC 240;
    3360;440;5460;5860;660

    Example for KMP B9 - Printer
    cartridge - 1 x black


    VW MULTIVAN T5 7HM;7HN;
    7HF;7EF;7EM;7EN

    Example for rear lamp left Hella
    2SK 008 579-091 VW MULTIVAN T5

    List of the main articles
    compatible article

    e.g. compatible printer model
    for ink and toner

    quantity_number

    REQUIRED
    FOR PACKAGING UNITS WITH SEVERAL
    SAME ARTICLES

    The number of identical articles in
    one multipack

    BEISPIEL
    6

    Whole number greater than 1
    (multipacks must contain more than
    one item)

    Submit this attribute when
    a group of identical items is
    assembled and sold as a unit

    EXAMPLE
    3 ink cartridges sold together in one
    packaging unit

    2 identical speakers sold together

    Specify the number of items in
    the packaging unit.

    If you do not submit the
    attribute, we assume that only
    one article is contained in the
    packaging unit.

    is_bundle

    REQUIRED
    FOR SETS

    Indicates that the item is a
    composite group with different
    items, including a main item.

    SUPPORTED VALUES
    yes
    no

    Specify yes if you want to create
    a set with different articles and
    a main article have put together.
    Example: Game console with
    one game

    If you do not submit the
    attribute, the Default value no
    used

    Please note the notes under
    GTIN

    size

    REQUIRED
    FOR ALL ARTICLES THAT ARE LISTED IN
    AVAILABLE IN DIFFERENT SIZES ARE

    The size of your item

    EXAMPLE
    XL
    L
    33
    34
    40

    Max. 100 Zeichen

    For variants, enter the same
    value for the item_group_id
    attribute and different Values
    for size

    Specify a size, not the range
    of sizes in the the article is
    available

    size_system

    RECOMMENDED

    The country of the sizing system
    used for the article.

    EXAMPLE
    DE

    SUPPORTED VALUES
    US
    UK
    EU
    DE
    FR
    IT
    INT.

    If you do not submit this
    attribute, the default value is
    the size system of the country
    of distribution.

    color

    REQUIRED
    FOR ALL ARTICLES, WHICH ARE
    AVAILABLE IN DIFFERENT COLOURS

    RECOMMENDED
    FOR ALL OTHERS

    The colour of your article

    EXAMPLE
    schwarz

    Max. 100 alphanumeric characters
    (max. 40 characters per color)

    Schema.org Color

    no digits, e.g. 0 2 4 6 8

    no alphanumeric characters like
    #fff000

    no references to the article or
    the picture, e.g. „see picture“.

    not several color names
    to a word together, e.g.
    RotPinkBlau. instead with a ;
    (e.g. red;pink;blue)

    no value for the color
    specification that is not a color,
    e.g. not multi-colored, different,

    mixed, for men, for women or
    no specification

    If article has multiple colors
    main color first

    For variants: Specify the same
    value for the item_group_id
    attribute and different values for color

    gender

    RECOMMENDED
    FOR GENDER SPECIFIC ARTICLES

    Gender for which your article is
    intended

    EXAMPLE
    unisex

    SUPPORTED VALUES
    male
    female
    unisex     

    Schema.org Suggested gender

    For variants: Enter the same
    value for the item_group_id
    attribute and different values
    for gender.

    material

    REQUIRED
    MATERIAL REQUIRED FOR VARIANTS
    MATERIAL COMPOSITION
    REQUIRED FOR ARTICLES WHICH ARE UP TO
    80% MADE OF TEXTILE FIBRES

    RECOMMENDED
    FOR ALL OTHER ARTICLES

    The substance or material of your
    article

    EXAMPLE MATERIAL
    leather

    EXAMPLES VISCOSE
    98% cotton
    2% spandex

    Max. 200 characters

    To specify multiple materials
    for a single article and not
    for variants, add a primary
    material followed by up to
    two secondary materials
    separated by a semicolon.
    For example, do not write
    CottonPolyesterElasthan, but
    cotton;polyester;elasthan

    Specify outer material, filler
    material, etc. in separate
    columns.

    For textiles consisting of at least
    80% textile fibres, state the
    exact material composition.

    For variants, enter the same
    value for the attribute
    item_group_id and different values
    for material

    pattern

    RECOMMENDED

    The pattern or the graphic
    print design of your article

    EXAMPLES
    spotted
    plaid
    hearts
    stars

    Max. 100 characters

    For variants, specify the same
    value for item_group_id and
    different values for pattern

    age_rating

    RECOMMENDED 

    age rating

    EXAMPLES
    USK:18
    FSK:16

    Max. 100 characters

    For offers with age rating such
    as games or movies.

    If this field is not filled, the age
    rating must be specified in the
    offer description name

    Indication in years

    age_group

    RECOMMENDED
    FOR TOYS AND BABY FURNITURE, CLOTHES

    The demographic target group /
    age group for which your article is
    intended

    EXAMPLE
    infant

    UNTERSTÜTZTE WERTE

    newborn
    Up to 3 months

    infant
    Between 3 and 12 months

    toddler
    Between 1 and 5 years

    kids
    Between 5 and 13 years of age

    adult
    Usually aged 13 and over

    One value per article must be
    stated

    For variants:
    Specify the same value for the
    item_group_id attribute and
    different values for age_group

    Further information can be
    found here

    adult

    REQUIRED
    IF AN ARTICLE HAS CONTENT ONLY FOR
    ADULTS

    Refers to an article with sexually
    suggestive content

    EXAMPLE
    yes

    SUPPORTED VALUES
    yes
    no

    Choose yes if this particular
    article has nudity or sexually
    suggestive content

    If you do not select the
    attribute, the default value no
    is used.

    platform

    RECOMMENDED
    FOR GAMES AND GAMING ACCESSORIES

    platform

    EXAMPLE
    Berserk and the Band of the Hawk (PlayStation PS4) -> PS4

    For games: on which platform
    the game can be used.

    For accessories: for which
    platform the accessory is
    compatible

    If an article is compatible with
    multiple platforms is, values
    comma-separated perform

    product_type

    RECOMMENDED
    ESPECIALLY FOR FASHION AND FURNITURE

    Fashion:
    Dress type, Shoe type, Pocket type,
    Sunglasses type, Watch type

    EXAMPLE FASHION
    evening dress
    leather skirt
    man‘s shirt
    muscle shirt
    ballerina
    pumps
    sandals
    pilot glasses
    travel bag
    analogue clock

    With furniture:
    types of furniture, type of bed, type
    of upholstered furniture, type of
    wardrobe, type of table


    EXAMPLE FURNITURE
    metal bed
    corner couch
    coffee table
    standing shelf
    corner kitchen
    high pile carpet

    Specifies the items within a
    category or item group.

    style

    RECOMMENDED
    ESPECIALLY FOR FASHION AND FURNITURE

    Style of the article

    BEISPIELE
    antik
    minimalistic

    Describes the style of an article

    properties

    RECOMMENDED

    Properties of te acticle

    EXAMPLES
    insulated
    waterproof
    gluten-free

    Describes the properties of an
    article.

    functions

    RECOMMENDED

    Functions of the article

    EXAMPLES
    Automatic switch-off
    Date display
    Face recognition

    Describes the functions and
    functionalities of an article.

    equipment

    RECOMMENDED

    Equipment of the article

    EXAMPLES
    rotating foot
    headrest
    sweat-resistant membrane keyboard

    Describes the features of an
    article to be highlighted.

    Dimensions (mm)

    DESIGNATION

    DETAILS

    NOTE

    height

    RECOMMENDED

    Height of the article

    EXAMPLE

    40 cm

    Always enter the dimensions
    with the unit of measurement.

    Please specify width, length and
    depth in separate columns

    width

    RECOMMENDED

    Width of the article

    EXAMPLE

    2 m

    Always enter the dimensions
    with the unit of measurement.

    Please specify height, width and
    depth in separate columns

    length

    RECOMMENDED

    Length of the article

    EXAMPLE
    80 cm

    Always enter the dimensions
    with the unit of measurement.

    Please specify height, width and
    depth in separate columns

    Relevant attributes for pharmacies

    DESIGNATION

    DETAILS

    NOTE

    PZN

    REQUIRED
    FOR PHARMACEUTICAL ARTICLES

    pharmaceutical registration number

    EXAMPLES
    13751848

    8-digit, numeric


    Relevant attributes for tyres (EU label)

    DESGINATION

    DETAILS

    NOTE

    wet_grip

    REQUIRED
    FOR TYRES

    wet grip

    EXAMPLE
    B

    SUPPORTED VALUES
    Text from A to E


    fuel_efficiency

    REQUIRED
    FOR TYRES

    fuel efficiency

    EXAMPLE
    A

    SUPPORTED VALUES
    A to E


    external_rolling_noise

    REQUIRED
    FOR TYRES

    rolling noise

    EXAMPLE
    72dB

    Specify value in decibels

    rolling_noise_class

    REQUIRED
    FOR TYRES

    rolling noises

    EXAMPLE
    A

    SUPPORTED VALUES
    A, B, C

    For tyres produced from
    01.06.2012 the tyre labels are
    required

    snow_grip

    REQUIRED
    FOR TYRES

    Snow grip

    (3PMSF marking)

    Tire suitable for use in extreme snow conditions

    SUPPORTED VALUES
    yes
    no


    ice_grip

    REQUIRED
    FOR TYRES

    Ice grip

    Tire suitable for use in extreme ice conditions

    SUPPORTED VALUES
    yes
    no


    Relevant attributes for car parts

    BEZEICHNUNG

    DETAILS

    NOTE

    hsn_tsn

    REQUIRED
    FOR AUTO PARTS

    HSN (manufacturer key number)
    and TSN (type key number)

    EXAMPLES
    7104431
    7104501

    7-digit

    comma separated list possible

    you are also welcome to send
    us a separate column with the

    compatible models incl. brands
    e.g. VW Passat Variant (3G5) 1.4
    TSI 4Motion

    Relevant attributes for contact lenses

    DESIGNATION

    DETAILS

    NOTE

    sph_pwr

    REQUIRED
    FOR CONTACT LENSES

    Dioptres, also sphere

    EXAMPLES
    -2.75
    -1.5
    +2,25

    Value from -30.0 to 30.0 dpt

    Stepwise 0.25

    dia

    REQUIRED
    FOR CONTACT LENSES

    Diameter in mm

    EXAMPLES
    13.0
    14.4
    15.0

    value from 8.0 to 15.0 mm

    Stepwise 0.1

    bc

    REQUIRED
    FOR CONTACT LENSES

    Base curve, or radius in mm

    EXAMPLES
    8.3
    8.9

    value from 8.3 to 9.0 mm

    Stepwise 0.1

    cyl

    REQUIRED
    FOR CONTACT LENSES

    Cylinder in dpt

    EXAMPLES
    -0.25
    -2.75

    value from -0.25 to -10.0 dpt

    Stepwise 0.25

    axis

    REQUIRED
    FOR CONTACT LENSES

    Axis in degrees

    EXAMPLES
    20
    130

    Value from 0 to 180 degrees

    Stepwise 10

    add

    REQUIRED
    FOR MULTIFOCALS AND PRESBYOPIC
    CONTACT LENSES

    close-up addition

    EXAMPLES
    +1.00
    +2.50

    Value from +1.00 to +4.00 ADD

    Stepwise 0.50

    High ADD, Medium ADD, Low
    ADD