Morning summary of overnight Kravet price audit (CNCP + notification)

0de24336dde0f75426332fdc3600a0f33e342b6f · 2026-06-11 19:05:20 -0700 · SteveStudio2

Files touched

A shopify/scripts/cadence/kravet-overnight-summary.sh

Diff

commit 0de24336dde0f75426332fdc3600a0f33e342b6f
Author: SteveStudio2 <stevestudio2@SteveStacStudio.lan>
Date:   Thu Jun 11 19:05:20 2026 -0700

    Morning summary of overnight Kravet price audit (CNCP + notification)
---
 .../scripts/cadence/kravet-overnight-summary.sh    | 26 ++++++++++++++++++++++
 1 file changed, 26 insertions(+)

diff --git a/shopify/scripts/cadence/kravet-overnight-summary.sh b/shopify/scripts/cadence/kravet-overnight-summary.sh
new file mode 100755
index 00000000..c7d78b86
--- /dev/null
+++ b/shopify/scripts/cadence/kravet-overnight-summary.sh
@@ -0,0 +1,26 @@
+#!/bin/zsh
+# Morning summary of the overnight READ-ONLY Kravet price audit. Posts to CNCP + notification.
+PSQL=/usr/local/bin/psql; [ -x "$PSQL" ] || PSQL=$(command -v psql)
+CORRUPT=$("$PSQL" -d dw_unified -At -c "SELECT count(*) FROM kravet_price_mismatch WHERE note='CORRUPTION_SUSPECT';")
+BELOW=$("$PSQL" -d dw_unified -At -c "SELECT count(*) FROM kravet_price_mismatch WHERE note='BELOW_MAP';")
+CHECKED=$("$PSQL" -d dw_unified -At -c "SELECT v FROM kravet_monitor_state WHERE k='cursor';" | wc -c)
+TOTAL=$(("${CORRUPT:-0}" + "${BELOW:-0}"))
+OUT=/tmp/kravet-overnight-summary.txt
+{
+  echo "Kravet overnight price audit — $(date '+%Y-%m-%d %-I:%M %p')"
+  echo "  CORRUPTION_SUSPECT (live > 2x MAP): ${CORRUPT:-0}"
+  echo "  BELOW_MAP (underpriced / \$4.25):    ${BELOW:-0}"
+  echo "  -> corrective worklist: dw_unified.kravet_price_mismatch"
+  echo "  authoritative ref: dw_unified.kravet_map_authoritative (GDrive master, MAP=cost x1.5)"
+  echo ""
+  echo "  NOTE: NO live Shopify writes were made overnight (kill switch on, runner stood down)."
+  echo "  A parallel agent (reprice-restore-kravet.js) was pushing wrong prices off CORRUPT cost."
+  echo "  Decision needed: approve a corrective pass + pick which system owns Kravet MAP."
+  echo ""
+  echo "  top offenders:"
+  "$PSQL" -d dw_unified -At -F' | ' -c "SELECT note, mfr_sku, live_price, authoritative_map, deviation_pct||'%' FROM kravet_price_mismatch ORDER BY abs(deviation_pct) DESC LIMIT 10;" | sed 's/^/    /'
+} > "$OUT"
+/usr/bin/osascript -e "display notification \"${TOTAL} Kravet mispricings flagged (${CORRUPT:-0} corrupt, ${BELOW:-0} below-MAP) — read /tmp/kravet-overnight-summary.txt, then decide corrective pass\" with title \"Kravet overnight audit\"" 2>/dev/null
+/usr/bin/curl -s -X POST http://127.0.0.1:3333/api/wins -H 'Content-Type: application/json' \
+  -d "{\"project\":\"designer-wallcoverings\",\"title\":\"Kravet overnight audit: ${TOTAL} mispricings flagged (read-only)\",\"summary\":\"${CORRUPT:-0} CORRUPTION_SUSPECT + ${BELOW:-0} BELOW_MAP vs authoritative MAP. Cost corruption (\$1014 vs real \$374) found; parallel agent pushed wrong live prices. No overnight writes — corrective worklist in kravet_price_mismatch awaiting Steve.\",\"valueToday\":\"Prevented mass live mispricing; built corrective worklist\"}" >/dev/null 2>&1
+cat "$OUT"

← e7a0a4b3 Read-only overnight Kravet price monitor: diff live vs autho · back to Designer Wallcoverings · Part 2 twin: Schumacher dw_sku→shopify_product_id LINK hando c90065ca →