Total price, additional charges, personalised pricing and return-cost check sheet for EU web shops: CRD Art 6(1)(e)/(ea)/(i) Omnibus 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 total price, additional charges, personalised pricing and return-cost check sheet for EU web shops (Shopify, WooCommerce and similar). One row per product or checkout path: the ecom scraper fills title and price text, you paste a short price/cart/returns snippet and answer six questions, and the formulas return a word-scan hint, an Article 6(1)(e) total-price status, an Article 6(1)(e) additional-charges status, an Article 6(1)(e) subscription billing status, an Article 6(1)(ea) personalised-price status, an Article 6(1)(i) return-cost status, a to-do list with the Article behind each line and a result (OK, FIX, CHECK BY HAND or OUT OF SCOPE). Also included: a five-minute checklist, a copy-ready price block and a client email. We tested the formulas in LibreOffice on twelve made-up rows before publishing.
Short answer: before a consumer is bound by an online order, Article 6(1)(e) requires the total price inclusive of taxes (or the manner of calculation) and all additional freight, delivery, postal and other costs (or that such charges may be payable). For subscriptions and indeterminate contracts, the Omnibus amendment adds total costs per billing period and, for fixed-rate contracts, total monthly costs. Article 6(1)(ea) requires, where applicable, notice that the price was personalised on the basis of automated decision-making. Article 6(1)(i) covers return costs on withdrawal. If (e) or (i) information is missing, Article 6(6) says the consumer shall not bear those charges or costs. Article 8(2) also requires point (e) to be shown clearly and prominently directly before the order when the contract is concluded by electronic means.
Why accountants, bookkeepers and web agencies should look at this now
- Undisclosed extras are a money rule. Article 6(6) is blunt: miss the Article 6(1)(e) or (i) charges information and the consumer does not bear those charges.
- Subscription shops often show only “from EUR X / month”. After the Omnibus amendment, Article 6(1)(e) asks for total costs per billing period and, for fixed-rate contracts, total monthly costs.
- Personalised pricing needs a short notice. Article 6(1)(ea) is easy to miss on Shopify apps that score customers; Omnibus recital 45 distinguishes that from plain dynamic market pricing.
- It is a quick, billable catalogue check. Run the product scraper, open cart and checkout once per shop, answer the columns, and the sheet writes the fix list with Article cites. Use our separate delivery arrangements sheet for timing and green delivery, and the 30-day lowest-price log for Directive 98/6/EC Article 6a prior-price announcements (including Black Friday 27 Nov 2026).
Step 1: pull product title and price (scraper, free during launch)
- Put product URLs for each client shop into a list and run the E-commerce Product Data Scraper. Prefer Shopify products.json, WooCommerce Store API, then JSON-LD — you get title, brand, price, currency, compare-at/sale price, availability, SKU/GTIN, variants, images and description.
- Copy title into column E and price text into column F. Paste a short price-, cart-, checkout- or returns-related snippet into column G (the word-scan looks for price/total/VAT/subscription/personalised/return words).
- Shops blocked by robots or terms are skipped for free: fill E–G by hand for those.
- The scraper does not complete a checkout. Whether the tax-inclusive total, extras, subscription totals, personalised-price notice and return costs appear before the consumer is bound is your own check on product, cart, checkout and returns pages (Step 3).
Need emails and phones from the same shops? The Contact Details Scraper fills the contact and hotline check sheet linked below.
Step 2: the sheet, one row per product or checkout path (columns A to V)
Create a tab called Shops. Row 1 holds the headers below; paste the formulas into O2 to V2 and fill down. Add a Settings tab with Settings!B1 = 2026-11-03 (or =TODAY()). The formulas use only IF, AND, OR, LEFT, SEARCH, LOWER, ISNUMBER and TEXTJOIN (Excel 2019 or later, Microsoft 365, Google Sheets, LibreOffice). Binary .xlsx is kept in our stage only (GitHub text push); rebuild from the formulas below.
| Col | What goes in it | Based on |
|---|---|---|
| A | Shop website | You |
| B | Product or checkout URL checked | You |
| C | Distance or off-premises contract? Y or N | Art 2(7)-(8) |
| D | Sells online to consumers (not only businesses)? Y or N | Art 2(1)-(2) |
| E | Title from the ecom scraper | E-commerce Product Data Scraper |
| F | Price text from the ecom scraper | E-commerce Product Data Scraper |
| G | Pasted price / cart / checkout / returns text | You + scraper description |
| H | Total price tax-inclusive before order? Y, N, Manner of calculation or Not sure | Art 6(1)(e), Art 8(2) |
| I | Additional freight/delivery/other costs? Y, Free, Not calculable (stated), N, N/A (digital no ship) or Not sure | Art 6(1)(e), 6(6) |
| J | Subscription or indeterminate contract? Y, N or Not sure | Art 6(1)(e) Omnibus |
| K | If subscription: billing-period / monthly totals shown? Y, N, N/A or Not sure | Art 6(1)(e) Omnibus |
| L | Personalised automated price? Y (disclosed), Y (not disclosed), N (not personalised) or Not sure | Art 6(1)(ea); Omnibus rec. 45 |
| M | Return cost on withdrawal told? Y, N, N/A (digital/service) or Not sure | Art 6(1)(i), 6(6) |
| N | Notes | You |
| O | Word-scan hint (formula in f.json / rebuild) | Helper, not the law |
| P | Art 6(1)(e) total-price status | Art 6(1)(e) |
| Q | Art 6(1)(e) additional-charges status | Art 6(1)(e), 6(6) |
| R | Art 6(1)(e) subscription billing status | Art 6(1)(e) Omnibus |
| S | Art 6(1)(ea) personalised-price status | Art 6(1)(ea) |
| T | Art 6(1)(i) return-cost status | Art 6(1)(i), 6(6) |
| U | To-do list with Article cites | As cited |
| V | Result: OK / FIX / CHECK BY HAND / OUT OF SCOPE | Summary |
Formulas (paste into O2:V2, then fill down; {r} = row number):
O: =IF(A2="","",IF(G2="","NO TEXT PASTED",IF(OR(ISNUMBER(SEARCH("price",LOWER(G2))),ISNUMBER(SEARCH("total",LOWER(G2))),ISNUMBER(SEARCH("preis",LOWER(G2))),ISNUMBER(SEARCH("prix",LOWER(G2))),ISNUMBER(SEARCH("prijs",LOWER(G2))),ISNUMBER(SEARCH("prezzo",LOWER(G2))),ISNUMBER(SEARCH("precio",LOWER(G2))),ISNUMBER(SEARCH("vat",LOWER(G2))),ISNUMBER(SEARCH("mwst",LOWER(G2))),ISNUMBER(SEARCH("btw",LOWER(G2))),ISNUMBER(SEARCH("tva",LOWER(G2))),ISNUMBER(SEARCH("iva",LOWER(G2))),ISNUMBER(SEARCH("incl",LOWER(G2))),ISNUMBER(SEARCH("subscription",LOWER(G2))),ISNUMBER(SEARCH("abonnement",LOWER(G2))),ISNUMBER(SEARCH("abo",LOWER(G2))),ISNUMBER(SEARCH("personal",LOWER(G2))),ISNUMBER(SEARCH("personnal",LOWER(G2))),ISNUMBER(SEARCH("shipping",LOWER(G2))),ISNUMBER(SEARCH("versand",LOWER(G2))),ISNUMBER(SEARCH("retour",LOWER(G2))),ISNUMBER(SEARCH("return",LOWER(G2))),ISNUMBER(SEARCH("rücksend",LOWER(G2)))),"PRICE/TOTAL/RETURN WORDS FOUND","NO PRICE/TOTAL/RETURN WORDS FOUND")))
P: =IF(A2="","",IF(OR(C2<>"Y",D2<>"Y"),"OUT OF SCOPE (NOT A DISTANCE/OFF-PREMISES B2C CONTRACT)",IF(OR(H2="Y",H2="Manner of calculation"),"OK: TOTAL PRICE OR CALCULATION MANNER SHOWN BEFORE ORDER (ART 6(1)(e))",IF(H2="N","FIX: SHOW TOTAL PRICE INCLUSIVE OF TAXES BEFORE THE CONSUMER IS BOUND (ART 6(1)(e))",IF(H2="Not sure","CHECK BY HAND: CONFIRM TAX-INCLUSIVE TOTAL ON PRODUCT/CART/CHECKOUT (ART 6(1)(e))","CHECK BY HAND: FILL COLUMN H")))))
Q: =IF(A2="","",IF(OR(C2<>"Y",D2<>"Y"),"OUT OF SCOPE",IF(OR(I2="Y",I2="Free",I2="Not calculable (stated)",I2="N/A (digital no ship)"),"OK: ADDITIONAL CHARGES DISCLOSED OR N/A (ART 6(1)(e); ELSE CONSUMER NEED NOT BEAR THEM — ART 6(6))",IF(I2="N","FIX: DISCLOSE FREIGHT/DELIVERY/OTHER COSTS OR THAT THEY MAY BE PAYABLE — ELSE CONSUMER SHALL NOT BEAR THEM (ART 6(1)(e), 6(6))",IF(OR(I2="Not sure",I2=""),"CHECK BY HAND: FILL COLUMN I (ART 6(1)(e)/6(6))","CHECK BY HAND")))))
R: =IF(A2="","",IF(OR(C2<>"Y",D2<>"Y"),"OUT OF SCOPE",IF(OR(J2="N",J2=""),"N/A: NOT MARKED AS SUBSCRIPTION/INDETERMINATE",IF(J2="Not sure","CHECK BY HAND: IS THIS A SUBSCRIPTION OR INDETERMINATE CONTRACT? (ART 6(1)(e))",IF(J2="Y",IF(K2="Y","OK: BILLING-PERIOD / MONTHLY TOTAL COSTS SHOWN (ART 6(1)(e) OMNIBUS)",IF(K2="N","FIX: FOR SUBSCRIPTIONS SHOW TOTAL COSTS PER BILLING PERIOD AND MONTHLY COSTS IF FIXED-RATE (ART 6(1)(e))",IF(K2="N/A","CHECK BY HAND: SUBSCRIPTION ROW — CONFIRM BILLING TOTALS",IF(OR(K2="Not sure",K2=""),"CHECK BY HAND: FILL COLUMN K (ART 6(1)(e) SUBSCRIPTION)","CHECK BY HAND")))),"CHECK BY HAND: FILL COLUMN J")))))
S: =IF(A2="","",IF(OR(C2<>"Y",D2<>"Y"),"OUT OF SCOPE",IF(L2="N (not personalised)","OK: NO PERSONALISED AUTOMATED PRICE ON THESE ANSWERS (ART 6(1)(ea) N/A)",IF(L2="Y (disclosed)","OK: PERSONALISED PRICE DISCLOSED (ART 6(1)(ea))",IF(L2="Y (not disclosed)","FIX: INFORM CONSUMER THAT THE PRICE WAS PERSONALISED ON THE BASIS OF AUTOMATED DECISION-MAKING (ART 6(1)(ea))",IF(OR(L2="Not sure",L2=""),"CHECK BY HAND: FILL COLUMN L — PERSONALISED PRICING? (ART 6(1)(ea); DYNAMIC MARKET PRICING ALONE IS NOT ENOUGH PER OMNIBUS RECITAL 45)","CHECK BY HAND"))))))
T: =IF(A2="","",IF(OR(C2<>"Y",D2<>"Y"),"OUT OF SCOPE",IF(OR(M2="Y",M2="N/A (digital/service)"),"OK: RETURN-COST INFO COVERED OR N/A (ART 6(1)(i); ELSE CONSUMER NEED NOT BEAR — ART 6(6))",IF(M2="N","FIX: TELL CONSUMER IF THEY BEAR RETURN COSTS ON WITHDRAWAL — ELSE THEY SHALL NOT BEAR THEM (ART 6(1)(i), 6(6))",IF(OR(M2="Not sure",M2=""),"CHECK BY HAND: FILL COLUMN M (ART 6(1)(i)/6(6))","CHECK BY HAND")))))
U: =IF(A2="","",IF(OR(C2<>"Y",D2<>"Y"),"OUT OF SCOPE — NOT A DISTANCE/OFF-PREMISES B2C SHOP ON THESE ANSWERS",TEXTJOIN(" | ",TRUE,IF(LEFT(P2,3)="FIX",P2,""),IF(LEFT(Q2,3)="FIX",Q2,""),IF(LEFT(R2,3)="FIX",R2,""),IF(LEFT(S2,3)="FIX",S2,""),IF(LEFT(T2,3)="FIX",T2,""),IF(ISNUMBER(SEARCH("CHECK BY HAND",P2&Q2&R2&S2&T2)),"CHECK BY HAND: COMPLETE OPEN COLUMNS",""))))
V: =IF(A2="","",IF(OR(C2<>"Y",D2<>"Y"),"OUT OF SCOPE",IF(OR(LEFT(P2,3)="FIX",LEFT(Q2,3)="FIX",LEFT(R2,3)="FIX",LEFT(S2,3)="FIX",LEFT(T2,3)="FIX"),"FIX",IF(OR(ISNUMBER(SEARCH("CHECK BY HAND",P2)),ISNUMBER(SEARCH("CHECK BY HAND",Q2)),ISNUMBER(SEARCH("CHECK BY HAND",R2)),ISNUMBER(SEARCH("CHECK BY HAND",S2)),ISNUMBER(SEARCH("CHECK BY HAND",T2))),"CHECK BY HAND",IF(AND(OR(LEFT(P2,2)="OK",LEFT(P2,3)="N/A"),OR(LEFT(Q2,2)="OK",LEFT(Q2,3)="N/A"),OR(LEFT(R2,2)="OK",LEFT(R2,3)="N/A"),OR(LEFT(S2,2)="OK",LEFT(S2,3)="N/A"),OR(LEFT(T2,2)="OK",LEFT(T2,3)="N/A")),"OK","CHECK BY HAND")))))
About column O: it only reports whether price/total/VAT/subscription/personalised/return words appear in the pasted text. It is a hint to look harder at H–M, never a legal result on its own.
Step 3: the five-minute checklist per shop
- Open a typical product page. Is the total price inclusive of taxes clear (or the manner of calculation if the price cannot be fixed in advance)? (Column H / Article 6(1)(e); also Article 8(2) prominence before the order button.)
- Add to cart and open the last checkout step before paying. Are freight, delivery, postal and other costs shown as an amount, as free, or as a clear “may be payable” note? (I / Article 6(1)(e) and 6(6).)
- If the offer is a subscription or indeterminate contract, are total costs per billing period (and monthly costs if fixed-rate) shown? (J–K / Omnibus amendment to Article 6(1)(e).)
- If the shop personalises prices with automated decision-making, is that stated? Dynamic market pricing alone is not enough (L / Article 6(1)(ea); Omnibus recital 45).
- For goods: does the returns page say who pays return costs on withdrawal? If not told, the consumer shall not bear them (M / Articles 6(1)(i) and 6(6)).
- Take dated screenshots of product, cart, checkout and returns (Article 6(9) burden of proof on the trader).
Tested: twelve made-up shops (LibreOffice)
| Row | Shop (made-up) | V (result) |
|---|---|---|
| 1 | shoes.de — tax-inclusive total, Versand shown, return cost told | OK |
| 2 | gadgets.nl — no total, no extras, no return cost | FIX |
| 3 | ebook.ie — digital, tax-inclusive, shipping N/A | OK |
| 4 | box.fr — subscription missing billing-period totals | FIX |
| 5 | parts.at — B2B only | OUT OF SCOPE |
| 6 | bakery.be — not distance | OUT OF SCOPE |
| 7 | lamps.be — all answers Not sure | CHECK BY HAND |
| 8 | mode.fr — personalised price not disclosed | FIX |
| 9 | stream.es — subscription totals + personalised disclosed | OK |
| 10 | tea.it — extras and return cost missing | FIX |
| 11 | furniture.pl — manner of calculation + charges may be payable | OK |
| 12 | wine.de — subscription OK, return cost missing | FIX |
All twelve gave the intended result in LibreOffice on the first run, with 0 errors; an empty row stays blank. Rebuild the workbook from the formulas above (or from f.json in the stage folder) — the binary .xlsx is not pushed to GitHub.
Copy-ready price and charges block (product page, cart or footer)
Price and charges Total price: EUR [amount] inclusive of taxes (VAT/MwSt/BTW/TVA/IVA as applicable). If the price cannot be calculated in advance: we calculate it as follows: [manner]. Additional freight, delivery, postal or other costs to [country]: EUR [amount] (or: Free over EUR [threshold] / or: such additional charges may be payable if we cannot calculate them in advance — we will tell you before you place the order). Subscription / indeterminate contract (if applicable): total costs per billing period EUR [amount]; fixed-rate monthly total EUR [amount] (Consumer Rights Directive Article 6(1)(e) as amended by Directive (EU) 2019/2161). Personalised pricing (if applicable): the price shown to you was personalised on the basis of automated decision-making (Article 6(1)(ea)). Return of goods on withdrawal (if applicable): you will bear the cost of returning the goods [EUR amount / carrier]; if goods cannot normally be returned by post, the return cost is EUR [amount] (Article 6(1)(i)). If we do not give the Article 6(1)(e) or (i) charges information, you shall not bear those charges or costs (Article 6(6)).
Copy-ready client email
Subject: Total price, extras and personalised pricing on [shop] — quick EU check Hello [name], We checked [shop] against the EU Consumer Rights Directive. Before a customer is bound by an order you must show the total price inclusive of taxes and all additional charges (or that they may be payable) — Article 6(1)(e) and 6(6). Subscriptions need billing-period (and monthly fixed-rate) totals. If you personalise prices with automated decision-making, say so — Article 6(1)(ea). For goods, say who pays return costs on withdrawal — Article 6(1)(i). What we found: [paste column U] If you agree, we will update the product template, cart and checkout this week. [Your name]
Know shops or clients who would use this? 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.
Limits and open points
Read for this guide (3 Nov 2026 — same-day extracts; live EUR-Lex HTML empty today): Directive 2011/83/EU Article 6(1)(e), (ea), (i), Article 6(4) context, Article 6(6), Article 6(9), Article 8(2) (prominence of point (e) before the order); Directive (EU) 2019/2161 amending point (e) and inserting point (ea), including recital 45 on personalised vs dynamic pricing. Extracts reused from same-day workspace copies as disclosed in the meta line above.
Not read for this guide: a fresh live Publications Office cellar HTML (empty responses today); Court of Justice judgments on Article 6(1)(e)/(ea)/(i); national transposition laws and penalties; Commission CRD guidance / Q&A; full Article 14 return-of-goods mechanics beyond the 6(1)(i)/6(6) information rule; Directive 98/6/EC Article 6a prior-price rules (covered in separate guides).
Our reading, not the law's words: grading “calculated at next step” with no amount and no “may be payable” note as FIX under column I; treating digital downloads without physical return as N/A for column M; the word-scan language list; treating trade-only shops as out of scope; mapping Omnibus recital 45 into the column L “Not sure” hint; and the sample wording in the templates.
Related free check sheets
- Delivery arrangements, shipping costs and delivery date check sheet (CRD Art 6(1)(a)/(e)/(g), Art 18)
- Checkout and order button check sheet (CRD Art 8(2), 8(3), C-249/21)
- Withdrawal information check sheet (CRD Art 6(1)(h), 9, 10, Annex I)
- Complaint-handling, after-sales and commercial guarantee check sheet
- Contact details and customer hotline check sheet (CRD Art 6(1)(c), 21)
- Website legal notice / imprint check sheet (eCommerce Directive Art 5)
- GPSR product page check sheet (Art 19)
- 30-day lowest-price log (Price Indication Directive Art 6a)
Frequently asked questions
Must an EU web shop show a tax-inclusive total price before the consumer orders?
Article 6(1)(e) of Directive 2011/83/EU requires, before the consumer is bound by a distance or off-premises contract, 'the total price of the goods or services inclusive of taxes, or where the nature of the goods or services is such that the price cannot reasonably be calculated in advance, the manner in which the price is to be calculated, as well as, where applicable, all additional freight, delivery or postal charges and any other costs or, where those charges cannot reasonably be calculated in advance, the fact that such additional charges may be payable'. Article 8(2) also requires the trader to make the consumer aware of Article 6(1)(e) (among other points) in a clear and prominent manner directly before the order when the contract is concluded by electronic means and places the consumer under an obligation to pay.
What if shipping or other extra charges were not told before the order?
Article 6(6) says: if the trader has not complied with the information requirements on additional charges or other costs as referred to in point (e) of paragraph 1, or on the costs of returning the goods as referred to in point (i) of paragraph 1, the consumer shall not bear those charges or costs.
What extra total-price rules apply to subscriptions?
The Omnibus Directive (EU) 2019/2161 amended Article 6(1)(e). For a contract of indeterminate duration or a contract containing a subscription, the total price shall include the total costs per billing period. Where such contracts are charged at a fixed rate, the total price shall also mean the total monthly costs. Where the total costs cannot be reasonably calculated in advance, the manner in which the price is to be calculated shall be provided.
When must a shop say the price was personalised?
Article 6(1)(ea), inserted by Directive (EU) 2019/2161, requires, where applicable, that the consumer is informed 'that the price was personalised on the basis of automated decision-making'. Omnibus recital 45 explains that this covers personalisation based on automated decision-making and profiling of consumer behaviour; it should not apply to techniques such as dynamic or real-time pricing that change the price in response to market demands when those techniques do not involve personalisation based on automated decision-making.
Must return costs on withdrawal be stated?
Article 6(1)(i) requires, where applicable, that the consumer is told they will have to bear the cost of returning the goods in case of withdrawal and, for distance contracts, if the goods cannot normally be returned by post, the cost of returning the goods. If that information is missing, Article 6(6) says the consumer shall not bear those charges or costs. Our separate withdrawal-information check sheet covers Articles 6(1)(h), 9, 10, 11 and 16 in more depth.
Is this the same as the delivery or prior-price sheets?
No. The delivery arrangements sheet focuses on shipping timing, arrangements, green delivery and Article 18. The prior-price / 30-day lowest-price sheets cover Directive 98/6/EC Article 6a price-reduction announcements. This sheet grades tax-inclusive total price, additional charges, subscription billing totals, personalised automated pricing (Article 6(1)(ea)), and return-cost disclosure (Article 6(1)(i)) under the Consumer Rights Directive.
Not legal advice. The sheet sorts product and checkout paths one by one; it does not decide legal questions. Spotted an error? Write to mininglife7@gmail.com and we correct it.
Sources
- Directive 2011/83/EU (Consumer Rights Directive), Article 6(1)(e), (ea), (i), Article 6(6), Article 8(2) — same-day text extract reused 3 Nov 2026 (live EUR-Lex HTML empty).
- Directive (EU) 2019/2161 (Omnibus), amendment to Article 6(1)(e), insertion of Article 6(1)(ea), recital 45 — same-day extract reused 3 Nov 2026.
- Apify Store: E-commerce Product Data Scraper and Contact Details Scraper (Unadhi Actors).
Unadhi Guides are free, independent explainers. We correct errors as soon as we find them: write to mininglife7@gmail.com.