Unadhi Guides

EUDR check sheet for EU web shops selling coffee, chocolate, wooden furniture, paper and rubber goods: trader records under Article 5, the due diligence statement reference number and the 30 December 2026 date under Deforestation Regulation (EU) 2023/1115 as amended in 2025 and 2026, for accountants, bookkeepers and web agencies

Updated 10 Nov 2026 · Disclosure: the Apify Actors mentioned below are built and published by Unadhi. Legal facts come from the official EUR-Lex texts we read today: Regulation (EU) 2023/1115 on deforestation-free products (consolidated version of 18.9.2026), the amending Regulation (EU) 2025/2650 (OJ 23.12.2025), Commission Delegated Regulation (EU) 2026/2102 (OJ 17.9.2026) and Directive 2013/34/EU Article 3 with Delegated Directive (EU) 2023/2775 for the company sizes. We did not read national laws, Commission guidance or the information system manuals. This guide is for information only, not legal advice.

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 EUDR check sheet for EU web shops, one row per product line made with cocoa, coffee, oil palm, rubber, soya, wood or cattle. You fill short answers from the shop's product list and purchase files, and the formulas return a scope note (Annex I), the shop's role (trader, downstream operator or operator), the date that applies with the days left (30 December 2026, 30 June 2027 or 30 December 2027), a records or due diligence status that names each missing item (Articles 4 and 5), the registration status for large shops (Article 5(2)), a to-do list with the Article behind each line and a result (OK, PREPARE BY [date], FIX, CHECK BY HAND or OUT OF SCOPE). Also included: a supplier request template and a client email. We tested the formulas in LibreOffice on fourteen made-up product lines, at two dates, before publishing.

Short answer: the main obligations of Regulation (EU) 2023/1115 apply from 30 December 2026 (Article 38(2), as replaced by Regulation (EU) 2025/2650), 50 days from 10 November 2026. A web shop that buys covered products from an EU supplier is a trader: it may sell them “only if” it holds the supplier's name, postal address, email and, where the supplier is the operator, “the reference numbers of the due diligence statements” (Article 5(1) and 5(3)(a)), and keeps them for at least five years (Article 5(4)). A shop that imports, or buys from a seller outside the EU, is the operator (Article 7) and must submit a due diligence statement before selling (Article 4(2)).

Why accountants, bookkeepers and web agencies should look at this now

Step 1: find the covered product lines (scraper, free during launch)

  1. Run the Shopify & WooCommerce Product + Price Tracker on each client shop. It returns products, prices, variants and SKU/GTIN from independent Shopify, WooCommerce and schema.org shops, and skips shops whose robots.txt or terms forbid scraping. You pay only your own Apify usage costs.
  2. Filter the titles for words like coffee, Kaffee, café, espresso, cocoa, chocolate, Schokolade, wood, oak, teak, Holz, furniture, paper, notebook, charcoal, tyre, rubber, gloves, palm, soy. Copy each match to columns B and C.
  3. The scraper does not know the CN code or the supplier. Check each line against Annex I (the table below gives common shop items) and fill columns D to P from the purchase invoices and accounts.
  4. Need the suppliers' or shop owners' contacts to send the request below? The Website Contact Scraper returns emails (MX-checked), phones and social profiles from their websites, one de-duplicated row per site.

Common web-shop items in Annex I (as amended to 18 September 2026)

ItemAnnex I entryStatus
Coffee beans, roasted or ground coffee0901Listed
Instant (soluble) coffee2101 11 00Listed from 30 Dec 2027
Chocolate and food preparations containing cocoa; cocoa powder; cocoa butter1806; 1805; 1804Listed
Soap made using oil palm (bars; other forms)ex 3401 11 00; ex 3401 20Listed from 30 Dec 2027
Palm oil; soya-bean oilex 1511; 1507Listed
New tyres; inner tubes; rubber gloves and clothing (natural rubber)ex 4011; ex 4013; ex 4015Listed (4015: not used or second-hand)
Wooden kitchenware, frames, ornaments, other wood articles; firewood, charcoalex 4419; ex 4414; ex 4420; ex 4421; ex 4401; ex 4402Listed (most: not used or second-hand)
Paper and paperboard articles, e.g. notebooksex 48Listed (not recovered paper, not packing for another product)
Wooden furniture; wooden seatsex 9403 30–60, 91; ex 9401 31, 41, 61, 69, 80, 91 90Listed (not used or second-hand)
Printed booksex 49Not listed (deleted by Regulation (EU) 2025/2650)
Cattle leatherex 4101, 4104, 4107Not listed (deleted by Delegated Regulation (EU) 2026/2102)
Bamboo and rattan productsTable note 4Not listed

