Unadhi Guides

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

Updated 3 Nov 2026 · Disclosure: the contact scraper and ecom scraper linked below are Unadhi products on the Apify Store. This guide is free, and the check sheet works with a CSV from any tool or by pasting page text by hand. Current Apify pricing is only on the Store page. This page has no affiliate links and nobody paid to be mentioned.

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

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)

ColHeaderRole
AShop URLInput
BProduct/service type (Goods/Digital content/Services)Input
CDistance or off-premises contract? (Y/N)Input
DB2C (sells to consumers)? (Y/N)Input
EComplaint-handling policy shown before order? (Y/N/Partial/Not sure)Input — Art 6(1)(g)
FComplaint address Art 6(1)(d)? (Y/N/Same as establishment/Not sure)Input
GLegal guarantee goods 2y reminder Art 6(1)(l)? (Y/N/Partial/N/A/Not sure)Input
HCommercial durability guarantee Art 6(1)(la)? (Y/N/N/A (none offered)/Partial/Not sure)Input
ILegal guarantee digital Art 6(1)(lb)? (Y/N/N/A/Partial/Not sure)Input
JAfter-sales / commercial guarantees Art 6(1)(m)? (Y/N/Partial/N/A (none)/Not sure)Input
KOut-of-court ADR Art 6(1)(t)? (Y/N/Partial/N/A (not subject)/Not sure)Input
LComplaint email/phone foundInput (collect)
MPasted guarantee/complaint/ADR textInput
NNotesInput
OWord-scan hintFormula
PArt 6(1)(g) complaint policy statusFormula
QArt 6(1)(d) complaint address statusFormula
RArt 6(1)(l)/(lb) legal guarantee statusFormula
SArt 6(1)(la)/(m) commercial/after-sales statusFormula
TArt 6(1)(t) ADR statusFormula
UTo-do (with article cites)Formula
VResultFormula — 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:

  1. New workbook. Rename the first sheet Shops. Create a second sheet Settings; put the label "Today" in A1 and the date 2026-11-03 (or =TODAY()) in B1.
  2. In Shops row 1 paste the column headers A–V exactly as listed in the table above.
  3. 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).
  4. 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.
  5. 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

  1. 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.)
  2. Is the complaint address given, or clearly the same as the establishment address? (F / Article 6(1)(d).)
  3. 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).)
  4. 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).
  5. For digital content / digital services: is the legal-guarantee reminder present? (I / Article 6(1)(lb).)
  6. Where the shop offers after-sale assistance, after-sales services or commercial guarantees, are existence and conditions stated? (J / Article 6(1)(m).)
  7. 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).)
  8. Take dated screenshots of product, terms, guarantee and contact pages (Article 6(9) burden of proof on the trader).

Tested: twelve made-up shops

RowScenarioV (result)
1shoes.de — full goods complaint policy, legal guarantee, ADR; no commercial durability offeredOK
2gadgets.nl — missing complaint policy, address, legal guarantee, after-sales, ADRFIX
3ebook.ie — digital with Art 6(1)(lb) + after-sales; ADR N/AOK
4stream.fr — digital missing Art 6(1)(lb) reminderFIX
5parts.at — B2B onlyOUT OF SCOPE
6bakery.be — not a distance contractOUT OF SCOPE
7lamps.be — partial answers across E–KCHECK BY HAND
8fridge.de — producer 5-year durability offered but not disclosed (H=N)FIX
9tea.it — ADR missing onlyFIX
10bike.pl — full goods + commercial durability disclosedOK
11coach.es — services with digital legal guarantee + after-sales + ADROK
12mode.fr — all Not sureCHECK 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

Related free check sheets

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

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.

← All guides

Unadhi Guides are free, independent explainers. We correct errors as soon as we find them: write to mininglife7@gmail.com.