Your daily finance table fills its cost-of-goods figures from two different sources, and the cheaper-looking one covers most of your history. Of 788 recorded days, 479 (60.8%) are tagged shopifyql_fallback, and every single one of them records $0 of Printify shipping and $0 of Printify tax. On the 302 days that do have real Printify invoices, shipping plus tax comes to $18,250 — 16.2% of revenue on those days. So on a fallback day your margin is overstated by about 16 points, and because fallback days carry 68.3% of all revenue, a plain query over the whole table reports 66.2% gross margin where the measured days report 56.1%.
Three steps, in order:
1. Stop the bleeding in the report you actually read. In G:\iris\igl-ops-sage, the weekly scorecard's queryFinancials() in reports/tuesday-scorecard/compute.js sums total_cogs over a date range with no filter on which cost source produced it. Either add AND cogs_source = 'printify_actual' there and label the card "measured days only," or make the card print the fallback-day count beside the margin so you can see when it is guessing. Do the same for every margin, contribution and breakeven query in igl-ops-sage. 2. Backfill the 25 days that are still wrong. This is not only history: 25 of the last 90 days are fallback days, worth $9,374 of revenue, the most recent being 2026-09-27 — yesterday. Two of them are real trading days (2026-08-06 with 20 orders, 2026-08-07 with 23). Run exactly this: node scripts/sync-printify-cogs.js 2026-07-02 2026-09-27. Then recompute your kill floor, because it was derived from a week that is four-sevenths fallback days. 3. Read the number the filter reveals. Over the 302 days with real invoices, contribution margin is minus $12,944 and operating income minus $22,004, against $71,100 of ad spend on $112,517 of revenue. That is a measurement, not a projection, and it is the number your planning documents do not contain.
Your ops database records cost two incompatible ways, the cheaper one dominates the history, and nothing that reads the table filters for which one it got — so every profit threshold you have borrowed or derived is set too low.
The fallback path fills cost-of-goods from Shopify's own query language, which knows what the product cost but nothing about what Printify charged to ship it or tax it. The column is therefore not missing — it is present and wrong-shaped, which is the worst kind of data defect, because every query succeeds and every answer comes back optimistic. Nothing errors. Nothing looks broken.
The sharpest part is that the database already knows. cogs_source is a real column, set per-day, and two validators (scripts/e3-validate-shopify-backfill.py, scripts/e4-validate-printify-backfill.py) already report the fallback-versus-measured mix by month. The diagnostic layer tracks the split carefully; the reporting layer ignores it completely. A grep across reports/, scripts/ and qc/ finds no consumer query that filters on it.
This is the root cause sitting underneath numbers already in use. wescale-kb/planning/igl-ads-execution-plan-2026-07-08.md is the clean instance: it calibrates IGL's whole ad economics off a cost-of-goods figure of 35.17%, sourced, by its own admission, from a single week — 2026-W26, June 29 to July 5. That week reproduces to the digit ($1,071.70 / $3,047.60 = 35.17%), and four of its seven days are fallback days carrying $0 of shipping cost. Its three real-invoice days alone carry $197.24 of shipping and tax on $1,269.44 of revenue, 15.5%, none of which appears on the other four. The plan then derives a kill floor of 1.8 from that figure. Measured over the real-invoice days, cost of goods is 43.89%, not 35.17%.
The cross-shelf part is what makes this findable. The recall-kb seed hangs a spending gate on the word profitable without defining it. wescale-kb/members/michael-jaggers.md shows what a correctly-costed print-on-demand operator's floor actually looks like — ~47% cost of goods even with the Printify discount, and a personal breakeven of 2.35, well above IGL's 1.8 — and also warns that raising price is not a free fix, since his own increase dropped total sales 38.9% while lifting average order value 18.0% from $53.69 to $63.35. And founders-kb supplies the discipline: Ford's line in episode 26 is "Waste is corrected by economy. Mismanagement is corrected by brains. Neither of these correctives has anything to do with money." IGL has been running an ad program whose measured contribution is negative while its plan says the floor is 1.8. More creative volume does not touch that. A where clause and a backfill do.
No single knowledge base could produce this, because none of them contains the cost data. The knowledge bases supply the threshold, the comparison operator and the diagnosis; only the ops database reveals that the inputs were recorded two different ways with the wrong one dominant.
recall-kb/Business/Marketing/Animated Ads in 1 Click With AI (Full Workflow) — the seed. Recall capture dated 2026-02-27, no status declared. Its spending gate turns on the word "profitable" without defining it; chasing that word is what exposed that IGL's profit inputs are recorded two incompatible ways. Thin seed, honestly: the sentence containing "profitable" is a gloss a previous night's weaver added to this file, not the source's own text.wescale-kb/planning/igl-ads-execution-plan-2026-07-08 — the one theme-aggregate. Declared a PLAN, dated 2026-07-08 (82 days old). Section 0's 35.17% cost-of-goods and the 1.8 kill floor derived from it; four of its seven source days are fallback days. Its own caveat says to recompute if the cost figure is different — this nugget is that trigger firing.wescale-kb/members/michael-jaggers — member profile. ~47% cost of goods with the Printify discount, average order value $58–63, personal breakeven 2.35 (quoted 2025-11-19), and the price-increase result (quoted 2025-11-08): total sales −38.9%, average order value +18.0%, $53.69 → $63.35.founders-kb/episodes/026-henry-ford-my-life-and-work — Founders episode 26, published 2018-05-01, on Ford's 1922 autobiography. The waste-versus-money diagnosis, and the 1906–07 price experiment: two models at $1,000/$2,000 replaced by three at $600–750, sales 1,599 → 8,423 cars.G:\iris\igl-ops-sage\data\igl.db, table fact_shopify_daily_financials, 788 day-rows spanning 2024-08-01 to 2026-09-27. Queried read-only tonight. ### Worked examples — every number, reproducible | Claim | Query result | |---|---| | Coverage by cost source | shopifyql_fallback 479 days / $242,545.40 revenue / $0 shipping / $0 tax · printify_actual 302 days / $112,517.31 / $14,498.63 / $3,751.76 · none 7 days | | Fallback share | 479 of 788 days = 60.8%; $242,545.40 of $354,998.45 = 68.3% of revenue | | Fallback rows with any shipping or tax recorded | 0 of 479 | | What the fallback omits | shipping + tax = $18,250.39 on $112,517.31 = 16.22% of revenue | | Whole-table distortion | gross margin reads 66.21% over all days vs 56.11% on measured days; cost of goods 33.77% vs 43.89% | | Still live | 25 fallback days in the last 90, $9,374.06, 2026-07-02 → 2026-09-27 | | Earliest coverage | all 153 recorded days of 2024 (data starts 2024-08-01) show $0 Printify shipping | | The plan's sample week | 2026-06-29→07-05: $1,071.70 / $3,047.60 = 35.17%; its 3 real days carry $197.24 on $1,269.44 = 15.5% | | Measured-day profitability | contribution margin −$12,944.11, operating income −$22,004.11, ad spend $71,100.24 |cogs_source audit (479 of 788 days fallback, $0 shipping, 68.3% of revenue; shipping+tax = 16.2% on measured days) → wescale-kb michael-jaggers (~47% cost of goods, breakeven 2.35, price rise cost him 38.9% of sales) → founders-kb episode 26 Ford (waste is corrected by economy, not money)igl.db is not a knowledge base and correctly did not count toward the three.