Annex I works by CN code. When the code of a product is not in the table, it is not covered. When in doubt, enter Not sure and ask the supplier for the CN code.

Step 2: the sheet, one row per product line (columns A to X)

Create a tab called Products. Row 1 holds the headers below; paste the formulas into R2 to X2 and fill down. Add a Settings tab: B1 today (=TODAY()), B2 = 2026-12-30, B3 = 2027-06-30, B4 = 2027-12-30, B5 = B2-B1, B6 = B3-B1, B7 = B4-B1 (days left). Type the answers exactly as shown. The formulas use only IF, AND, OR, LEFT, UPPER, ISNUMBER, SEARCH and TEXTJOIN (Excel 2019 or later, Microsoft 365, Google Sheets, LibreOffice). The binary .xlsx is kept in our working copy only (we publish text files); rebuild it from the formulas below.

ColWhat goes in itBased on
AShop websiteYou
BProduct page URLProduct scraper
CProduct titleProduct scraper
DCommodity: Cocoa, Coffee, Oil palm, Rubber, Soya, Wood, Cattle or NoneArt 1(1), 2(1)
EAnnex I: Listed, Listed from 30 Dec 2027, Not listed or Not sureAnnex I
FUsed, second-hand or made only from waste? Y/NAnnex I notes
GWhere the shop gets it: EU supplier, Made from EU products, Imports or non-EU seller or Not sureArt 2(15), (15b), (17), Art 7
HShop size: Micro, Small, Medium or LargeArt 2(30); Dir 2013/34/EU Art 3
IEstablished as micro or small by 31 Dec 2024? Y/N (operators only)Art 38(3)
JWood product in the Annex to Regulation (EU) No 995/2010? Y/N/Not sure (micro or small wood operators only)Art 38(3)
KSupplier name, trade name, postal address and email (and web address, if any) on file? Y/NArt 5(3)(a)
LStatement reference number or declaration identifier on file? Y, N or Supplier is not an operatorArt 4(7), 5(3)(a)
MBusiness buyers' name, address and email on file? Y, N or Consumers onlyArt 5(3)(b)
NRecords kept at least 5 years? Y/NArt 5(4)
ORegistered in the EU information system? Y/N (large shops only)Art 5(2), 33
PDue diligence done and statement submitted before selling? Y/N (operators only)Art 4(1)–(2), 8
QNotesYou
RScope noteArt 1, 2(2), Annex I
SRoleArt 2, 7
TDate that applies, with days leftArt 38(2)–(3); Del Reg 2026/2102
URecords (traders, downstream operators) or due diligence (operators), naming each missing itemArt 4, 5
VRegistration statusArt 5(2)
WTo-do list with Article citesAs cited
XResultSummary

Size test (Directive 2013/34/EU, Article 3, amounts as amended by Delegated Directive (EU) 2023/2775): an undertaking is micro if on its balance sheet date it does not exceed two of: balance sheet total EUR 450,000, net turnover EUR 900,000, 10 employees on average; small: EUR 5,000,000, EUR 10,000,000, 50 employees (Member States may raise the money limits to EUR 7,500,000 and EUR 15,000,000); medium: EUR 25,000,000, EUR 50,000,000, 250 employees. Anything bigger is large, so not an SME.

Formulas (row 2; fill down). In Excel files saved by some tools TEXTJOIN shows as _xlfn.TEXTJOIN; that is the same function.

