Complaint-handling, after-sales and commercial guarantee check sheet for EU web shops: CRD Art 6(1)(d)/(g)/(l)/(la)/(lb)/(m)/(t) legal guarantee of conformity for accountants, bookkeepers and web agencies
What you get: one check sheet for EU web shops with one row per shop. You answer twelve questions from the product, terms, guarantee and contact pages (complaint-handling policy, complaint address, legal guarantee of conformity for goods or digital content/services, commercial guarantee of durability, after-sales conditions, out-of-court ADR). Formulas grade Articles 6(1)(d), 6(1)(g), 6(1)(l), 6(1)(la), 6(1)(lb), 6(1)(m) and 6(1)(t) of the Consumer Rights Directive and return OK / FIX / CHECK BY HAND / OUT OF SCOPE. Optional: use the ecom scraper to sample guarantee wording on product pages and the contact scraper to find complaint email/phone. Example rows are made up. Rebuild formulas are below so you do not need our binary .xlsx.
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.
Not legal advice. This is a practical collect sheet for accountants, bookkeepers, web agencies and SME shops. Grades and templates are our reading of the Official Journal text (flagged). National transposition, the full Article 22a harmonised notice/label, and Commission guidance are listed under unread sources.
Who this is for
- Accountants and bookkeepers who review EU client web shops before year-end or a marketplace onboarding.
- Web agencies building or auditing Shopify/WooCommerce shops for B2C distance sales in the EU.
- SME web shops that already covered contact details, delivery and withdrawal info and still need the complaint / guarantee / after-sales block.
Related (already published, do not redo here): contact/hotline Art 6(1)(c)+21; delivery/shipping Art 6(1)(e)/(g)+18; withdrawal information Art 6(1)(h)+9–11; checkout order button Art 8(2)/8(3)/22; Art 11a withdrawal button; imprint ECD Art 5. This sheet is the missing complaint-handling + legal/commercial guarantee + after-sales + ADR pre-contract block.
Step 1: sample guarantee and complaint signals with the scrapers
Ecom scraper — product and terms pages
Open the Shopify & WooCommerce Product + Price Tracker (half-price actor). Paste a short list of product URLs (and, if the shop exposes them as product-like pages, guarantee or terms URLs). Export the dataset CSV. Columns such as description, title and any terms/HTML fields often contain words like guarantee, garantie, warranty, conformit, Reklamation, réclamation, after-sales. Paste that text into column M of the sheet; column O is a word-scan hint only (our reading — not a legal pass).
Contact scraper — complaint email / phone
Open the Website Contact Scraper: Emails, Phones & WhatsApp. Start on the shop’s contact, imprint, help or /reklamation page. Put the best shared inbox or phone into column L. Full Art 6(1)(c) / Art 21 hotline rules are on the contact check sheet linked below — here L is only a collect field for the complaint channel.
Free, without either scraper: open the product page, footer, AGB/terms and contact page yourself; paste what you see into M and L. The formulas do not need Apify.
Step 2: the sheet, one row per shop (columns A to V)
| Col | Header | Role |
|---|---|---|
| A | Shop URL | Input |
| B | Product/service type (Goods/Digital content/Services) | Input |
| C | Distance or off-premises contract? (Y/N) | Input |
| D | B2C (sells to consumers)? (Y/N) | Input |
| E | Complaint-handling policy shown before order? (Y/N/Partial/Not sure) | Input — Art 6(1)(g) |
| F | Complaint address Art 6(1)(d)? (Y/N/Same as establishment/Not sure) | Input |
| G | Legal guarantee goods 2y reminder Art 6(1)(l)? (Y/N/Partial/N/A/Not sure) | Input |
| H | Commercial durability guarantee Art 6(1)(la)? (Y/N/N/A (none offered)/Partial/Not sure) | Input |
| I | Legal guarantee digital Art 6(1)(lb)? (Y/N/N/A/Partial/Not sure) | Input |
| J | After-sales / commercial guarantees Art 6(1)(m)? (Y/N/Partial/N/A (none)/Not sure) | Input |
| K | Out-of-court ADR Art 6(1)(t)? (Y/N/Partial/N/A (not subject)/Not sure) | Input |
| L | Complaint email/phone found | Input (collect) |
| M | Pasted guarantee/complaint/ADR text | Input |
| N | Notes | Input |
| O | Word-scan hint | Formula |
| P | Art 6(1)(g) complaint policy status | Formula |
| Q | Art 6(1)(d) complaint address status | Formula |
| R | Art 6(1)(l)/(lb) legal guarantee status | Formula |
| S | Art 6(1)(la)/(m) commercial/after-sales status | Formula |
| T | Art 6(1)(t) ADR status | Formula |
| U | To-do (with article cites) | Formula |
| V | Result | Formula — OK / FIX / CHECK BY HAND / OUT OF SCOPE |
Formula O2 (word-scan hint — our reading):
IF(A2="","",IF(M2="","NO TEXT PASTED",IF(OR(ISNUMBER(SEARCH("complaint",LOWER(M2))),ISNUMBER(SEARCH("reklamation",LOWER(M2))),ISNUMBER(SEARCH("réclamation",LOWER(M2))),ISNUMBER(SEARCH("reclamation",LOWER(M2))),ISNUMBER(SEARCH("klacht",LOWER(M2))),ISNUMBER(SEARCH("reclamo",LOWER(M2))),ISNUMBER(SEARCH("reclamaci",LOWER(M2))),ISNUMBER(SEARCH("guarantee",LOWER(M2))),ISNUMBER(SEARCH("garantie",LOWER(M2))),ISNUMBER(SEARCH("garanzia",LOWER(M2))),ISNUMBER(SEARCH("garantía",LOWER(M2))),ISNUMBER(SEARCH("warranty",LOWER(M2))),ISNUMBER(SEARCH("conformit",LOWER(M2))),ISNUMBER(SEARCH("after-sales",LOWER(M2))),ISNUMBER(SEARCH("after sales",LOWER(M2))),ISNUMBER(SEARCH("kundendienst",LOWER(M2))),ISNUMBER(SEARCH("odr",LOWER(M2))),ISNUMBER(SEARCH("adr",LOWER(M2))),ISNUMBER(SEARCH("ombuds",LOWER(M2)))),"COMPLAINT/GUARANTEE/ADR WORDS FOUND","NO COMPLAINT/GUARANTEE/ADR WORDS FOUND")))
Formula P2 (Art 6(1)(g) complaint policy):
IF(A2="","",IF(OR(C2<>"Y",D2<>"Y"),"OUT OF SCOPE (NOT A DISTANCE/OFF-PREMISES B2C CONTRACT)",IF(E2="Y","OK: COMPLAINT-HANDLING POLICY SHOWN BEFORE ORDER (ART 6(1)(g))",IF(E2="N","FIX: SHOW COMPLAINT-HANDLING POLICY BEFORE THE CONSUMER IS BOUND (ART 6(1)(g))",IF(E2="Partial","CHECK BY HAND: PARTIAL COMPLAINT POLICY — COMPLETE ART 6(1)(g)",IF(E2="Not sure","CHECK BY HAND: CONFIRM COMPLAINT-HANDLING POLICY (ART 6(1)(g))","CHECK BY HAND: FILL COLUMN E"))))))
Formula Q2 (Art 6(1)(d) complaint address):
IF(A2="","",IF(OR(C2<>"Y",D2<>"Y"),"OUT OF SCOPE",IF(OR(F2="Y",F2="Same as establishment"),"OK: COMPLAINT ADDRESS COVERED (ART 6(1)(d))",IF(F2="N","FIX: GIVE THE ADDRESS WHERE THE CONSUMER CAN ADDRESS COMPLAINTS (ART 6(1)(d))",IF(OR(F2="Not sure",F2=""),"CHECK BY HAND: FILL COLUMN F (ART 6(1)(d))","CHECK BY HAND")))))
Formula R2 (Art 6(1)(l) goods / (lb) digital):
IF(A2="","",IF(OR(C2<>"Y",D2<>"Y"),"OUT OF SCOPE",IF(B2="Goods",IF(G2="Y","OK: LEGAL GUARANTEE OF CONFORMITY REMINDER FOR GOODS (ART 6(1)(l); SGD 2019/771 2 YEARS)",IF(G2="N","FIX: REMIND CONSUMERS OF THE LEGAL GUARANTEE OF CONFORMITY FOR GOODS — MIN 2 YEARS (ART 6(1)(l))",IF(G2="Partial","CHECK BY HAND: PARTIAL LEGAL-GUARANTEE REMINDER (ART 6(1)(l))",IF(G2="N/A","CHECK BY HAND: GOODS ROW — ART 6(1)(l) USUALLY APPLIES","CHECK BY HAND: FILL COLUMN G (ART 6(1)(l))")))),IF(OR(B2="Digital content",B2="Services"),IF(I2="Y","OK: LEGAL GUARANTEE REMINDER FOR DIGITAL CONTENT/SERVICES (ART 6(1)(lb))",IF(I2="N","FIX: REMIND CONSUMERS OF THE LEGAL GUARANTEE FOR DIGITAL CONTENT/SERVICES (ART 6(1)(lb))",IF(I2="N/A","CHECK BY HAND: DIGITAL/SERVICES — CONFIRM WHETHER ART 6(1)(lb) APPLIES",IF(I2="Partial","CHECK BY HAND: PARTIAL DIGITAL LEGAL-GUARANTEE REMINDER (ART 6(1)(lb))","CHECK BY HAND: FILL COLUMN I (ART 6(1)(lb))")))),"CHECK BY HAND: SET PRODUCT TYPE (B)"))))
Formula S2 (Art 6(1)(la)/(m)):
IF(A2="","",IF(OR(C2<>"Y",D2<>"Y"),"OUT OF SCOPE",IF(AND(OR(H2="Y",H2="N/A (none offered)"),OR(J2="Y",J2="N/A (none)")),"OK: COMMERCIAL DURABILITY / AFTER-SALES DISCLOSURE ON THESE ANSWERS (ART 6(1)(la)/(m))",IF(OR(H2="N",J2="N"),"FIX: DISCLOSE COMMERCIAL GUARANTEE OF DURABILITY AND/OR AFTER-SALES CONDITIONS WHEN APPLICABLE (ART 6(1)(la)/(m))",IF(OR(H2="Partial",J2="Partial",H2="Not sure",J2="Not sure",H2="",J2=""),"CHECK BY HAND: FILL H AND J (ART 6(1)(la)/(m))","CHECK BY HAND")))))
Formula T2 (Art 6(1)(t) ADR):
IF(A2="","",IF(OR(C2<>"Y",D2<>"Y"),"OUT OF SCOPE",IF(OR(K2="Y",K2="N/A (not subject)"),"OK: OUT-OF-COURT COMPLAINT/ADR INFO ON THESE ANSWERS (ART 6(1)(t))",IF(K2="N","FIX: STATE WHETHER AN OUT-OF-COURT COMPLAINT AND REDRESS MECHANISM APPLIES AND HOW TO ACCESS IT (ART 6(1)(t))",IF(OR(K2="Partial",K2="Not sure",K2=""),"CHECK BY HAND: FILL COLUMN K (ART 6(1)(t))","CHECK BY HAND")))))
Formula U2 (to-do; LibreOffice/Excel may need _xlfn.TEXTJOIN):
IF(A2="","",IF(OR(C2<>"Y",D2<>"Y"),"OUT OF SCOPE — NOT A DISTANCE/OFF-PREMISES B2C SHOP ON THESE ANSWERS",_xlfn.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",""))))
Formula V2 (result):
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(LEFT(P2,2)="OK",LEFT(Q2,2)="OK",LEFT(R2,2)="OK",LEFT(S2,2)="OK",LEFT(T2,2)="OK"),"OK","CHECK BY HAND")))))
Rebuild the .xlsx from these formulas
Binary spreadsheets cannot ship through our publish path. Rebuild the workbook in Excel, Google Sheets or LibreOffice:
- New workbook. Rename the first sheet
Shops. Create a second sheetSettings; put the label "Today" in A1 and the date2026-11-03(or=TODAY()) in B1. - In
Shopsrow 1 paste the column headers A–V exactly as listed in the table above. - In O2 paste the O formula (add a leading
=). Repeat for P2–V2. For U2, if Excel complains about TEXTJOIN, try_xlfn.TEXTJOIN(LibreOffice accepts TEXTJOIN; our LibreOffice test used_xlfn.TEXTJOIN). - Fill O2:V2 down for as many shop rows as you need. Leave one empty data row to confirm formulas stay blank when A is empty.
- Optional: freeze row 1; set column widths so status columns P–V are readable.
We keep a LibreOffice-tested copy in our build folder for internal checks; the formulas above are the source of truth for anyone rebuilding the sheet.
Step 3: the five-minute checklist per shop
- Is a complaint-handling policy shown before the consumer is bound? (E / Article 6(1)(g) — separate from the delivery half of (g) covered in the delivery sheet.)
- Is the complaint address given, or clearly the same as the establishment address? (F / Article 6(1)(d).)
- For goods: is there a prominent reminder of the legal guarantee of conformity, including the minimum two-year duration under Directive (EU) 2019/771? (G / Article 6(1)(l).)
- If the producer offers a free commercial guarantee of durability >2 years and told the trader: is that disclosed with duration + legal-guarantee reminder? (H / Article 6(1)(la).) If none is offered, mark N/A (none offered).
- For digital content / digital services: is the legal-guarantee reminder present? (I / Article 6(1)(lb).)
- Where the shop offers after-sale assistance, after-sales services or commercial guarantees, are existence and conditions stated? (J / Article 6(1)(m).)
- Where the trader is subject to an out-of-court complaint and redress mechanism, is that stated with how to access it? (K / Article 6(1)(t).)
- Take dated screenshots of product, terms, guarantee and contact pages (Article 6(9) burden of proof on the trader).
Tested: twelve made-up shops
| Row | Scenario | V (result) |
|---|---|---|
| 1 | shoes.de — full goods complaint policy, legal guarantee, ADR; no commercial durability offered | OK |
| 2 | gadgets.nl — missing complaint policy, address, legal guarantee, after-sales, ADR | FIX |
| 3 | ebook.ie — digital with Art 6(1)(lb) + after-sales; ADR N/A | OK |
| 4 | stream.fr — digital missing Art 6(1)(lb) reminder | FIX |
| 5 | parts.at — B2B only | OUT OF SCOPE |
| 6 | bakery.be — not a distance contract | OUT OF SCOPE |
| 7 | lamps.be — partial answers across E–K | CHECK BY HAND |
| 8 | fridge.de — producer 5-year durability offered but not disclosed (H=N) | FIX |
| 9 | tea.it — ADR missing only | FIX |
| 10 | bike.pl — full goods + commercial durability disclosed | OK |
| 11 | coach.es — services with digital legal guarantee + after-sales + ADR | OK |
| 12 | mode.fr — all Not sure | CHECK BY HAND |
LibreOffice Calc (xlsx→ods→csv) on 3 Nov 2026: 12/12 rows matched the intended V labels; empty row stayed blank; 0 errors. Settings!B1 fixed to 2026-11-03 for the test.
Copy-ready pre-contract block (footer / terms / product — our reading)
Complaint-handling: email [inbox] or write to [complaint address if different from our establishment address]. We aim to reply within [N] working days. Legal guarantee of conformity (goods): you have a legal guarantee of conformity under Directive (EU) 2019/771 / your national rules. The minimum duration is two years from delivery. This legal guarantee is unaffected by any commercial guarantee. [If a producer commercial guarantee of durability >2 years is offered at no extra cost:] This product also benefits from a commercial guarantee of durability of [duration] offered by [producer]. The legal guarantee of conformity still applies. After-sales: [existence and conditions of after-sale customer assistance / after-sales services / any commercial guarantee we offer]. Out-of-court redress: [if applicable] You may use [ADR body / ODR link] — [how to access].
Copy-ready client email
Subject: Quick check — complaint policy, legal/commercial guarantees and after-sales on your EU web shop Hi [Name], We ran your shop against Consumer Rights Directive Art 6(1)(d)/(g)/(l)/(la)/(lb)/(m)/(t) (complaint address, complaint-handling policy, legal guarantee reminder, commercial durability guarantee, after-sales, out-of-court ADR). Result for [shop]: [OK / FIX / CHECK BY HAND] Main gaps: [paste column U] Happy to walk through the two-year legal guarantee reminder and any producer durability guarantee wording with your developer. — [Your name]
Limits and open points
- Our reading (flagged): column list and OK/FIX/CHECK BY HAND grades; word-scan list in O; B2B and non-distance out of scope; N/A (none offered) / N/A (none) / N/A (not subject) as clean passes on S/T when nothing applies; templates above; treating Services rows under Art 6(1)(lb) when the offer is digital-service-like.
- Not read (flagged on Sources): full Article 22a harmonised notice/label text (referenced in Art 6(1)(l)/(la) of the 27.09.2026 consolidation but not extracted as a standalone article in our cellar pull today); national transposition of CRD and SGD; Commission CRD guidance/Q&A; Directive (EU) 2019/770 digital content remedies beyond the Art 6(1)(lb) reminder; ADR Directive / ODR Regulation case-by-case mapping; CJEU case law on commercial guarantees.
- Delivery and payment arrangements inside Art 6(1)(g) are covered by the separate delivery check sheet — do not double-count them here.
Related free check sheets
- Contact details and customer hotline check sheet (CRD Art 6(1)(c), 21)
- Delivery arrangements and shipping-costs check sheet (CRD Art 6(1)(e)/(g), Art 18)
- Withdrawal information check sheet (CRD Art 6(1)(h), 9–11, Annex I)
- Checkout and order button check sheet (CRD Art 8(2), 8(3), C-249/21)
- Withdrawal button check sheet (CRD Art 11a)
- Website legal notice / imprint check sheet (E-commerce Directive Art 5)
Frequently asked questions
Must an EU distance web shop tell consumers about its complaint-handling policy before they order?
Article 6(1)(g) of Directive 2011/83/EU requires, before the consumer is bound by a distance or off-premises contract, information on the arrangements for payment, delivery, performance, the time by which the trader undertakes to deliver, and, where applicable, the trader’s complaint handling policy. The delivery half of (g) is in our delivery check sheet; this sheet focuses on the complaint-handling policy.
What must a shop say about the legal guarantee of conformity for goods?
Article 6(1)(l) requires a reminder of the existence of the legal guarantee of conformity for goods and its main elements, including its minimum duration of two years as provided in Directive (EU) 2019/771, in a prominent manner, using the harmonised notice referred to in Article 22a. SGD Article 10 sets the two-year liability period for lack of conformity that becomes apparent within two years of delivery.
What is the commercial guarantee of durability in Article 6(1)(la)?
Where the producer offers a commercial guarantee of durability at no additional cost, covering the entire good for more than two years, and makes that information available to the trader, Article 6(1)(la) requires the trader to disclose that benefit, its duration, and a reminder of the legal guarantee, using the harmonised label in Article 22a. SGD Article 17 covers commercial guarantee statements.
What does Article 6(1)(m) add beyond the legal guarantee?
Where applicable, information on the existence and the conditions of after sale customer assistance, after-sales services and commercial guarantees — separate from the mandatory legal guarantee reminder in (l)/(lb).
Do shops also have to mention out-of-court complaint bodies?
Article 6(1)(t) requires, where applicable, information on recourse to an out-of-court complaint and redress mechanism to which the trader is subject, and how to access it. If not subject, mark N/A (not subject) and keep evidence.
Is the complaint address the same as the contact details sheet?
Article 6(1)(d) covers the geographical address where the consumer can address complaints if different from the establishment address in 6(1)(c). The contact/hotline sheet covers phone, email and Art 21; this sheet only checks the complaint-address point.
Sources
- Directive 2011/83/EU on consumer rights, consolidated text 27.09.2026: Articles 6(1)(d), 6(1)(g), 6(1)(l), 6(1)(la), 6(1)(lb), 6(1)(m), 6(1)(t), 6(9); Article 5(1)(d)/(e)/(ea)/(ec) compared for on-premises contracts — CELEX 02011L0083-20260927 (Official Journal text via Publications Office cellar, read 3 Nov 2026)
- Directive (EU) 2019/771 on certain aspects concerning contracts for the sale of goods: Article 10 (liability period / two years), Article 17 (commercial guarantees), definition of commercial guarantee — CELEX 32019L0771 (cellar, read 3 Nov 2026)
- Article 22a harmonised notice/label — referenced in consolidated Art 6(1)(l)/(la); full Article 22a text not extracted from today’s cellar pull (flagged unread)
- National CRD/SGD transposition, Commission CRD guidance/Q&A, Directive (EU) 2019/770 digital-content remedies detail, ADR/ODR mapping, CJEU commercial-guarantee case law — not read (flagged)
- E-commerce Product Data Scraper — apify.com/laudable_instrument/ecommerce-product-data-half-price (store/API metadata read 3 Nov 2026)
- Contact Details Scraper — apify.com/laudable_instrument/contact-details-scraper-half-price (store/API metadata read 3 Nov 2026)
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.
Unadhi Guides are free, independent explainers. We correct errors as soon as we find them: write to mininglife7@gmail.com.