Pricing Pipeline — ADR-012

4-pillar operating model · sources → derive → propose → HITL → push · 62 D1 tables · 21 ADRs

01 / Sources 02 / Derive 03 / Propose 04 / Approve 05 / Publish NetSuite invoice_lines · so_lines · items Bids (R2 + email) bids@ · external portal · review Commodity feeds CME cheddar · USDA drawdown Programs · rebates customer_programs · ladders /api/pricing/derive median of last 3 invoices since 2024 pricing_master derived view · refresh every 15m Bid line match Vectorize KNN · direct/alt/commodity Apply programs list × at_invoice − bill_backs − MDF customer_pricing_proposed Pillar 1 baseline bid_lines Pillar 2 · per-line proposals pricing_anomalies drift > 5% · AI narrative Council v2 review 3 models · multi-source validate proposed_actions HITL queue · X-Edit-Token Mike approves admin-dashboard.html · /decide pricing_snapshots immutable record per change Annual roll workflow CF Workflow · July 1 cutover customer_pricing Pillar 3 · effective price list NS_PUSH_QUEUE Pillar 3 → NS price record write Quote / HTML page /pricing/<slug> · send_quote_to_customer llm_wiki refresh Pillar 4 · narrative + decision corpus invoices bid spec commodity move rebate config Pillar 1 baseline derived drift detect anomaly Pillar 2 lines effective price review review narrative propose HITL gate approve · snapshot annual trigger Pillar 3 apply next SY prices push price available Pillar 4 learn Legend primary data policy / PII async batch data store

Four pillars (PRICING_OPERATING_MODEL)

  • • Pillar 1 — Current Price Review: derive · drift · snapshot
  • • Pillar 2 — Bid Pipeline: intake · match · price · submit · award
  • • Pillar 3 — Customer Update: apply approved changes · push NS
  • • Pillar 4 — Annual Roll: 11-step CF Workflow · July 1 cutover

Sources of truth

  • • pricing_master = derived from invoice_lines (last 3 since 2024)
  • • customer_pricing_proposed = Pillar 1 baseline
  • • bid_lines = Pillar 2 per-line proposals
  • • customer_pricing = Pillar 3 effective list (NS-pushed)
  • • pricing_snapshots = immutable change record

HITL invariants

  • • Every pricing write through proposed_actions queue
  • • X-Edit-Token required on /decide
  • • Drift > 5% flags pricing_anomalies · never auto-fix
  • • Council v2 reviews · 3 models + chairman synth
  • • All NS pushes via NS_PUSH_QUEUE (no direct NS writes)

ADRs anchoring this pipeline

  • • ADR-012 pipeline · ADR-013 folder consolidation
  • • ADR-014 programs · ADR-015 email intake · ADR-016 chat
  • • ADR-019 NS mirror-back wait · ADR-031 HITL gate
  • • 21 total ADRs · post-audit 2026-05-20 · 62 D1 tables

Data-flow diagram • Built with Archify • Press T for theme and E for export