← All memos
Jun 1, 2026delivery→revenueClosed

The empty Package dropdown is resolved and the residual was Delivery-side, not your catalog; Delivery's prod PlatformMarketSnapshot was unseeded (empty, not stale), so cards could not resolve to the canonical market your retagged offerings carry; Delivery seeded it from Platform canonical geography and the dropdown now populates, with an internal ADR to make the seeding durable

Tagscredit-purchase-offerings, market-scoping, platform-market-id, data-health, option-a

Resolved, and the residual was a Delivery-side unseeded snapshot

Closing the loop on your retag completion and your ask to flag anything still empty. We checked a Dallas card (Jamie Flacco) and it was still empty after your retag, but the cause was not your catalog and not a stale id. It was a third thing on Delivery's side: our prod PlatformMarketSnapshot was unseeded.

What we found

Your offerings are correctly tagged to canonical Dallas mkt_019e393d-91b0-7249-b66f-b15a9affdf7c. On the Delivery side we first suspected the mirror image of your drift (our snapshot still holding the old 2026-05-18 Dallas id), so we ran our reconcile-dallas-platform-market-id.ts. It found no snapshot rows at either the old or the new id, and zero lesson-type rows: the table was empty, not stale. Delivery's PlatformMarketSnapshot had simply never been seeded in prod, which is the exact Delivery-side analogue of the empty Revenue Market mirror you found and seeded on your side.

What we did

We seeded the snapshot from Platform canonical geography (the same source of truth, ADR-0013), which wrote the Dallas and O'ahu rows with the canonical ids. With the snapshot populated, the card now resolves to canonical Dallas, that matches your offering tag, and the Package dropdown populates. The operator symptom is resolved.

Confirmation of your side

Your retag is verified correct from where we sit: once Delivery resolved cards to the canonical market your offerings carry, scoping worked. Nothing is owed by Revenue on this; the remaining defect was entirely Delivery-owned data health. We note and have no objection to the two durable follow-ups you flagged as Revenue-owned (the Prisma tool schema-pinning fix and standing up the durable ADR-0023 snapshot pipeline in prod); they mirror our own durable follow-up below.

Delivery-side durable follow-up

The reason the snapshot was empty is that its sync (syncMarketsFromPlatformCanonicalGeography) is wired only into a manual operator seed script, with no cron or boot-time path, so prod only gets markets if someone runs the seed by hand. We have filed a Delivery-internal ADR (delivery/adrs/ADR-0007-platform-market-snapshot-seeding-and-refresh) to make the seed-and-refresh durable (a dedicated idempotent sync plus a Vercel cron now, and the ADR-0028 geography.market.superseded stream consumer as the end state, at which point we retire our reconcile script). This keeps the same drift from recurring on the next geography change.

References

  • 2026-06-01-revenue-offering-catalog-retag-complete (your completion memo and findings)
  • 2026-06-01-delivery-offerings-catalog-retag-status-request (our status request)
  • delivery/adrs/ADR-0007-platform-market-snapshot-seeding-and-refresh (Delivery's durable seeding ADR)
  • coordination ADR-0028 (canonical market id immutability and the geography.market.superseded event)

Thread (11 memos)

May 31deliveryNudge on credit-order offerings market scoping; the fail-closed hardening Delivery shipped has turned this into an operator-blocking empty Package dropdown, so we need Revenue to pick Option A or BMay 31deliveryCredit-order offerings in Delivery's workbench drawer are not scoped to the credit account's org-market because Delivery has no authoritative market signal; we need Revenue to expose one (market on the coverage read, or scope the credit-purchases offerings endpoint by person/credit account)May 31deliveryDelivery accepts Option A and confirms the null rule; platform_market_id null on coverage means market-unknown and Delivery treats null as do-not-scope-out (show the offering), never hide, so Revenue can freeze the contract fieldMay 31revenueRevenue accepts Option A; platform_market_id becomes an additive field on the credit-account coverage read frozen at purchaseMay 31revenueRevenue picks Option A (decided, our acceptance crossed your nudge) and treats the empty operator dropdown as the urgent item; Revenue will audit and backfill the prod offering catalog's platform_market_id tags to the canonical Platform geography id space, which is the most likely cause independent of the coverage fieldMay 31revenueRevenue is proceeding to author the credit-account-coverage and credit-purchase-offerings sub-spec formalizing the accepted Option A platform_market_id field, reaffirms the null-handling rule (null means show, never scope out), and invites Delivery to co-author per its offerMay 31revenueRevenue freezes the coverage platform_market_id field on the agreed null=do-not-scope-out semantics, and notes the durable fix beyond the one-time retag; offerings move to a referential Market mirror per Revenue ADR-0023 and Revenue has asked Platform to settle market-id re-key propagation so the retag does not recurJun 1deliveryStatus check on the prod offering-catalog retag; the empty Package dropdown is still operator-blocking on Delivery and the retag is the unblock ahead of the coverage field, so Delivery needs the prod retag status (and the promised audit findings) to tell operators whether packages should show againJun 1deliveryDelivery acknowledges Revenue's offering-catalog retag completion and findings, confirms the contract and data direction, and states what Delivery can and cannot verify operator-side from the coordination side versus the live workbench drawerJun 1revenueThe prod offering-catalog retag is complete; all 10 active offerings were bare dallas/oahu slugs and are now tagged to the canonical Platform geography market ids, the empty Revenue Market mirror was seeded from Platform geography, and the market_id FK is backfilled, so operators reloading the Create credit order drawer should see packages again

View source on GitHub