BBB App Home Runtime
App versionv1.10.55 Updated17 Nov 2026, 13:36 Storebbb-dev-3.myshopify.com Shopify releaseGitHub-managed / source v1.10.55

Pre-order Availability

Standalone BBB app home for the Order Admin block runtime.

Scan report

Last 24 hours

Queue schedule: 06:00-23:59 HKT every 15 minutes; overnight every 30 minutes.

OPEN/ON_HOLD reverse-index reconciliation: 03:00, 14:00 HKT. The Mac scheduler checks saved settings every 15 minutes.

Current state: No D1 run row is currently marked running.

Next scheduled run: 18:15 HKT queue-only.

Run budget: 12 minutes per resumable background batch.

Native webhook wake-ups and the physical cron enqueue D1-deduplicated work into separate single-concurrency lanes for order work and full-active reconciliation. The remaining platform time is reserved for cache writes, audit finalization, and continuation enqueue. Stale running rows are marked exception so unfinished work cannot look complete.

Latest run: webhook:orders/updated:continue ok at 17 Nov 2026, 18:11

Schedule saved: 28 Jul 2026, 11:13 by release:v1.10.32. Run audit starts from 18 Jun 2026, 10:35 HKT.

Affected SKUs 0
Affected locations 0
Pending queue batches 0
Indexed preorder lines 5509
Indexed OPEN/ON_HOLD orders 1224
Indexed SKUs 4328
Reverse index reconciled Yes
Reverse index schema stale-while-revalidate-v3
Pending order recomputes 0
Due order recomputes 0
Pending webhook replays 0
Due webhook replays 0
Full enriched caches 4623
Inventory-only caches 0
Oldest inventory-only -
Runs 40
Batches 80
FO pages 0
Orders scanned 54
SQLite cached 0
Audit pending 14
Errors 0

No configured OPEN/ON_HOLD reconciliation is recorded in this filter window.

Run audit starts from 18 Jun 2026, 10:35 HKT; older no-op schedule runs cannot be backfilled.

From v1.10.5 onward, a scheduled run writes a running row at start and replaces it with a completion row.

Retry done: No retry completion is recorded in this filter window.

Not retried yet: No failed affected batch is waiting for retry in this filter window.

Verification: affected batches use the D1 reverse index and hand exact order ids to the deduplicated order queue. A healthy batch has status=ok, errorCount=0, and no broad FO pages; exact-order run rows own the later D1 cache result.

Run records

Time Source Status FO pages Orders SQLite cached Errors Duration Queue Message
17 Nov 2026, 18:11 webhook:orders/updated:continue ok 0 1 1 0 2s - Batch processed successfully.
17 Nov 2026, 18:11 webhook:orders/fulfilled:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:11 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:10 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:10 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:10 webhook:orders/updated:continue ok 0 1 1 0 3s - Batch processed successfully.
17 Nov 2026, 18:09 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:08 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:06 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:06 webhook:orders/fulfilled:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:06 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:06 webhook:orders/fulfilled:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:06 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:05 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:05 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:04 webhook:orders/fulfilled:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:04 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:03 webhook:orders/updated:continue ok 0 1 1 0 2s - Batch processed successfully.
17 Nov 2026, 18:03 webhook:fulfillment_orders/placed_on_hold:continue ok 0 1 1 0 2s - Batch processed successfully.
17 Nov 2026, 18:03 webhook:orders/updated:continue ok 0 1 1 0 2s - Batch processed successfully.
17 Nov 2026, 18:03 webhook:fulfillment_orders/hold_released:continue noop 0 0 0 0 0s - No pending affected SKU/location queue and no active transfer seed targets; no full-store scan was performed.
17 Nov 2026, 18:02 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:02 webhook:orders/fulfilled:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 18:01 webhook:orders/updated:continue ok 0 1 1 0 2s - Batch processed successfully.
17 Nov 2026, 18:00 webhook:orders/updated:continue ok 0 1 1 0 3s - Batch processed successfully.
17 Nov 2026, 18:00 webhook:orders/updated:continue ok 0 1 1 0 3s - Batch processed successfully.
17 Nov 2026, 18:00 scheduled:queue-only:18:00 noop 0 0 0 0 0s - No due webhook replay, order recompute, or affected SKU/location queue; queue-only schedule did not run a full-store scan.
17 Nov 2026, 17:59 app-block:cache-hit:continue noop 0 0 0 0 0s - No pending affected SKU/location queue and no active transfer seed targets; no full-store scan was performed.
17 Nov 2026, 17:59 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 17:59 webhook:orders/fulfilled:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 17:58 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 17:57 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 17:57 webhook:inventory_levels/update:continue ok 0 2 2 0 7s - Batch processed successfully.
17 Nov 2026, 17:56 webhook:orders/updated:continue pending 0 2 2 0 9s 8 pending Affected SKU/location work remains queued; cursor state is kept in D1.
17 Nov 2026, 17:56 webhook:inventory_levels/update:continue pending 0 3 3 0 14s 6 pending Affected SKU/location work remains queued; cursor state is kept in D1.
17 Nov 2026, 17:56 webhook:inventory_levels/update:continue ok 0 4 4 0 12s - Batch processed successfully.
17 Nov 2026, 17:56 webhook:orders/updated:continue ok 0 1 1 0 2s - Batch processed successfully.
17 Nov 2026, 17:55 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 17:53 webhook:orders/fulfilled:continue ok 0 1 1 0 1s - Batch processed successfully.
17 Nov 2026, 17:53 webhook:orders/updated:continue ok 0 1 1 0 1s - Batch processed successfully.

