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
- How the template works
- Removing data
- The template tabs:
- Uploading the completed template
Getting the template
1. Go to QR Manager and click on UPLOAD E-LABEL DATA:
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:
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 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.
| Column | What to enter |
|---|---|
| sku | The product SKU |
| product_type | Pick from the dropdown or type your own text. For "Other" templates you must type your own text. |
| 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 |
| 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 |
| origin | Country of origin: a 2-letter code (for example AR) or pick from the dropdown |
| producing_year | Spirit only: the age of the spirit in years |
| vintage_year | Wine only: the year, for example 2015 |
| grape_variety | Wine only: free text |
| 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 |
| production_method | Wine only: pick from the dropdown |
| 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.
- In the Product Information tab, go to the column
bottled_in_protected_atmosphere_msg. - 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
- To remove the message from a product, type or select
#REMOVEin 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.
-
sku: the product SKU.
- remove_all_existing_data: see "Removing data".
- aromatised_base_wine_name: aromatised wine only. Pick the base grapevine product from the dropdown, or "Not an aromatised wine".
-
ingredient: pick from the dropdown. Ingredients are grouped by category, for example Main ingredients, Preservatives and antioxidants, or Acidity regulators.
-
is_allergen: TRUE or FALSE. If TRUE, the ingredient appears in bold in the INGREDIENTS section.
-
is_organic: TRUE or FALSE. If TRUE, the ingredient is marked with an asterisk.
To add an ingredient that is not on the list, use the Translatable Fields tab.
Nutrition
One row per product.
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:
The show_zero_values_as_negligible column:
Pictograms
One row per pictogram.
-
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).
- 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.
-
packaging: pick from the dropdown.
-
material: pick from the dropdown.
-
collection_guideline: pick from the dropdown.
-
numbering: filled in automatically from the material.
-
custom_name: optional. Your own name for the packaging.
Spanish Recycling
Several rows per product.
-
packaging: pick from the dropdown.
-
icon: pick the recyclability color: yellow, green, blue, brown or gray.
Packaging Information
This tab is for the packaging regulation (PPWR). It has several rows per product.
- packaging_operator_type: pick from the dropdown. At the moment the only option is "Manufactured by".
- company_name_and_address: the company name and address. Line breaks are allowed.
- contact: the contact details.
Additional Information
Marketing links and a few display options. One row per product.
- 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.
- Pick the field from the dropdown. Examples:
product_origin_expression(if empty, "Produced in:" is used),product_custom_field_label_1andproduct_custom_field_value_1,free-section_title_1andfree-section_text_1("Other" templates only),ingredients,product_description,ingredient_category,ingredient_name. - 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
- Pick the field from the dropdown, for example Impressum, or a business operator name, address or contact.
- 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.
- 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
- On the first screen (Get ready), click CHOOSE FILE and select your completed template. The supported formats are .xls and .xlsx.
- Select the language you used in the file, and the languages to publish.
- Click NEXT. The button turns active once a file is chosen.
- 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.
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.
Comments