Online food shop check sheet for EU web shops: ingredients, the 14 allergens and the nutrition table before purchase (Food Information Regulation (EU) No 1169/2011, Articles 9, 14, 21 and 44) for accountants, bookkeepers and web agencies
Partner programme opening soon: join the free waitlist. Planned terms are 50% of each referred sale (75% once you have 5+ paying customers), single level, paid through Gumroad only from revenue received.
What you get: a finished online food shop check sheet for web shops that sell honey, coffee, tea, sweets, snacks, jams, sauces, cheese, wine, spirits, bread or meal boxes. The product pages tab has one row per product. A product scraper fills in the URL, title and description. One formula looks for key words (ingredients, allergens, nutrition, producer) in the scraped text, in English, German, French, Dutch, Italian, Spanish and Polish, so you know where to look first. You confirm ten things on the live page, and a second formula writes the fix list, citing the Article for each line. A third formula gives the result. You also get a copy-ready food information block for a product page, a delivery checklist and a client email. Made-up example rows show how it fills in. We tested the formulas in a spreadsheet before publishing.
Short answer: under Article 14(1)(a) of the EU Food Information Regulation (EU) No 1169/2011, when prepacked food is sold at a distance (a web shop, an online marketplace listing, a phone or catalogue order), the mandatory food information must be available before the purchase is concluded, on the selling material or through other clearly identified means, at no extra cost. The only exception is the date (best before or use by), which, like everything else, must be there at delivery (Article 14(1)(b)). The mandatory list is in Article 9(1): name, ingredients, allergens, quantity of certain ingredients, net quantity, date, storage conditions, the food business operator's name and address, origin where required, instructions where needed, alcohol strength for drinks over 1.2% vol, and the nutrition declaration.
Why accountants, bookkeepers and web agencies should look at this now
- Small food shops often show only a photo of the pack. Many product pages have a title, a price and a nice description, but no ingredients list, no allergens and no nutrition table in text. Article 14(1)(a) asks for the information before purchase, and Article 9(2) says the particulars are given "with words and numbers".
- Allergens are the one item that applies to almost every food. Article 9(1)(c) covers the 14 groups listed in Annex II. For loose or made-to-order food (non-prepacked), Article 44(1)(a) still makes allergen information mandatory, and Article 14(2) applies the before-purchase rule to it.
- The shop is responsible for its own pages. Article 8(5) asks each food business operator to make sure the food information law that is relevant to its activities is met, and Article 8(4) says it must not change information in a way that misleads.
- It is a quick, billable check. About 15 minutes per shop for ten product pages, with one fix list you can send to the client or their web designer before the Christmas season.
Step 1: get the product list (scrapers, free during launch)
- Put your client shop homepages in a list. Run the E-commerce Product Data Scraper with
maxProductsPerShop: 20andincludeDescription: true. It returns one row per product withurl,shop,title,priceanddescription. ItsSHOPS_SUMMARYrecord gives each shop a status (ok,blocked-by-terms,blocked-by-robots,no-products-found...). - Optional: run the Contact Details Scraper on the same homepages to get each client shop's role mailbox (info@, shop@) for sending the fix list. Personal addresses are dropped by default.
- Both Actors check robots.txt and scan each shop's terms of service first. Shops that forbid crawling are skipped for free and reported. The scrapers do not judge the page. Ingredients and nutrition are often in a tab, an accordion or an image, so the key word column only tells you where to look first. You confirm columns H to Q by eye on the live page.
Step 2: tab 1, product pages (one row per product)
| Column | What to write | Source |
|---|---|---|
| A. Product page URL | url | Actor output |
| B. Shop | shop | Actor output |
| C. Scraper status | Shop status from SHOPS_SUMMARY | Actor output |
| D. Title | title | Actor output |
| E. Description | description | Actor output |
| F. Key words not found | Formula below | our working rule |
| G. Food type | Prepacked / Prepacked alcohol over 1.2% / Non-prepacked (loose, packed at your request, made to order) / Not food | you; Art 2(2)(e), Art 44 |
| H. Name of the food | Yes/No | Art 9(1)(a) |
| I. List of ingredients | Yes/No/n.a. | Art 9(1)(b); not mandatory for drinks over 1.2% vol (Art 16(4)) |
| J. Allergens shown (emphasised in the list, or "Contains ...") | Yes/No/None in product | Art 9(1)(c), Art 21(1), Annex II |
| K. % of an ingredient named or pictured (e.g. "strawberry jam": strawberries %) | Yes/No/n.a. | Art 9(1)(d), Art 22 |
| L. Net quantity | Yes/No | Art 9(1)(e) |
| M. Storage conditions or conditions of use | Yes/No/n.a. (none needed) | Art 9(1)(g) |
| N. Name and address of the food business operator | Yes/No | Art 9(1)(h), Art 8(1) |
| O. Nutrition declaration | Yes/No/Exempt (Annex V) /n.a. | Art 9(1)(l), Art 30(1), Annex V |
| P. Alcoholic strength (% vol) | Yes/No/n.a. | Art 9(1)(k) |
| Q. Language easily understood where the food is sold | Yes/No | Art 15 |
| R. Fix list | Formula below | our working rule |
| S. Result | Formula below: OK / FIX / ALLERGENS OK, CHECK NATIONAL RULES / NOT FOOD / CHECK BY HAND | our working rule |
F2 (key words not found), Google Sheets or Excel 365:
=IF(E2="","NO DESCRIPTION SCRAPED",
IF(TEXTJOIN("; ",TRUE,
IF(SUMPRODUCT(--ISNUMBER(SEARCH({"ingredient","zutaten","ingrédients","ingrediënten","ingredienti","ingredientes","składniki"},D2&" "&E2)))>0,"","ingredients"),
IF(SUMPRODUCT(--ISNUMBER(SEARCH({"allergen","contains","enthält","contient","bevat","contiene","may contain","kann spuren"},D2&" "&E2)))>0,"","allergens"),
IF(SUMPRODUCT(--ISNUMBER(SEARCH({"nutrition","kcal","kj","nährwert","nutritionnelle","voedingswaarde","valori nutrizionali","información nutricional"},D2&" "&E2)))>0,"","nutrition"),
IF(SUMPRODUCT(--ISNUMBER(SEARCH({"manufacturer","made by","producer","producteur","erzeuger","produced by","packed by","importer","hersteller","fabricant","producent","produttore","fabricante","distributed by"},D2&" "&E2)))>0,"","operator name"))="","All key words found","Not found: "&TEXTJOIN("; ",TRUE,
IF(SUMPRODUCT(--ISNUMBER(SEARCH({"ingredient","zutaten","ingrédients","ingrediënten","ingredienti","ingredientes","składniki"},D2&" "&E2)))>0,"","ingredients"),
IF(SUMPRODUCT(--ISNUMBER(SEARCH({"allergen","contains","enthält","contient","bevat","contiene","may contain","kann spuren"},D2&" "&E2)))>0,"","allergens"),
IF(SUMPRODUCT(--ISNUMBER(SEARCH({"nutrition","kcal","kj","nährwert","nutritionnelle","voedingswaarde","valori nutrizionali","información nutricional"},D2&" "&E2)))>0,"","nutrition"),
IF(SUMPRODUCT(--ISNUMBER(SEARCH({"manufacturer","made by","producer","producteur","erzeuger","produced by","packed by","importer","hersteller","fabricant","producent","produttore","fabricante","distributed by"},D2&" "&E2)))>0,"","operator name"))))
R2 (fix list):
=IF(AND(C2<>"",C2<>"ok"),"",
IF(OR(G2="",G2="Not food"),"",
IF(G2="Non-prepacked",
IF(J2="No","Show allergens (Annex II) before purchase (Art 44(1)(a); Art 14(2))",""),TEXTJOIN("; ",TRUE,
IF(H2="No","Show the name of the food (Art 9(1)(a))",""),
IF(AND(I2="No",NOT(G2="Prepacked alcohol over 1.2%")),"Show the list of ingredients (Art 9(1)(b); Art 18)",""),
IF(J2="No","Show allergens: emphasised in the ingredients list, or Contains + the Annex II name (Art 9(1)(c); Art 21(1))",""),
IF(K2="No","Give the % of the ingredient named or pictured (Art 22; Annex VIII)",""),
IF(L2="No","Show the net quantity (Art 9(1)(e))",""),
IF(M2="No","Show storage conditions or conditions of use (Art 9(1)(g))",""),
IF(N2="No","Show the name and address of the food business operator (Art 9(1)(h); Art 8(1))",""),
IF(AND(O2="No",NOT(G2="Prepacked alcohol over 1.2%")),"Show the nutrition declaration: energy, fat, saturates, carbohydrate, sugars, protein, salt (Art 9(1)(l); Art 30(1))",""),
IF(AND(G2="Prepacked alcohol over 1.2%",P2<>"Yes"),"Show the actual alcoholic strength by volume (Art 9(1)(k))",""),
IF(Q2="No","Give the food information in a language easily understood where the food is sold (Art 15)","")))))
S2 (result):
=IF(AND(C2<>"",C2<>"ok"),"CHECK BY HAND (scraper: "&C2&")",
IF(G2="","CHECK BY HAND (set food type)",
IF(G2="Not food","NOT FOOD",
IF(R2<>"","FIX",
IF(G2="Non-prepacked","ALLERGENS OK, CHECK NATIONAL RULES","OK")))))
The word lists in F are our suggestion. Add the words your clients use. A word found does not mean the information is complete, and a word not found does not mean it is missing (it may be in an image or a tab). Always confirm by eye. For non-prepacked food, the Regulation only makes allergens mandatory; other particulars apply only if the Member State has adopted national measures (Article 44(1)(b)), which we did not read, so the sheet says "CHECK NATIONAL RULES".
Example rows (made up, for illustration only). We entered these rows in a spreadsheet, and the formulas returned the results shown:
| B | D (title) | G | F (formula) | S (formula) |
|---|---|---|---|---|
| example-honey.de | Blütenhonig 500 g | Prepacked | Not found: allergens | OK (J: None in product; O: Exempt, Annex V point 1) |
| example-snacks.nl | Granola with almonds 400 g | Prepacked | Not found: ingredients; nutrition; operator name | FIX (ingredients, allergens, almond %, operator, nutrition) |
| example-wine.fr | Vin rouge 75 cl | Prepacked alcohol over 1.2% | Not found: ingredients; nutrition | OK (sulphites and % vol shown) |
| example-bakery.at | Sourdough loaf, baked to order | Non-prepacked | Not found: ingredients; allergens; nutrition; operator name | FIX (allergens before purchase) |
| example-cheese.ie | Cheddar 200 g | Prepacked | Not found: allergens | OK (MILK emphasised in the list) |
| example-tea.es | Ceramic mug | Not food | Not found: ingredients; allergens; nutrition; operator name | NOT FOOD |
| example-shop.it | NO DESCRIPTION SCRAPED | CHECK BY HAND (scraper: blocked-by-terms) | ||
| example-jam.be | Strawberry jam 370 g | Prepacked | Not found: allergens; nutrition; operator name | FIX (strawberry %, operator, language) |
| example-gin.dk | Dry gin 70 cl | Prepacked alcohol over 1.2% | Not found: ingredients; allergens; nutrition; operator name | FIX (alcoholic strength) |
Tab 2: the 14 allergen groups (Annex II, short names)
Use these names in J. Annex II has exceptions (for example wheat-based glucose syrups, fully refined soybean oil, lactitol); read the full Annex for the product in question.
- Cereals containing gluten (wheat incl. spelt and khorasan, rye, barley, oats)
- Crustaceans
- Eggs
- Fish
- Peanuts
- Soybeans
- Milk (including lactose)
- Nuts: almonds, hazelnuts, walnuts, cashews, pecans, Brazil nuts, pistachios, macadamia or Queensland nuts
- Celery
- Mustard
- Sesame seeds
- Sulphur dioxide and sulphites over 10 mg/kg or 10 mg/litre (as total SO2)
- Lupin
- Molluscs
Article 21(1): the allergen name is shown in the list of ingredients and emphasised "through a typeset that clearly distinguishes it from the rest of the list", for example font, style or background colour. With no list of ingredients, write "Contains" followed by the Annex II name. No mention is needed where the name of the food clearly refers to the allergen. Online, use bold in the text list; we read Article 14 as asking for the same information on the page, and bold is our suggestion for showing the emphasis there.
Tab 3: who is exempt from the nutrition declaration (Annex V, selection)
Write Exempt in O only for foods in Annex V, for example: unprocessed single-ingredient products, waters, herbs and spices, salt, coffee beans, tea and herbal infusions without other added ingredients (except flavourings that do not change the nutritional value), vinegars, yeast, chewing gum, food in packs whose largest surface is under 25 cm², and food, including handcrafted food, "directly supplied by the manufacturer of small quantities of products to the final consumer or to local retail establishments directly supplying the final consumer" (point 19). Drinks over 1.2% vol need no ingredients list and no nutrition declaration under Article 16(4). The Regulation has applied since 13 December 2014; the nutrition declaration since 13 December 2016 (Article 55).
Copy-ready food information block for a product page
Name of the food: [legal or descriptive name, e.g. Strawberry jam]
Ingredients: sugar, strawberries (45%), gelling agent: pectin
Allergens: shown in bold in the ingredients. [Or: Contains: MILK, HAZELNUTS]
Net quantity: 370 g
Storage: Store in a cool, dry place. Once opened, keep refrigerated.
Nutrition per 100 g: Energy … kJ / … kcal · Fat … g · of which saturates … g ·
Carbohydrate … g · of which sugars … g · Protein … g · Salt … g
Alcohol: … % vol [drinks over 1.2% vol only]
Food business operator: [name or business name], [postal address]
Best before / use by: printed on the pack (sent with your order)
The example numbers are made up. Put the block in the page text, near the price or in a clearly labelled tab, not only in a photo of the pack.
Delivery checklist (Article 14(1)(b))
- Every pack delivered carries all mandatory particulars, including the best-before or use-by date (Article 9(1)(f)).
- If the shop repacks or splits food, the new pack has its own label: ask who is the operator under Article 8(1).
- Made-to-order or loose food: allergen information goes with the delivery; check national rules for the rest (Article 44).
Client email (copy and adapt)
Subject: Your food product pages: 10-minute fix list
Hello [name],
We checked [10] product pages on [shop]. EU food rules (Regulation 1169/2011,
Article 14) ask online food shops to show the mandatory food information before
the customer buys, in text: ingredients, allergens in bold, net quantity,
storage, nutrition and your name and address.
The attached sheet lists, per product, what to add and the Article behind it.
Most fixes are copy and paste from the pack. Can your web designer do this
before the Christmas orders start?
Best regards,
[your name]
What we did not check
- National rules (penalties, languages required, non-prepacked food under Article 44) and Commission guidance or Q&A on Article 14: not read.
- Product-specific EU rules (honey, wine, spirits, food supplements, organic, origin under Article 26, claims): not read.
- Later amendments to Regulation 1169/2011 after the consolidated text of 1 January 2018: not read.
Related free guides
- Unit price per kg or litre check sheet for web shops
- Green claims check sheet ("eco-friendly", "climate neutral")
- Consumer reviews check sheet for web shops
- Legal notice (imprint) check sheet for client websites
Frequently asked questions
Does the best-before date have to be on the product page?
No. Article 14(1)(a) excludes the particulars in Article 9(1)(f), the date of minimum durability or use-by date, from the before-purchase rule. It must be on the food at delivery (Article 14(1)(b)).
Is a photo of the label enough?
The Regulation does not say "text only", but Article 9(2) asks for words and numbers, Article 13(1) asks for information that is easily visible and clearly legible, and Article 14(1)(a) asks for it before purchase. A readable text block is the safer choice; this is our reading, not a ruling.
Do bakeries selling made-to-order bread online need a nutrition table?
For non-prepacked food, Article 44(1) makes only allergen information mandatory under the Regulation; the rest depends on national measures. For prepacked food, check Annex V point 19 for small producers supplying final consumers directly.
Unadhi Guides use only the sources named at the top. If you see an error, write to mininglife7@gmail.com and we will correct it.
Unadhi Guides are free, independent explainers. We correct errors as soon as we find them: write to mininglife7@gmail.com.