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.
Ideally, a CSV feed should look like this:
Notes on assortment-specific columns:
These contents must be clearly marked in the „condition“ column:
These contents may not be contained in feed:
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
or +49 721 86 95 6 - 60 (selection in the voice menu 1 then 2).
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 | Note or dependency | |
---|---|---|
REQUIRED | ||
REQUIRED | OFFER WITH A GTIN ASSIGNED BY THE MANUFACTURER | |
REQUIRED | ||
REQUIRED | ||
REQUIRED | ||
REQUIRED | ||
REQUIRED | ||
REQUIRED | ||
REQUIRED | ||
REQUIRED | ||
REQUIRED | ||
REQUIRED |
Attributes | Note or dependency | |
---|---|---|
REQUIRED | IF VOUCHER_TEXT IS PASSED | |
REQUIRED | IF THE ARTICLE DOES NOT HAVE A MANUFACTURERASSIGNED GTIN | |
REQUIRED | IF LOCAL LAWS AND REGULATIONS REQUIRE THE BASE PRICE TO BE SPECIFIED | |
REQUIRED | IF LOCAL LAWS AND REGULATIONS REQUIRE THE BASE PRICE TO BE SPECIFIED | |
REQUIRED | IF LOCAL LAWS AND REGULATIONS REQUIRE THE BASE PRICE TO BE SPECIFIED | |
REQUIRED | FOR ARTICLES WITH TERM CONTRACTS | |
REQUIRED | FOR ARTICLES WITH TERM CONTRACTS | |
REQUIRED | FOR ARTICLES WITH TERM CONTRACTS | |
energy_efficiency_class | REQUIRED | FOR ARTICLES REQUIRING LABELLING |
REQUIRED | FOR USED GOODS | |
REQUIRED | FOR VARIANTS | |
REQUIRED | FOR PACKAGING UNITS WITH SEVERAL SAME ARTICLES | |
REQUIRED | FOR SETS | |
REQUIRED | FOR ALL ARTICLES THAT ARE AVAILABLE IN DIFFERENT SIZES | |
REQUIRED | FOR ALL ARTICLES THAT ARE AVAILABLE IN DIFFERENT COLOURS | |
REQUIRED |
REQUIRED FOR VARIANTS: | |
REQUIRED | IF AN ARTICLE CONTAINS ONLY ADULT CONTENT | |
REQUIRED | FOR PHARMACEUTICAL ARTICLES | |
REQUIRED | FOR TYRES | |
REQUIRED | FOR TYRES | |
REQUIRED | FOR TYRES | |
REQUIRED | FOR TYRES | |
REQUIRED | FOR CAR PARTS | |
REQUIRED | FOR CONTACT LENSES | |
REQUIRED | FOR CONTACT LENSES | |
REQUIRED | FOR CONTACT LENSES | |
REQUIRED | FOR CONTACT LENSES | |
REQUIRED | FOR CONTACT LENSES | |
REQUIRED | FOR MULTIFOCALS AND PRESBYOPIC CONTACT LENSES |
Attributes | Note or dependency | |
---|---|---|
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | FOR ARTICLES THAT CAN BE ORDERED IN ADVANCE | |
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | FOR GENDER-SPECIFIC ARTICLES | |
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | FOR TOYS AND BABY FURNITURE CLOTHING | |
RECOMMENDED | FOR GAMES AND GAMING ACCESSORIES | |
RECOMMENDED | ESPECIALLY FOR FASHION AND FURNITURE | |
RECOMMENDED | ESPECIALLY FOR FASHION AND FURNITURE | |
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED | ||
RECOMMENDED |
The following table shows the required and recommended attributes:
DESIGNATION | DETAILS | NOTE |
---|---|---|
RECOMMENDED Date (and time) of the last change EXAMPLES | Specifies the date (and time) of
specify in ISO 8601 format | |
REQUIRED einzigartige Artikelnummer EXAMPLES | A unique value must be used May not be reused Only valid Unicode characters | |
RECOMMENDED Amazon standard Max. 10 characters | A unique value must be used May not be reused | |
REQUIRED
The GTIN/EAN of your article EXAMPLE Max. 14 numeric characters per SUPPORTED VALUES Schema.org isbn |
For compatible articles: Submit For multipacks (several identical For sets (main article bundled Multiple GTINs separated with ; | |
REQUIRED
The MPN of your article (Modelnumber, EXAMPLE Max. 64 alphanumeric characters | Only from manufacturer assigned MPNs MPNs as accurate as possible Identical articles in different | |
REQUIRED article name EXAMPLE Max. 200 characters | The following formula is used In the case of product variants, For variants with distinguishing | |
REQUIRED EXAMPLE Max. 70 characters | Use your store name for the For compatible items, the brand Do not specify original suppliers Further information can be | |
REQUIRED Description of the item EXAMPLE
| Article description, free of advertising
Only give descriptive information | |
REQUIRED Link to the offer in the shop (with EXAMPLES https://beispieltracker.com/xfgrkgmAfGeBLhG https://shop-name.de/product/15153
|
Link with tracking parameters no obligation to register or all information on the landingpage | |
REQUIRED, Link to the offer in the shop (with parameters) EXAMPLE
| must correspond to the shop URL Link with tracking parameters
Parameters for controlling no obligation to register or all information on the Landingpage | |
REQUIRED The URL of the main image RECOMMENDED EXAMPLE [AN IMAGE] EXAMPLE [SEVERAL PICTURES] Max. 500 characters |
JPEG (.jpg/.jpeg), non-animated Several images separated by Image size: at least 500 x 500 Note that more and more users Released Images or Image Do not submit a placeholder or Product can be seen completely Only the product can be seen, No borders, frames, logos, |
DESIGNATION | DETAILS | NOTE |
---|---|---|
REQUIRED Article price EXAMPLE | Price incl. VAT Must match the price on the Must be clearly visible on the Must be visible without Must be denominated in the Price <= 0.00 is not allowed and | |
RECOMMENDED The strike price of your article EXAMPLE | Price originally called up for the Is optically highlighted and displayed with percentage | |
REQUIRED EXAMPLE | The price reduced by the value | |
RECOMMENDED bargain price EXAMPLE Schema.org Price Specification | Price indication of articles in the Sale/Special offer Indication of | |
RECOMMENDED special offer period EXAMPLE | period (according to ISO 8601 Specifies the start and end | |
RECOMMENDED Special offer publication date EXAMPLE | time (according to ISO 8601 Date from which the special e.g. sending a newsletter that | |
REQUIRED RECOMMENDED Price per unit of measure EXAMPLES Max. 32 characters Schema.org Price Specification | The basic price is used to Hint: | |
REQUIRED RECOMMENDED Measure for basic price EXAMPLE SUPPORTED VALUES Schema.org Price Specification | Specifies the content quantity Is specified with a standard find further information here | |
REQUIRED RECOMMENDED
Standard measurement for basic price EXAMPLES SUPPORTED VALUES SUPPORTED NUMBERS Schema.org UnitPriceSpecification | The unit_pricing_base_measure If you submit unit_pricing_ Use the same type of units find further information here |
DESIGNATION | DETAILS | NOTE |
---|---|---|
REQUIRED accounting period EXAMPLE | Duration of a single payroll Further information can be | |
REQUIRED subscription period | Number of payroll periods Further information can be | |
REQUIRED Monthly amount EXAMPLE | Amount the buyer has to pay
Further information can be | |
RECOMMENDED monthly installment and term EXAMPLE 35.00 € monthly fee for a | Details of the installment |
DESIGNATION | DETAILS | NOTE |
---|---|---|
REQUIRED Shipping costs of the article to the EXAMPLE 10 characters | Shipping costs of the respective If you are shipping free of charge Missing shipping costs lead in | |
RECOMMENDED Shipping costs of the item from EXAMPLE | Shipping costs of the respective If you are shipping free from a Missing shipping costs lead in | |
REQUIRED Delivery time of the article EXAMPLE 80 characters | Delivery time of the article from Always specify with unit, | |
RECOMMENDED Availability of the article EXAMPLE SUPPORTED VALUES | Availability of the article The specification must match | |
RECOMMENDED Date from which a pre-ordered EXAMPLE | Use this attribute when This information is decisive for | |
RECOMMENDED Number of items you have in stock EXAMPLE |
Use this attribute when |
DESIGNATION | DETAILS | NOTE |
---|---|---|
REQUIRD Unique category of the article in EXAMPLE | Enter the category path of the No general terms such as Without additives from Categories must be in the | |
RECOMMENDED Unique category of the article at EXAMPLE | Enter the category path of the No general terms such as Without additives from Categories must be in the Find out more here. | |
RECOMMENDED The Google-defined numeric ID of EXAMPLE | Enter the numeric category ID Find out more here. |
DESIGNATION | DETAILS | NOTE |
---|---|---|
RECOMMENDED EXAMPLE Max. 100 characters text, no html | Display of e.g: Voucher actions, | |
RECOMMENDED EXAMPLE max. 100 characters text, no html | Used exclusively for displaying The coupon code must be at No formatting and line breaks For affected offers MUST be The voucher_text should only | |
special |
RECOMMENDED Marked articles for focused push
EXAMPLE
|
Tagging items via this field/column |
DESIGNATION | DETAILS | NOTE |
---|---|---|
special case luminaires: |
REQUIRED
EXAMPLES MIN_ENERGY_EFFICIENCY_CLASS MAX_ENERGY_EFFICIENCY_CLASS Specify the attribute SUPPORTED VALUES | If your products target any The min_energy_efficiency_class The energy_efficiency_class It’s strongly recommended that Refrigerators Freezers Washing machines Tumble dryers Combined washer dryers Wine-storage appliances Dishwashers Ovens Water heaters Air conditioners Televisions special case: |
DESIGNATION | DETAILS | NOTE |
---|---|---|
REQUIRED state
EXAMPLE | If no specification is made, new Further information can be | |
REQUIRED ID for a group of variants that are
EXAMPLE Max. 50 alphanumeric characters | The item_group_id stands Use an item group ID for a color, size, pattern, material, For each individual group of For each item in the group Further information can be | |
RECOMMENDED Compatible Articles
EXAMPLE Example for KMP B9 - Printer
Example for rear lamp left Hella | List of the main articles e.g. compatible printer model | |
REQUIRED The number of identical articles in BEISPIEL Whole number greater than 1 | Submit this attribute when EXAMPLE 2 identical speakers sold together Specify the number of items in If you do not submit the | |
REQUIRED Indicates that the item is a SUPPORTED VALUES | Specify yes if you want to create If you do not submit the Please note the notes under | |
REQUIRED The size of your item EXAMPLE Max. 100 Zeichen | For variants, enter the same Specify a size, not the range | |
RECOMMENDED The country of the sizing system EXAMPLE | If you do not submit this | |
REQUIRED RECOMMENDED The colour of your article EXAMPLE Max. 100 alphanumeric characters | no digits, e.g. 0 2 4 6 8 no alphanumeric characters like no references to the article or not several color names no value for the color mixed, for men, for women or main color first For variants: Specify the same | |
RECOMMENDED Gender for which your article is EXAMPLE SUPPORTED VALUES | For variants: Enter the same | |
REQUIRED The substance or material of your EXAMPLE MATERIAL EXAMPLES VISCOSE Max. 200 characters | To specify multiple materials Specify outer material, filler For textiles consisting of at least For variants, enter the same | |
RECOMMENDED The pattern or the graphic EXAMPLES Max. 100 characters | For variants, specify the same | |
RECOMMENDED age rating EXAMPLES Max. 100 characters | For offers with age rating such If this field is not filled, the age Indication in years | |
RECOMMENDED The demographic target group / EXAMPLE UNTERSTÜTZTE WERTE newborn | One value per article must be For variants: Further information can be | |
REQUIRED Refers to an article with sexually EXAMPLE SUPPORTED VALUES | Choose yes if this particular If you do not select the | |
RECOMMENDED platform EXAMPLE | For games: on which platform For accessories: for which If an article is compatible with | |
RECOMMENDED Fashion: EXAMPLE FASHION With furniture:
| Specifies the items within a | |
RECOMMENDED Style of the article BEISPIELE | Describes the style of an article | |
RECOMMENDED Properties of te acticle EXAMPLES | Describes the properties of an | |
RECOMMENDED Functions of the article EXAMPLES | Describes the functions and | |
RECOMMENDED Equipment of the article EXAMPLES | Describes the features of an |
DESIGNATION | DETAILS | NOTE |
---|---|---|
RECOMMENDED Height of the article EXAMPLE 40 cm | Always enter the dimensions Please specify width, length and | |
RECOMMENDED Width of the article EXAMPLE 2 m | Always enter the dimensions Please specify height, width and | |
RECOMMENDED Length of the article EXAMPLE | Always enter the dimensions Please specify height, width and | |
RECOMMENDED Tiefe des Artikels
| Always enter the dimensions Please specify height, width and |
DESIGNATION | DETAILS | NOTE |
---|---|---|
REQUIRED pharmaceutical registration number EXAMPLES 8-digit, numeric |
DESGINATION | DETAILS | NOTE |
---|---|---|
REQUIRED wet grip EXAMPLE SUPPORTED VALUES | ||
REQUIRED fuel efficiency EXAMPLE SUPPORTED VALUES | ||
REQUIRED rolling noise EXAMPLE | Specify value in decibels | |
REQUIRED rolling noises EXAMPLE | For tyres produced from Values between 1 and 3 permissible |
BEZEICHNUNG | DETAILS | NOTE |
---|---|---|
REQUIRED HSN (manufacturer key number) EXAMPLES 7-digit | comma separated list possible you are also welcome to send compatible models incl. brands |
DESIGNATION | DETAILS | NOTE |
---|---|---|
REQUIRED Dioptres, also sphere EXAMPLES | Value from -30.0 to 30.0 dpt Stepwise 0.25 | |
REQUIRED Diameter in mm EXAMPLES | value from 8.0 to 15.0 mm Stepwise 0.1 | |
REQUIRED Base curve, or radius in mm EXAMPLES | value from 8.3 to 9.0 mm Stepwise 0.1 | |
REQUIRED Cylinder in dpt EXAMPLES | value from -0.25 to -10.0 dpt Stepwise 0.25 | |
REQUIRED Axis in degrees EXAMPLES | Value from 0 to 180 degrees Stepwise 10 | |
REQUIRED close-up addition EXAMPLES | Value from +1.00 to +4.00 ADD Stepwise 0.50 High ADD, Medium ADD, Low |