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
These attributes are required for all offers:
These attributes are requiered offer-specific or dependent on other attributes:
These attributes are recommended for all offers:
Attributes – Detailed view
The following table shows the required and recommended attributes:
General
| DESIGNATION | DETAILS | NOTE |
|---|---|---|
| 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) 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. Only the product to see, no color or size variants, No borders, frames, logos, |
Prices
| DESIGNATION | DETAILS | NOTE |
|---|---|---|
| REQUIRED Article price EXAMPLE | Price incl. VAT Must be transmitted without currency symbol 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 Must be transmitted without currency symbol | |
| REQUIRED EXAMPLE | The price reduced by the value Must be transmitted without currency symbol | |
| 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 |
Term-dependent costs
| 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 |
Availability and delivery time
| DESIGNATION | DETAILS | NOTE |
|---|---|---|
| REQUIRED Shipping costs of the article to the EXAMPLE 10 characters | Must be transmitted without currency symbol 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 |
Catergory
| 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. |
Promotions and vouchers
| 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 |
Energy efficiency (EU label)
| 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 The min_energy_efficiency_class The energy_efficiency_class For example, if your range runs It’s strongly recommended that
Freezers Special case: |
| eprel_reg_no |
REQUIRED EPREL-ID of your article
EXAMPLES | |
Detailed article description
| 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 |
Dimensions (mm)
| 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 |
Relevant attributes for pharmacies
| DESIGNATION | DETAILS | NOTE |
|---|---|---|
|
REQUIRED pharmaceutical registration number EXAMPLES 8-digit, numeric | |
Relevant attributes for tyres (EU label)
| 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 SUPPORTED VALUES | For tyres produced from | |
|
REQUIRED Snow grip (3PMSF marking) Tire suitable for use in extreme snow conditions SUPPORTED VALUES | | |
|
REQUIRED
Ice grip SUPPORTED VALUES | |
Relevant attributes for car parts
| 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 |
Relevant attributes for contact lenses
| 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 |
