P1 — Shopify webhook is failing in production (missing web_entitlements / webhook_deliveries tables)
A working diagnosis of this problem and the sequence that actually resolves it, written from the operational side rather than the marketing side.
Reported context: Recorded separately per founder directive. **Not to be fixed in the TestFlight release lane.** ## What is broken The Shopify webhook path writes to two tables that do not exist in the production database: - `aforce_web_entitlements` - `aforce_webhook_deliveries` Unlike the Stripe rail — where the ledger insert happens *after* `res.status(200)` has already acked and sits in a non-fatal try/catch — the Shopify handler
What is actually going on
Checkout failures are usually caused by a carrier rate mismatch, a conflicting discount script, or a payment gateway that does not support the buyer's currency or region.
Cart recovery leaks happen when the recovery email fires before the buyer's session expires, or when the discount code in the email has already expired by the time it is opened.
The sequence that works
Reproduce the failure in a clean browser with a real destination address and a real payment method in test mode. Log the exact gateway response code.
Disable all discount scripts, then re-enable one at a time to isolate the conflict.
Rebuild cart recovery timing: first touch at 1 hour, second at 24 hours, third at 72 hours with a freshly minted code, each with a distinct message angle.
Audit every app for where it injects assets. Move non-critical scripts to deferred loading and remove apps that duplicate native functionality.
Measure again with field data, not lab data — lab scores on fast hardware hide the real mobile experience.
Where people lose time
Installing another app to fix a problem created by too many apps. Each addition raises the blocking cost.
Testing checkout only with a domestic card and a domestic address, then discovering the failure only from foreign buyers.
Verify before you trust it
Run the checks above against your own data instead of adopting them at face value. The failure modes are specific enough that a single afternoon of measurement will either confirm this diagnosis or rule it out — both outcomes are useful, and guessing is not.
Automation Workflow Pack
A ready-to-use package for exactly this workflow — $27.55, delivered immediately.
Sold via Gumroad, which acts as merchant of record and handles payment and applicable taxes. All sales are final; see the return policy before purchase.