Affected batch records

Time Batch Status Filter FO pages Orders SQLite cached Errors Cursor
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 2 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 2 0 0 done
17 Nov 2026, 17:57 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:56 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 2 0 0 done
17 Nov 2026, 17:56 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:56 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:56 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:56 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:56 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:56 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:56 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 2 0 0 done
17 Nov 2026, 17:56 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:56 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:56 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:56 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:56 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 3 0 0 done
17 Nov 2026, 17:56 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 2 0 0 done
17 Nov 2026, 17:56 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:51 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:51 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:51 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:51 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:51 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:50 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:50 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:50 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:50 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:50 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:50 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 5 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:39 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:38 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:38 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:38 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:38 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 2 0 0 done
17 Nov 2026, 17:38 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:38 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 1 0 0 done
17 Nov 2026, 17:38 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:38 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:38 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done
17 Nov 2026, 17:38 buybookbook.myshopif...96271 ok OPEN,ON_HOLD 0 0 0 0 done

Order analysis details

Open an order in Shopify Admin, then click Details inside the Pre-order Availability block.

The details page uses the latest analysis already read by the Order Admin block. It does not need a separate Shopify Admin API token.

Order Admin block logic

  • All availability calculations use Shopify Location 26296271. The $app.preorder_availability snapshot only decides which order lines are preorder-relevant; it never selects a location.
  • A valid whole-order snapshot is authoritative, including an intentionally empty items array. If the snapshot is absent or invalid, the exact order uses live inventory fallback at Location 26296271 and reports only lines whose remaining demand is actually short.
  • The Order Admin block reads the current compact D1 page and its next same-generation page in one indexed query. A readable result older than 16 hours remains visible, but a freshness-gated GET automatically promotes that active order into the D1 recompute Queue and the Block polls until a fresh complete generation arrives; staff are not told to run an immediate manual Refresh. Prefetched pages switch locally; if a page is absent, Previous/Next remains a retryable action that loads that exact D1 page before switching instead of becoming permanently disabled.
  • Details opens a separate Shopify Order Details Action. It reads the exact order's complete D1 availability payload once, mounts the first 75 rows, then automatically appends 50-row batches in the same Shopify-native modal scrollbar without another D1 request, an external cacheKey, or modal pagination.
  • Manual Refresh awaits the D1 write and canonical compact read-back before exposing a new Block generation. Details independently reads the latest complete D1 payload and never starts a live Shopify scan.
  • The Order Admin result uses one shared seven-track grid for its header and every row. The compact toolbar keeps Details, Previous, and Next on the Refresh row; the summary shows Active FOs, current-page FO labels, Out of Stock Items, and page position without status text. Details uses the same seven columns and progressive row mounting but no page boundary or page controls.
  • SKU uses a wider 22fr track in both the Block and Details Action, with no hidden overflow. The canonical trimmed text remains selectable and may wrap naturally at hyphens; no zero-width character, artificial newline, or unsupported clipboard promise is inserted.
  • Each Title links to the exact Shopify Product Admin variant route using live ProductVariant and parent Product ids. The Order Admin block and the Details Action use the same link; no SKU, barcode, or title pairing is permitted.
  • Every D1 payload is explicitly inventory_only or full_enriched. A full_enriched result requires completed demand allocation plus completed Transfer and shipment ETA enrichment.
  • An inventory_only payload may paint current shortage data quickly. The block distinguishes Updating allocation data from Updating transfer data and keeps Est./T# at Updating... instead of using '-' to claim no transfer exists.
  • Webhook and order events never delete the last completed availability result before recomputation. A pending full result stays readable with Updating inventory data until the replacement generation is complete.
  • A partial inventory_only write never overwrites the full_enriched table. It may advance the compact fast lane only when it is a newer generation, so an older full payload cannot hydrate or overwrite it.
  • Compact page generations are written before the compact pointer switches. Page reads join the selected compact generation, so Previous/Next never mixes old and new pages.
  • D1 preorder_open_line_index maps fixed-location variant/inventory items directly to OPEN/ON_HOLD order lines, so an inventory event does not rescan the store for every affected order.
  • D1 preorder_open_order_state uses a SHA-256 content signature so reconciliation queues only new, changed, or stale preorder orders, not every unchanged active order.
  • A completed reverse-index generation remains the demand-allocation baseline while a later cursor reconciliation is in progress. Exact-order webhook refreshes replace that order's rows immediately, so a store-wide cursor no longer downgrades every recompute to inventory_only.
  • Inventory, Transfer, shipment tracking, and order-status webhooks are persisted by webhook id before acknowledgement. The HTTP handler only wakes the D1-deduplicated work Queue; its single-concurrency consumer resolves indexed affected orders. D1 retains pre-change Transfer/Shipment targets so remove/delete events cannot lose the affected variants.
  • preorder_webhook_replay_queue and preorder_order_recompute_queue use leases, event/order coalescing, priority, and controlled exponential retries for real failures. Repeated events coalesce without superseding unclaimed work; a new revision is created only while an older revision is actively leased.
  • Every queue run restores any active inventory_only D1 cache that has lost its recompute row. The self-healing query is keyed by the OPEN/ON_HOLD order index; full_enriched or inactive orders are not requeued.
  • If an indexed active order has no valid D1 cache yet, the block displays Updating inventory data before an idempotent background enqueue promotes that exact known order to priority 100 once. Repeated polls do not write, cancel its retry delay, or supersede its in-flight revision.
  • A work run resolves a bounded webhook batch into coalesced D1 order/target rows first, expands affected SKU/location reverse-index rows second, and only then recomputes priority orders. Multiple webhook events therefore merge before expensive order analysis.
  • Native Queue wake-ups process webhook and affected SKU/location work immediately. The 06:00-23:59 HKT 15-minute gate and overnight 30-minute gate are recovery wake-ups; neither performs a 50,000-order live scan.
  • The default 03:00 and 14:00 HKT full-active runs only reconcile the OPEN/ON_HOLD reverse index by D1 cursor. They are a safety net for missed events, not the primary daytime freshness path.
  • Transfer enrichment queries Shopify by exact product_variant_id plus Location 26296271 and only IN_PROGRESS or READY_TO_SHIP status. The 20-page safety cap therefore applies to one variant instead of the store-wide destination list; identical Transfer and Shipment responses are memoized within each run.
  • Dashboard schedule Save is authenticated by a Shopify ID token and writes the runtime schedule to SQLite; the Mac scheduler reads it every 15 minutes.
  • Background runs use a bounded 12-minute application budget and resume remaining work from durable SQLite queues. Work and reconciliation stay in separate single-consumer lanes.
  • Any run that remains marked running beyond the 12-minute budget and grace window is changed to exception on the next run. Its D1 replay, queue, lease, and cursor state remains available for controlled retry.
  • Only fulfillment orders in OPEN or ON_HOLD are scanned or analyzed.
  • Only line items with remainingQuantity > 0 are checked.
  • Queue-aware logic deducts earlier active demand before deciding whether this order is still blocked.
  • OHand-Pcommit is Location 26296271 on_hand less earlier OPEN/ON_HOLD demand and same-order variant demand already counted; Incom is the current incoming quantity.
  • Est. comes from the matching InventoryShipment tracking.arrivesAt value, and T# uses the matching InventoryTransfer.name with the current /transfers/{id} Admin link.
  • Manual Refresh remains an explicit read-only exact analysis; automatic order open never starts a shop-wide live demand scan.
  • Every affected scan batch writes D1 audit rows; failed cache writes keep the cursor queued for retry.
  • Refresh and Details are read-only.