Follow

e-label - Bulk Upload - Product Information - Data Bulk Upload - Enterprise

With Bulk Upload you can create or update the e-label data of many products at once, using one Excel file.

Available on the Enterprise Full and Enterprise Bulk Upload plans.

Current template version: 1.2.4 (updated 23 September 2026). Always download a new template before you start. An older file may not upload correctly.

In this article

Getting the template

1. Go to QR Manager and click on UPLOAD E-LABEL DATA:

QR Manager with the UPLOAD E-LABEL DATA button

2. On the first screen of the upload ("Get ready"), select a category:

  • Wine, Aromatised Wine, Spirit or Other (food & beverage): an empty template for that category. One upload file can only contain products of one category. Then choose the language you are using in the Excel file, and the languages to publish after the upload. The dropdown values of the template are translated automatically.
  • Copy from an existing product: pick a product from the list.

3. Click DOWNLOAD EXCEL TEMPLATE:

Get ready screen with the category options

How the template works

The Excel file has 12 tabs. Start with the TutorialHelp tab, which gives examples and comments for every column. You can edit the file in Excel or Google Sheets.

The 12 tabs of the template

The template type. Cell B3 of the TutorialHelp tab shows the template type: Wine, Aromatised wine, Spirit or Other (food & beverage). Fields that do not apply to your type are grayed out in the other tabs.

What happens to your data on upload:

  • Blank cell: skipped. The existing value is kept.
  • Filled cell: the new value replaces the old one.
  • #REMOVE: clears the field.

General rules:

  • The first column of every tab is the sku. It must match the SKU of a product that already exists in the portal.
  • You do not need to fill in every field.
  • For bold text, put the words in curly braces, like {this}.
  • For a line break inside a cell, press Alt+Enter (Windows) or Cmd+Enter (Mac).
  • Use the Translatable Fields tab only for custom text. Standard Scantrust content is translated for you.

Removing data

Because a blank cell keeps the existing value, use #REMOVE to clear a field. You can remove existing data in two ways.

1. Clear one field. In columns with a light blue header, type or select #REMOVE in the cell. That field is cleared.

2. Tabs with several rows per product. These tabs are Ingredients, Italian Recycling, Spanish Recycling and Packaging Information. They have a column called remove_all_existing_data.

  • To delete all existing data of a product on that tab, fill one row with only the SKU and select the remove option in remove_all_existing_data.
  • To delete only some of the data, upload just the rows you want to keep. Any row you leave out is deleted.

Important: on these tabs, the rows you upload become the complete list for that product. If a product has 10 ingredients and you upload 2 rows, the product will have 2 ingredients.

Product Information

Fill in one row per product.

Product Information tab with an example row

Column What to enter
sku The product SKU
sku
product_type Pick from the dropdown or type your own text. For "Other" templates you must type your own text.
product_type
net_quantity Wine, aromatised wine and spirit: a number in ml, for example 750. For several sizes, separate them with commas: 300,500,600. "Other": the amount, with the unit in the next column.
net_quantity_unit "Other" templates only: ml, cl, L, g or kg
alcohol_volume Alcohol in %, for example 40
alcohol_volume
portion_size The serving size. It appears in the Consumption Unit section for alcoholic drinks, and in the Nutrition section for "Other" templates.
portion_unit "Other" templates only: g or ml
sugar_content Wine and aromatised wine: pick from the dropdown or type your own text
sugar_content
origin Country of origin: a 2-letter code (for example AR) or pick from the dropdown
origin
producing_year Spirit only: the age of the spirit in years
producing_year
vintage_year Wine only: the year, for example 2015
vintage_year
grape_variety Wine only: free text
grape_variety
bottled_in_protected_atmosphere_msg Wine and aromatised wine: pick from the dropdown (see the next section)
wine_colour Wine only: pick from the dropdown
wine_colour
production_method Wine only: pick from the dropdown
production_method
complement_category_1 and complement_category_2 Aromatised wine only: pick from the dropdown, for example De-alcoholised or Sparkling
geographical_indication_description Free text

Sugar content must match the product type. For example, "Sparkling wine" is Product Type A, so you can choose "Brut nature (Product type A)" but not "Sweet (Product type C)". The product type groups are listed on the TutorialHelp tab.

Bottled in a protective atmosphere

This message is set in the Product Information tab, column bottled_in_protected_atmosphere_msg. It applies to wine and aromatised wine only.

  1. In the Product Information tab, go to the column bottled_in_protected_atmosphere_msg.
  2. Pick one of the four messages from the dropdown:
    • Bottled in a protective atmosphere
    • Bottling may happen in a protective atmosphere
    • Packaging may happen in a protective atmosphere
    • Packaged in a protective atmosphere
  3. To remove the message from a product, type or select #REMOVE in the cell. A blank cell keeps the existing message.

Ingredients

This tab has several rows per product. The rows you upload become the complete ingredient list. It is not available for "Other" templates.

Ingredients tab with an example

  1. sku: the product SKU.
    sku
  2. remove_all_existing_data: see "Removing data".
  3. aromatised_base_wine_name: aromatised wine only. Pick the base grapevine product from the dropdown, or "Not an aromatised wine".
  4. ingredient: pick from the dropdown. Ingredients are grouped by category, for example Main ingredients, Preservatives and antioxidants, or Acidity regulators.
    ingredient
  5. is_allergen: TRUE or FALSE. If TRUE, the ingredient appears in bold in the INGREDIENTS section.
    is_allergen
  6. is_organic: TRUE or FALSE. If TRUE, the ingredient is marked with an asterisk.
    is_organic

