Bait advertising check sheet for EU web shops: Black Friday deals out of stock at launch, page price above the ad and bait and switch under UCPD Annex I points 5 and 6, 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 bait-advertising check sheet for EU web shops (Shopify, WooCommerce and similar), one row per advertised Black Friday deal. The product scraper fills title, price and stock at launch; you add the advertised price, expected orders and four yes/no answers, and the formulas return a price-match status (Annex I point 5; Article 6(1)(d)), an availability-at-launch status (Annex I point 5; Article 6(1)(b)), a quantity and disclosure status (Annex I point 5), a bait-and-switch flag (Annex I point 6), a proof status (Article 12), a scope note, 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 launch-morning checklist, safe ad wording and a client email. We tested the formulas in LibreOffice on thirteen made-up deals before publishing.
Short answer: a deal that sells out is not illegal. What is banned, in all circumstances, is advertising a product “at a specified price without disclosing the existence of any reasonable grounds the trader may have for believing that he will not be able to offer for supply … those products or equivalent products at that price for a period that is, and in quantities that are, reasonable having regard to the product, the scale of advertising of the product and the price offered” (UCPD Annex I point 5, “bait advertising”). If stock is short, say so in the ad. Point 6 (“bait and switch”) bans advertising at a price and then refusing to show, take orders for or deliver the item within a reasonable time, or showing a defective sample, “with the intention of promoting a different product”.
Why accountants, bookkeepers and web agencies should look at this before Black Friday
- Black Friday is 27 November 2026 (18 days from 9 November). Newsletters, homepage banners and paid ads with a deal price go out in the next two weeks; each one with a product and a price is an invitation to purchase (Article 2(i)).
- No case-by-case test. Annex I practices are unfair “in all circumstances” (Article 5(5)). The bigger the campaign, the more stock point 5 expects: it measures quantity against “the scale of advertising”.
- Proof is on the shop. Under Article 12 an authority or court can ask the trader to prove a factual claim and treat it as inaccurate if the proof is missing. Column N makes sure proof exists.
- It is a quick, billable check. Run the product scraper on launch morning, compare with the ad, and the sheet writes the fix list with Article cites. It pairs with our real-discount sheet (30-day lowest price) for the “was” price and our fake-urgency sheet (Annex I point 7) for timers and “only X left”.
Step 1: pull price and stock at launch (scraper, free during launch)
- List the product URLs behind each advertised deal and run the Shopify & WooCommerce Product + Price Tracker at the launch time of the deal. It returns products, prices, compare-at prices, stock, 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.
- Copy the title to column D, the page price to column F and the availability to column G. Where the shop exposes a stock quantity, put it in column H; otherwise ask the client for a back-office stock export at the same time.
- Take a dated screenshot of each ad (newsletter, banner, social post) showing the deal price, and copy that price into column E.
- Ask the client for last year's orders for the same or a similar deal and put the expected orders in column I. Run the scraper again a few hours later: if the product is sold out, note the hours in column K.
- The scraper does not decide whether an ad is bait. It gives you dated price and stock data; the answers in G–N are your own check.
Need client contacts to send the results? The Website Contact Scraper returns emails (MX-checked), phones and social profiles from the same shop websites, one row per site.
Step 2: the sheet, one row per advertised deal (columns A to W)
Create a tab called Deals. Row 1 holds the headers below; paste the formulas into P2 to W2 and fill down. Add a Settings tab: B1 today (=TODAY()), B2 = 2026-11-27 (Black Friday), B3 = 24 (sold-out-fast threshold in hours; our reading, change it), B4 = B2-B1 (days left). The formulas use only IF, AND, OR, NOT, LEFT, 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 | Ad or deal page URL | You |
| C | Sells to consumers? Y or N | Art 2(a)/(b), 3(1) |
| D | Product title | Product scraper |
| E | Advertised deal price (number) | Ad screenshot |
| F | Page price at launch (number) | Product scraper |
| G | Available at launch? Y, N or Not sure | Product scraper; Annex I 5; Art 6(1)(b) |
| H | Units in stock at the deal price at launch | Scraper or back office |
| I | Expected orders in the deal period (last year's data) | Client |
| J | Quantity or time limit disclosed in the ad? Y or N | Annex I 5 (“without disclosing”) |
| K | Hours until sold out (number, or blank if still in stock) | Second scraper run |
| L | Another product pushed instead (redirect, “see this one”)? Y, N or Not sure | Annex I 6 |
| M | Orders refused, cancelled or not delivered in a reasonable time? Y, N or Not sure | Annex I 6(b) |
| N | Dated proof kept? Y or N | Art 12 |
| O | Notes | You |
| P | Price-match status | Annex I 5; Art 6(1)(d) |
| Q | Availability at launch | Annex I 5; Art 6(1)(b) |
| R | Quantity and disclosure status | Annex I 5 |
| S | Bait-and-switch flag | Annex I 6 |
| T | Proof status | Art 12 |
| U | Scope note | Art 2(i), 3(1) |
| V | To-do list with Article cites | As cited |
| W | Result: OK / FIX / CHECK BY HAND / OUT OF SCOPE | Summary |
Formulas (row 2; fill down). In Excel files saved by some tools TEXTJOIN shows as _xlfn.TEXTJOIN; that is the same function.
P2: =IF(A2="","",IF(OR(NOT(ISNUMBER(E2)),NOT(ISNUMBER(F2))),"CHECK BY HAND: FILL ADVERTISED PRICE (E) AND PAGE PRICE AT LAUNCH (F)",IF(F2>E2,"FIX: PAGE PRICE AT LAUNCH IS ABOVE THE ADVERTISED PRICE - THE ITEM IS NOT OFFERED AT THAT PRICE (ANNEX I POINT 5; ART 6(1)(d))","OK: PAGE PRICE MATCHES OR BEATS THE ADVERTISED PRICE")))
Q2: =IF(A2="","",IF(G2="N","FIX: ADVERTISED DEAL NOT AVAILABLE AT LAUNCH (ANNEX I POINT 5; ART 6(1)(b) AVAILABILITY)",IF(G2="Y","OK: AVAILABLE AT LAUNCH","CHECK BY HAND: CHECK AVAILABILITY AT LAUNCH (COLUMN G)")))
R2: =IF(A2="","",IF(J2="Y","OK: QUANTITY OR TIME LIMIT DISCLOSED IN THE AD (ANNEX I POINT 5)",IF(AND(ISNUMBER(H2),ISNUMBER(I2)),IF(H2<I2,"FIX: STOCK AT THE DEAL PRICE IS BELOW EXPECTED DEMAND AND NO LIMIT IS DISCLOSED (ANNEX I POINT 5)",IF(AND(ISNUMBER(K2),K2<Settings!$B$3),"CHECK BY HAND: SOLD OUT FAST WITHOUT A DISCLOSED LIMIT - WAS THE PERIOD REASONABLE? (ANNEX I POINT 5)","OK: STOCK COVERS EXPECTED DEMAND")),"CHECK BY HAND: FILL STOCK AT DEAL PRICE (H) AND EXPECTED DEMAND (I), OR DISCLOSE A LIMIT (ANNEX I POINT 5)")))
S2: =IF(A2="","",IF(L2="Y",IF(OR(M2="Y",G2="N"),"FIX: ADVERTISED ITEM REFUSED OR NOT DELIVERED WHILE ANOTHER PRODUCT IS PUSHED - POSSIBLE BAIT AND SWITCH (ANNEX I POINT 6)","CHECK BY HAND: ANOTHER PRODUCT IS PUSHED - CHECK ORDERS AND DELIVERY FOR THE ADVERTISED ITEM (ANNEX I POINT 6)"),IF(OR(L2="Not sure",M2="Not sure"),"CHECK BY HAND: ANSWER COLUMNS L AND M (ANNEX I POINT 6)",IF(M2="Y","CHECK BY HAND: ORDERS REFUSED OR LATE - FIX THE ORDER/DELIVERY PROBLEM (ANNEX I POINT 6(b); ART 6(1)(b))","OK: NO SWITCH SIGNS"))))
T2: =IF(A2="","",IF(N2="Y","OK: PROOF KEPT","KEEP PROOF: DATED AD SCREENSHOT + STOCK EXPORT AT LAUNCH + PRICE SNAPSHOT (ART 12)"))
U2: =IF(A2="","",IF(C2="N","OUT OF SCOPE: B2B ONLY - UCPD COVERS BUSINESS-TO-CONSUMER PRACTICES (ART 3(1))",IF(C2<>"Y","CHECK BY HAND: FILL COLUMN C (SELLS TO CONSUMERS?)","IN SCOPE: B2C INVITATION TO PURCHASE AT A STATED PRICE (ART 2(i))")))
V2: =IF(A2="","",IF(C2="N","",_xlfn.TEXTJOIN("; ",TRUE,IF(LEFT(P2,3)="FIX","Set the page price to the advertised price or correct the ad (Annex I point 5; Art 6(1)(d))",""),IF(LEFT(Q2,3)="FIX","Restock or pull the ad for the unavailable deal (Annex I point 5; Art 6(1)(b))",""),IF(LEFT(R2,3)="FIX","Add stock at the deal price or state the limit in the ad, e.g. only 50 units at this price (Annex I point 5)",""),IF(LEFT(S2,3)="FIX","Take and deliver orders for the advertised item; stop redirecting to another product (Annex I point 6)",""),IF(LEFT(T2,4)="KEEP","Keep dated proof (Art 12)",""),IF(OR(LEFT(P2,5)="CHECK",LEFT(Q2,5)="CHECK",LEFT(R2,5)="CHECK",LEFT(S2,5)="CHECK",LEFT(U2,5)="CHECK"),"Answer the CHECK BY HAND columns",""))))
W2: =IF(A2="","",IF(C2="N","OUT OF SCOPE",IF(OR(LEFT(P2,3)="FIX",LEFT(Q2,3)="FIX",LEFT(R2,3)="FIX",LEFT(S2,3)="FIX"),"FIX",IF(OR(LEFT(P2,5)="CHECK",LEFT(Q2,5)="CHECK",LEFT(R2,5)="CHECK",LEFT(S2,5)="CHECK",LEFT(U2,5)="CHECK"),"CHECK BY HAND","OK"))))
Launch-morning checklist (per advertised deal)
- Is the shop selling to consumers? B2B-only shops are outside the UCPD (Article 3(1)) — column C.
- Does every ad with a product and a deal price lead to a page with that price or lower? (Annex I point 5 “at that price”; Article 6(1)(d)) — columns E–F.
- Is the product in stock at launch? An advertised deal that is sold out the moment it goes live is the classic bait ad — column G.
- Does stock at the deal price cover the orders the client expects, given how widely the deal is advertised? If not, does the ad say “only [n] units at this price”? — columns H–J.
- If the deal sells out within hours and no limit was stated, look again at how much stock there was (column K).
- Is the sold-out page pushing a different, dearer product while orders for the advertised one are refused or not delivered? That is the point 6 pattern — columns L–M.
- Keep the dated ad screenshot, the stock export at launch and the scraper price snapshot (Article 12) — column N.
Tested: thirteen made-up deals (LibreOffice)
| Row | Deal (made-up shop) | W (result) |
|---|---|---|
| 1 | shoe.de — EUR 59 ad, page EUR 59, 400 in stock for 300 expected orders | OK |
| 2 | lamp.nl — EUR 39 ad, page shows EUR 49 | FIX |
| 3 | bag.fr — advertised deal sold out at launch, no limit stated | FIX |
| 4 | mug.it — 50 units for 500 expected, but “only 50 at this price” in the ad | OK |
| 5 | coat.at — 20 units for 300 expected, no limit stated | FIX |
| 6 | tea.be — no stock or demand numbers yet | CHECK BY HAND |
| 7 | ring.es — sold out at launch, page pushes a dearer ring, orders refused | FIX |
| 8 | sofa.ie — page price EUR 449 beats the EUR 499 ad, enough stock | OK |
| 9 | bolt.pl — B2B-only trade shop | OUT OF SCOPE |
| 10 | cap.fi — availability at launch not sure | CHECK BY HAND |
| 11 | toy.se — enough stock on paper but sold out in 3 hours, no limit stated | CHECK BY HAND |
| 12 | pan.pt — in stock, but an upsell product is pushed on the page | CHECK BY HAND |
| 13 | cup.lu — column C (sells to consumers?) left blank | CHECK BY HAND |
All thirteen gave the intended result in LibreOffice (xlsx → ods → csv), with 0 errors; an empty row stays blank; Settings!B4 gave 18 days to Black Friday from 9 November 2026. Rebuild the workbook from the formulas above.
Safe ad wording
Black Friday: [product] for EUR [price] (was EUR [30-day lowest price]). Only [n] units at this price, from [day date, time, time zone] until [day date, time, time zone] or until sold out.
Avoid: advertising a deal price for a product you will not have in stock at launch; leaving a sold-out deal in paid ads and newsletters; sending buyers of the advertised item to a different, dearer product while their orders are refused.
Copy-ready client email
Subject: Black Friday ads on [shop] - quick EU bait-advertising check Hello [name], Before Black Friday (27 November) we compared your deal ads with the price and stock on your product pages. Under the EU Unfair Commercial Practices Directive, advertising a product at a price without saying that you may not have enough stock at that price is banned in all circumstances (Annex I point 5, "bait advertising"), as is refusing or not delivering the advertised item while pushing another one (point 6). An authority can ask you to prove your claims (Article 12). What we found: [paste column V] If you agree, we will add "only [n] units at this price" to the ads where stock is short and keep dated screenshots and stock exports. [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 (9 Nov 2026, from saved official EUR-Lex text; live EUR-Lex returned an empty body today): consolidated UCPD 02005L0029-20220528 Articles 2(i), 3(1), 5(5), 6(1), 7(4), 12 and Annex I points 5, 6, 7 and 18; Commission Guidance 2021/C 526/01 section 2.9.5 (invitations to purchase; advertised prices that do not exist and points 5 and 6), section 4.2.1 (online intermediaries promoting products that are not actually available), section 4.2.7 (bait and switch as a dark pattern) and section 4.3.4 (advertised prices must be available in reasonable quantities having regard to the scale of the advertising). Product scraper and contact scraper descriptions read on the Apify API today.
Not read for this guide: the 27 September 2026 consolidated UCPD version as a whole; national transposition laws and fines; Court of Justice judgments on Annex I points 5 and 6; national authority guidance on stock levels; the proposed Digital Fairness Act (not adopted law).
Our reading, not the law's words: using “expected orders from last year's data” as the measure of a reasonable quantity; treating stock below expected demand with no disclosed limit as FIX; the 24-hour sold-out-fast threshold; treating a page price above the advertised price as FIX under point 5; treating a pushed alternative plus refused or undelivered orders as a possible bait and switch (point 6 also needs intention, which the sheet cannot prove); mapping Not sure and blanks to CHECK BY HAND; and the sample wording.
Related free check sheets
- Fake urgency check sheet (countdown timers, only-X-left; UCPD Annex I point 7)
- Black Friday real-discount check sheet (30-day lowest price snapshots)
- EU 30-day lowest price log for Shopify / WooCommerce
- Total price, additional charges and personalised pricing check sheet
- Delivery arrangements and 30-day delivery check sheet
- Consumer reviews check sheet (UCPD Art 7(6), Annex I 23b/23c)
Frequently asked questions
Is it illegal to advertise a Black Friday deal that sells out?
Not as such. Selling out is fine. UCPD Annex I point 5 bans, in all circumstances, making an invitation to purchase products at a specified price without disclosing any reasonable grounds the trader may have for believing that it will not be able to supply those products, or equivalent products, at that price for a period and in quantities that are reasonable having regard to the product, the scale of advertising and the price offered. If the shop expects to run short, it must say so in the ad.
How do we disclose a limited quantity?
Say it in the ad itself, for example 'only 50 units at this price' or 'deal price while stock lasts, 50 units'. Point 5 is about not disclosing; a clear limit in the invitation to purchase removes the point 5 problem. The limit must itself be true: a false 'only 50 left' claim is a different problem under Annex I point 7 and Article 6(1)(b).
What is bait and switch?
UCPD Annex I point 6: making an invitation to purchase at a specified price and then refusing to show the advertised item, refusing to take orders for it or deliver it within a reasonable time, or demonstrating a defective sample of it, with the intention of promoting a different product. The sheet flags rows where another product is pushed while the advertised one is refused or not available.
Does a newsletter or Instagram post count as an invitation to purchase?
It can. Article 2(i) UCPD defines an invitation to purchase as a commercial communication which indicates characteristics of the product and the price in a way appropriate to the means used and thereby enables the consumer to make a purchase. The Commission Guidance (2021/C 526/01, section 2.9.5) says it does not need to include an actual way to buy, and that a radio advert with a product's characteristics and price is an invitation to purchase.
What if the product page shows a higher price than the advert?
Then the product is not offered 'at that price', which is the point 5 test, and false information on the price is a misleading action under Article 6(1)(d). The Commission Guidance (section 2.9.5) says advertising prices that do not exist could also breach points 5 and 6 of Annex I.
Why keep proof?
Article 12 UCPD lets courts and authorities require the trader to furnish evidence as to the accuracy of factual claims and to consider the claims inaccurate if the evidence is missing or insufficient. A dated screenshot of the ad, a stock export at launch and a price snapshot from the product scraper are simple proof.
Unadhi Guides are free, independent explainers. We correct errors as soon as we find them: write to mininglife7@gmail.com.