R2: =IF(A2="","",IF(OR(D2="None",E2="Not listed"),"OUT OF SCOPE: NOT IN ANNEX I TO REGULATION (EU) 2023/1115 - KEEP A NOTE OF THE CN CODE",IF(AND(D2<>"Cocoa",D2<>"Coffee",D2<>"Oil palm",D2<>"Rubber",D2<>"Soya",D2<>"Wood",D2<>"Cattle"),"CHECK BY HAND: FILL COLUMN D (COCOA / COFFEE / OIL PALM / RUBBER / SOYA / WOOD / CATTLE / NONE)",IF(AND(E2<>"Listed",E2<>"Listed from 30 Dec 2027"),"CHECK BY HAND: FIND THE CN CODE AND CHECK ANNEX I, THEN FILL COLUMN E",IF(F2="Y","CHECK BY HAND: USED, SECOND-HAND OR MADE ONLY FROM WASTE - MANY ANNEX I ENTRIES EXCLUDE THESE; CHECK THE ENTRY",IF(F2<>"N","CHECK BY HAND: FILL COLUMN F","IN SCOPE: "&UPPER(D2)&" PRODUCT LISTED IN ANNEX I (ART 1(1), 2(2))"))))))
S2: =IF(OR(A2="",LEFT(R2,8)<>"IN SCOPE"),"",IF(G2="EU supplier","TRADER (ART 2(17)): RECORDS UNDER ART 5",IF(G2="Made from EU products","DOWNSTREAM OPERATOR (ART 2(15b)): RECORDS UNDER ART 5",IF(G2="Imports or non-EU seller","OPERATOR (ART 2(15), ART 7): DUE DILIGENCE AND STATEMENT BEFORE SELLING (ART 4)","CHECK BY HAND: FILL COLUMN G (WHERE DOES THE SHOP GET THE PRODUCT?)"))))
T2: =IF(OR(A2="",LEFT(R2,8)<>"IN SCOPE",LEFT(S2,5)="CHECK"),"",IF(E2="Listed from 30 Dec 2027","30 DEC 2027 ("&Settings!$B$7&" DAYS LEFT) - ENTRY ADDED BY DELEGATED REGULATION (EU) 2026/2102",IF(LEFT(S2,8)<>"OPERATOR","30 DEC 2026 ("&Settings!$B$5&" DAYS LEFT) - ART 38(2)",IF(AND(H2<>"Micro",H2<>"Small",H2<>"Medium",H2<>"Large"),"CHECK BY HAND: FILL COLUMN H (SIZE)",IF(OR(H2="Medium",H2="Large",I2="N"),"30 DEC 2026 ("&Settings!$B$5&" DAYS LEFT) - ART 38(2)",IF(I2<>"Y","CHECK BY HAND: FILL COLUMN I",IF(D2<>"Wood","30 JUN 2027 ("&Settings!$B$6&" DAYS LEFT) - MICRO OR SMALL OPERATOR ESTABLISHED BY 31 DEC 2024 (ART 38(3))",IF(J2="N","30 JUN 2027 ("&Settings!$B$6&" DAYS LEFT) - MICRO OR SMALL OPERATOR ESTABLISHED BY 31 DEC 2024 (ART 38(3))",IF(J2="Y","30 DEC 2026 ("&Settings!$B$5&" DAYS LEFT) - WOOD PRODUCT UNDER THE OLD TIMBER REGULATION: NO DEFERRAL (ART 38(3))","CHECK BY HAND: FILL COLUMN J (WAS THE PRODUCT IN THE ANNEX TO REGULATION (EU) NO 995/2010?)")))))))))
U2: =IF(OR(A2="",LEFT(R2,8)<>"IN SCOPE",LEFT(S2,5)="CHECK"),"",IF(LEFT(S2,8)="OPERATOR",IF(P2="Y","OK: DUE DILIGENCE DONE AND STATEMENT SUBMITTED BEFORE SELLING - KEEP 5 YEARS (ART 4(1)-(3))",IF(P2="N","MISSING - DUE DILIGENCE (ART 8-11) AND A DUE DILIGENCE STATEMENT IN THE EU INFORMATION SYSTEM BEFORE SELLING (ART 4(2), ANNEX II)","CHECK BY HAND: FILL COLUMN P")),IF(OR(K2="",N2="",AND(L2<>"Y",L2<>"N",L2<>"Supplier is not an operator"),AND(M2<>"Y",M2<>"N",M2<>"Consumers only")),"CHECK BY HAND: FILL COLUMNS K TO N",IF(AND(K2="Y",L2<>"N",M2<>"N",N2="Y"),"OK: SUPPLIER AND BUSINESS BUYER RECORDS KEPT (ART 5(1), 5(3)-(4))","MISSING -"&IF(K2<>"Y"," SUPPLIER NAME, ADDRESS AND EMAIL (ART 5(3)(a));","")&IF(L2="N"," STATEMENT REFERENCE NUMBER FROM THE SUPPLIER (ART 4(7), 5(3)(a));","")&IF(M2="N"," BUSINESS BUYERS' NAME, ADDRESS AND EMAIL (ART 5(3)(b));","")&IF(N2<>"Y"," 5-YEAR RECORD KEEPING (ART 5(4));","")))))
V2: =IF(OR(A2="",LEFT(R2,8)<>"IN SCOPE",LEFT(S2,5)="CHECK"),"",IF(LEFT(S2,8)="OPERATOR","NOT APPLICABLE: OPERATORS SUBMIT DUE DILIGENCE STATEMENTS (ART 4(2))",IF(OR(H2="Micro",H2="Small",H2="Medium"),"NOT REQUIRED: SME (ART 2(30), 5(2))",IF(H2="Large",IF(O2="Y","OK: REGISTERED IN THE EU INFORMATION SYSTEM (ART 5(2))",IF(O2="N","MISSING - REGISTRATION IN THE EU INFORMATION SYSTEM BEFORE SELLING (ART 5(2), 33)","CHECK BY HAND: FILL COLUMN O")),"CHECK BY HAND: FILL COLUMN H (SIZE)"))))
W2: =IF(OR(A2="",LEFT(R2,8)<>"IN SCOPE"),"",TEXTJOIN("; ",TRUE,IF(ISNUMBER(SEARCH("SUPPLIER NAME",U2)),"Ask each supplier for name, trade name or mark, postal address, email and web address (Art 5(3)(a))",""),IF(ISNUMBER(SEARCH("REFERENCE NUMBER FROM",U2)),"Get the due diligence statement reference number or declaration identifier from the supplier (Art 4(7), 5(3)(a))",""),IF(ISNUMBER(SEARCH("BUSINESS BUYERS' NAME",U2)),"Record business buyers' name, address and email; consumers are not listed (Art 5(3)(b))",""),IF(ISNUMBER(SEARCH("5-YEAR",U2)),"Keep these records for at least 5 years (Art 5(4))",""),IF(ISNUMBER(SEARCH("ART 8-11",U2)),"Collect the Article 9 information, assess and mitigate risk, then submit the statement before selling (Art 4, 8-11)",""),IF(LEFT(S2,8)="OPERATOR","Give the statement reference number to business buyers (Art 4(7))",""),IF(LEFT(V2,7)="MISSING","Register in the EU information system before selling (Art 5(2))",""),IF(AND(H2="Large",LEFT(S2,8)<>"OPERATOR",LEFT(S2,5)<>"CHECK"),"On a substantiated concern, check due diligence was done before selling (Art 5(6))",""),IF(OR(LEFT(S2,5)="CHECK",LEFT(T2,5)="CHECK",LEFT(U2,5)="CHECK",LEFT(V2,5)="CHECK"),"Answer the CHECK BY HAND columns",""),"If you learn of a risk, tell the authorities and business buyers at once (Art 4(5), 5(5))"))
X2: =IF(A2="","",IF(LEFT(R2,3)="OUT","OUT OF SCOPE",IF(OR(LEFT(R2,5)="CHECK",LEFT(S2,5)="CHECK",LEFT(T2,5)="CHECK",LEFT(U2,5)="CHECK",LEFT(V2,5)="CHECK"),"CHECK BY HAND",IF(OR(LEFT(U2,7)="MISSING",LEFT(V2,7)="MISSING"),IF(IF(LEFT(T2,11)="30 DEC 2026",Settings!$B$5,IF(LEFT(T2,11)="30 JUN 2027",Settings!$B$6,Settings!$B$7))>0,"PREPARE BY "&LEFT(T2,11),"FIX"),"OK"))))

What we tested

Fourteen made-up product lines in LibreOffice (xlsx → ods → csv), first with today fixed at 10 Nov 2026 (50 days to 30 Dec 2026), then at 5 Jan 2027: a small shop's chocolate from an EU wholesaler with all records (OK); a micro shop's coffee beans with nothing on file (PREPARE BY 30 DEC 2026, then FIX); instant coffee without the reference number (PREPARE BY 30 DEC 2027 at both dates); a small importer of oak chairs established before 2025 (PREPARE BY 30 JUN 2027); a micro importer of teak tables that were under the old Timber Regulation (PREPARE BY 30 DEC 2026, then FIX); a large shop selling rubber gloves that is not registered (PREPARE, then FIX, Article 5(2)); a ceramic mug and a bamboo board (OUT OF SCOPE); a second-hand wooden chair (CHECK BY HAND); a medium shop's own palm oil soap with records (OK, 30 Dec 2027); a medium importer of notebooks with its statement filed (OK); and three half-filled rows (CHECK BY HAND). 14/14 gave the intended result at both dates, the empty row stayed blank, and no cell showed an error.

Supplier request (template)

Subject: EU Deforestation Regulation: details we need before 30 December 2026

Hello,

From 30 December 2026 we may sell the products below only if we hold
these details (Regulation (EU) 2023/1115, Article 5(3)(a)):

1. Your name, registered trade name or trade mark, postal address,
   email address and web address.
2. If you placed the products on the EU market yourself (you are the
   operator): the reference number of the due diligence statement for
   each product or delivery (Article 4(7)).
3. If you bought them from someone else in the EU: please confirm this.
4. The CN code of each product.

Products: [list with SKU]

Thank you,
[Name], [Shop]

Client email

Subject: Your web shop and the EU Deforestation Regulation from 30 December 2026

Hello,

We checked [number] product lines in your shop against Regulation
(EU) 2023/1115:

- [number] lines are covered (coffee, chocolate, wood, paper, rubber ...)
- Your role: [trader / operator for imported lines]
- [number] lines lack supplier details or the statement reference number
  (Article 5(3)); from 30 December 2026 they may not be sold without them
- [Registration needed in the EU information system: yes/no (Article 5(2))]
- [Imported lines: due diligence statement needed by 30 Dec 2026 / 30 Jun 2027]

The attached sheet lists each line and the fix. We prepared a request
you can send to your suppliers.

Best regards,
[Name]

Limits and our reading

FAQ

When does the EU Deforestation Regulation apply to web shops?

From 30 December 2026. Regulation (EU) 2025/2650 replaced Article 38: Articles 3 to 13, 16 to 24, 26, 31 and 32 of Regulation (EU) 2023/1115 apply from 30 December 2026 (Article 38(2)). Operators that are natural persons or micro or small undertakings established as such by 31 December 2024 get 30 June 2027, except for products covered by the Annex to the old Timber Regulation (EU) No 995/2010 (Article 38(3)).

Is a web shop that buys chocolate or coffee from an EU wholesaler an operator?

Usually not. A shop that only makes products available that someone else first placed on the EU market is a trader (Article 2(17)). Since the 2025 amendment, traders do not file due diligence statements. They must hold supplier and business buyer details before selling (Article 5(1) and (3)), keep them for at least five years (Article 5(4)) and, if they are not SMEs, register in the EU information system (Article 5(2)).

When is the web shop the operator?

When it is the first to make the product available on the EU market, for example by importing it, or by buying from a seller established outside the EU that places it on the EU market: Article 7 deems the first person established in the Union who makes such products available to be the operator. Operators must exercise due diligence (Articles 8 to 11) and submit a due diligence statement before selling (Article 4(2)).

Which shop products are covered?

Only products listed in Annex I that contain or are made using cattle, cocoa, coffee, oil palm, rubber, soya or wood, for example coffee (0901), chocolate (1806), cocoa powder (1805), new tyres (4011), rubber gloves (4015), many wood articles (4401 to 4421), paper and paperboard articles (ex 48) and wooden furniture (ex 9403). Bamboo and rattan products, many used or second-hand products and printed books (deleted by Regulation (EU) 2025/2650) are out.

What changed in September 2026?

Delegated Regulation (EU) 2026/2102 (OJ 17.9.2026) amended Annex I. It adds, from 30 December 2027, instant coffee (2101 11 00), soaps made using oil palm (3401 11 00, 3401 20) and several palm oil chemicals, and frozen cattle tongues. It removes cattle hides and leather (4101, 4104, 4107), rubber belts (4010) and other vulcanised rubber articles (4016), and clarifies that packing used to carry another product and used or second-hand products under many entries are not covered.

Does the scraper check deforestation compliance?

No. The product scraper lists products, titles and prices from a shop so you can find the covered lines quickly. Supplier records, statement reference numbers and the company size come from the client's purchase files and accounts.

Sources (read 10 Nov 2026 on EUR-Lex)

Related

← All guides

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