To add an ingredient that is not on the list, use the Translatable Fields tab.

Nutrition

One row per product.

Nutrition tab with an example

For all values:

  • Everything is measured per 100 ml.
  • Enter only the number, not the unit. Energy is in kJ and kcal. Everything else is in grams, except vitamins and minerals, which use the unit shown in the column name.
  • Use . as the decimal separator, for example 3.5.
  • To show "less than", type <, for example <1.

All templates: hide_section (TRUE hides the Nutrition section), show_zero_values_as_negligible (how a value of 0 is displayed), energy_kj, energy_kcal, fat_g, saturates_g, carbohydrate_g, sugar_g, protein_g, salt_g.

"Other" templates only: display_mode (table or image), display_reference_intake, mono_unsaturates_g, polyunsaturates_g, polyols_g, starch_g, fibre_g, and the vitamins and minerals (biotin, calcium, chloride, chromium, copper, fluoride, folic acid, iodine, iron, magnesium, manganese, molybdenum, niacin, pantothenic acid, phosphorus, potassium, riboflavin, selenium, thiamin, vitamins A, B6, B12, C, D, E and K, and zinc).

The sku column:

sku

The show_zero_values_as_negligible column:

show_zero_values_as_negligible

Pictograms

One row per pictogram.

sku

  1. icon_id: pick a pictogram from the dropdown, or use the key of an image from your Gallery (the key is in the Gallery section of the portal).
    icon_id
  2. The next three columns only apply to gallery images:
    • section: where the image appears, for example Responsible consumption
    • countries: where it appears, for example FR, DE, AT. Use "all" for all countries.
    • is_wide: TRUE shows the image larger

Italian Recycling

Several rows per product, one per packaging component.

sku

  1. packaging: pick from the dropdown.
    packaging
  2. material: pick from the dropdown.
    material
  3. collection_guideline: pick from the dropdown.
    collection_guideline
  4. numbering: filled in automatically from the material.
    numbering
  5. custom_name: optional. Your own name for the packaging.
    custom_name

Spanish Recycling

Several rows per product.

sku

  1. packaging: pick from the dropdown.
    packaging
  2. icon: pick the recyclability color: yellow, green, blue, brown or gray.
    icon

Packaging Information

This tab is for the packaging regulation (PPWR). It has several rows per product.

Packaging Information

  1. packaging_operator_type: pick from the dropdown. At the moment the only option is "Manufactured by".
  2. company_name_and_address: the company name and address. Line breaks are allowed.
  3. contact: the contact details.

Additional Information

Marketing links and a few display options. One row per product.

Additional Information

  • link_1, link_2, link_3: full links. They must start with https:// and contain no spaces.
  • remove_all_links: removes all existing links of the product.
  • show_links_only_in_allowed_countries: wine and aromatised wine only. TRUE shows links only in the countries that allow them.
  • hide_links_for_countries: country codes where links are hidden, separated by commas, for example BE, ES, AT. This only works for spirits, or if the previous column is FALSE.
  • image_key, text_color, hide_learn_more_text: display options. text_color is a hex code such as #FFFFFF.

To add text for the links, use the Translatable Fields tab (for example additional_information_link_1_text).

Translatable Fields

Use this tab only for custom text.

  1. Pick the field from the dropdown. Examples: product_origin_expression (if empty, "Produced in:" is used), product_custom_field_label_1 and product_custom_field_value_1, free-section_title_1 and free-section_text_1 ("Other" templates only), ingredients, product_description, ingredient_category, ingredient_name.
  2. Enter the text in the English column, then add the translations in the language columns.

Notes:

  • The dropdown shows up to 3 custom fields. For more, change the number at the end of the field name, for example product_custom_field_label_4.
  • For a custom ingredient or category, the default-language text must be exactly as you typed it in the Ingredients tab.

Country-specific Fields

sku

  1. Pick the field from the dropdown, for example Impressum, or a business operator name, address or contact.
    field
  2. Enter the text in the "All countries" column, or in the column of a specific country. A country column replaces "All countries" for that country.

Settings

One row per product. These columns control how the e-label page looks.

Settings

  • logo_key: the key of a logo from your Gallery.
  • primary_color, background_color, alcohol_color: hex codes, for example #000000.
  • page_title: the title shown in the browser tab.
  • page_footer_line_1, page_footer_line_2: footer text.
  • privacy_link: a link that starts with https://. Add the link text in Translatable Fields (privacy_link_text).
  • default_country: the country whose specific information is shown when someone scans from a non-EU country. Leave it empty to show the global information.
  • show_content_in_language_of_country: TRUE shows the content in the language of the country where the code is scanned. FALSE (default) uses the language of the consumer's phone.

Uploading the completed template

  1. On the first screen (Get ready), click CHOOSE FILE and select your completed template. The supported formats are .xls and .xlsx.
  2. Select the language you used in the file, and the languages to publish.
  3. Click NEXT. The button turns active once a file is chosen.
  4. File checkup (step 2): the Overview shows the template version, the e-label category, the input language, and the languages your e-labels will be published to. Check that they are correct before you continue. Below it, the File summary shows what will be updated.

File checkup screen with the Overview

IMPORTANT:

  • You can use the template to create e-labels and to update them.
  • There are no checks that warn you about something you did not update.
  • Review each e-label after the upload to make sure everything looks right.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments