Live on P21 v23+Built for Prophet 21 distributors

From P21 data
to controlled execution.

MarginBase reads your Prophet 21 live, surfaces what to act on — supplier risk, stockouts, cost drift, Mock POs — and pushes approved changes back. No spreadsheets, no nightly exports.

See the product
SOC 2 · in progressConnects in ~30 minRead-only by default
app.marginbase.com/dashboard
Dashboard
Buyer's Guide
Mock PO
Replenishment
Cost Mgmt
Admin
P21 Integ.
Tue · May 25
Morning, Maria
At risk
7
suppliers
Stockout
142
items
Mock POs
14
$412k draft
Batches
3
to push
Top supplier risksLive · 5m ago
SupplierBuyerOTIF · 12wAt riskStatus
Halcyon SurgicalM. Alvarez48%34urgent
Vanguard LabworksJ. Smith62%21watch
Northbridge PharmaR. Patel83%4ok
Trusted by P21 distributors moving billions through Prophet 21
The cost of doing nothing

Your P21 already has the answers. The problem is your team can't see them in time.

Buyer's Guide reports live in static PDFs. Replenishment recommendations sit inside SQL. Mock POs get drafted in Excel, lost between buyers, then re-keyed into P21 by hand. The data is fine — the workflow is the bottleneck.

MarginBase sits on top of your existing P21 install and turns those answers into a single, live workspace.

0%
of stockouts at distributors on P21 have a recommendation already in the data — buyers just never see it until it's too late.
0h
a typical buyer spends each week toggling P21 reports, spreadsheets, and emails to make purchasing decisions.
0%
avg margin lift in the first 90 days from teams that move replenishment + cost reviews into a single workspace.
Buyer's Guide

See every supplier risk before it hits a customer.

One live table across every supplier, every DC. OTIF trend sparklines, items-at-risk, status pills — and a drawer that pulls 12 weeks of context the moment you click a row.

  • Inline OTIF + at-risk sparklines — no chart-hunting
  • Click any row → supplier drawer with recent activity + draft Mock PO in one click
  • Filterable by buyer, location, status; column visibility persists per user
app.marginbase.com/buyers-guide
Suppliers
42
across 4 DCs
Urgent
7
action needed
Upcoming
14
watch list
Active buyers
8
live coverage
All suppliersfilters · 3142 rows
SupplierBuyerOTIF · 12wItems at risk · 8wStatus
Halcyon SurgicalM. Alvarez48%34urgent
Vanguard LabworksJ. Smith62%21watch
MedSupply GroupR. Patel81%8ok
Northbridge PharmaM. Alvarez83%4ok
Mock PO Requirements

Build POs as a two-pane workspace, not a spreadsheet.

Left rail: every draft, status, actual-vs-target. Right pane: a clean line editor with live totals and 30-day usage sparklines per SKU. Approved POs push to P21 with one click.

  • Toggle Buy? per line — totals + pallet usage recompute live
  • Submit for review routes to the right Admin based on your ceiling rules
  • Approved Mock POs push to P21 via Web API; audit log is append-only
app.marginbase.com/mock-po
14 drafts
Halcyon Surgical
Eastland · DC
72% / target
Vanguard Labworks
Northbridge · DC
108% / target
MedSupply Group
Hartfield · DC
45% / target
Northbridge Pharma
Eastland · DC
92% / target
Halcyon Surgical · Eastlandunder targetedited 12m ago
Est. PO total
$ 42,180
Target
$ 58,500
Pallets
14 / 20
BuyProductQtyExt.30d usage
HSC-2841-A Halcyon NS retractor24$ 4,680
HSC-1109-X Surgical gauze 10x10120$ 2,160
HSC-3308-B Sterile drape kit48$ 7,200
HSC-5512-K Wound closure tray12$ 3,840
Replenishment Analysis

Forecast-driven min/max, not gut feel.

Per-SKU forecast with rec-min / rec-max bands, days-to-stockout, and a plain-English explanation of why we recommend what we recommend. Bulk-push corrected min/max back to P21 in one operation.

  • 14-day forecast + service-level + ADU per SKU
  • Filter by ABC class, reliability, or stockout risk
  • "Why these numbers?" callout on every recommendation — your buyers stay in control
app.marginbase.com/replenishment/halcyon
ADU · 30d
12.4
units / day
Days to stockout
9.2
at current min
Service level
97%
last 90 days
Forecast · HSC-2841-A14-day window
Rec max 130Rec min 70D0D3D6D9D12
Why these recommendations? Demand is decaying ~3.2%/wk with reliability 88%. Suggested Rec max 130 covers a 9-day buffer at current ADU; Rec min 70 triggers reorder ~3 days before stockout.
Cost Management

Catch cost drift before it eats your margin.

Drop a supplier cost sheet, see the delta vs current P21 line-by-line, route through review, and push approved changes — never re-key a cost again.

  • CSV / XLSX drop-zone, deltas color-coded vs current P21 cost
  • Per-batch approval workflow + dollar exposure visualization
  • Audit trail joins to the buyer / Mock PO / supplier — no orphaned changes
app.marginbase.com/cost-mgmt
Open batches
2
awaiting review
Pushed · MTD
11
3,824 lines
Avg delta
+2.1%
vs P21 cost
Cost exposure
$148k
if all pushed
Recent cost batcheslast 30 days
BatchSupplierItemsStatusΔ vs P21
B-002419Vanguard Labworks142review+3.2%
B-002418Halcyon Surgical88pushed+1.4%
B-002417MedSupply Group211draft−0.8%
B-002416Northbridge56pushed+2.1%
How it works

Connect once. Sync continuously. Act with confidence.

MarginBase runs on top of your existing Prophet 21 install — no schema changes, no nightly exports, no consultants required to get the first workspace live.

STEP 01

Connect P21 — both channels

Whitelist our static IP, paste a read-only MSSQL user, optionally add P21 Web API creds for pushes. We test the handshake before anything saves.

≈ 30 min · with your DBA
STEP 02

We pull continuously

Inventory, sales history, suppliers, ABC classes — pulled on a schedule you control, mapped to MarginBase's data model. Read-only on your P21.

Initial sync ≈ 15 min
STEP 03

Your team acts in MarginBase

Buyers draft Mock POs, review replenishment, approve cost batches. Approved changes push back to P21 via the Web API — audited, scoped per-buyer, fully reversible.

Live · first day
app.marginbase.com/p21-sync · Connection
Whitelist this IP on your firewall
Port 1433 (MSSQL) and 443 (REST). Single static IP, doesn't change.
52.18.94.221
Data pull · MSSQL read-only
connected
p21-sql.acme-medical.local · P21Play · svc_marginbase
Tables
138
SKUs
4,812
Last pull
2 min ago
Healthy P21 — schedule live
Pushes · P21 Web API
connected
p21.acme-medical.local/api/v3 · v23.2.4 · 99.4% success · 7d
Pricing

Priced per seat. Every plan scales.

Pay only for active users + pending invites. No surprise overage on Growth and Scale — soft overflow is trued-up at renewal.

Starter
For small distributors getting a P21 workspace off the ground.
$16/ seat / mo
billed annually · 3 seats included
  • Core
  • Buyer's Guide + supplier drawer
  • Mock PO Requirements (single buyer)
  • Read-only P21 pull (MSSQL)
  • Limits
  • 1 DC scope
  • No P21 Web API pushes
  • No Cost Management
  • Support
  • Community + email
Scale
For multi-site distributors with formal approval workflows.
$9/ seat / mo
billed annually · 20 seats included
  • Everything in Growth, plus
  • Approval ceilings + push budgets per buyer
  • Sensitive activity audit feed (365-day retention)
  • Rules engine (commission, pricing, replenishment)
  • Limits
  • Unlimited DCs
  • SSO (Google / Microsoft)
  • Support
  • Shared Slack channel · same-day
Enterprise
For groups with custom P21 setups, multi-tenant orgs, or SLAs.
Custom
Talk to us — annual contract
  • Everything in Scale, plus
  • Dedicated initial-sync engineer
  • Custom rules + scoped P21 push credentials
  • SAML SSO · SCIM provisioning
  • Contract
  • Annual contract · quarterly true-up
  • Custom data retention
  • Support
  • Named CSM · 99.9% SLA
Need to compare in detail or migrate from another tool? Talk to our team — we'll get you a side-by-side in under a day.
FAQ

Questions we get on the first call.

Will MarginBase write to my Prophet 21 database?

No. The MSSQL pull is read-only — we only SELECT. Pushes happen via the official P21 Web API and only after a buyer or admin explicitly approves a Mock PO or cost batch. Every push is audit-logged, scoped, and reversible.

How fast can we go live?

Most teams are running on real P21 data within a day. You'll need ~30 minutes with a DBA to whitelist our static IP and provision a read-only SQL user; the initial sync runs in the background while your team explores the workspace.

What if our P21 is on a custom build or older version?

MarginBase supports Prophet 21 v22+ and validates against your schema before saving credentials. For unusual installs — custom tables, regional fields, multi-company configs — we'll work with your DBA during onboarding to map the right sources.

Do you store our P21 credentials?

Encrypted at rest with your tenant key. They're write-only after save — never returned in plaintext. Rotating a key takes one click and is captured in the sensitive activity audit log.

Can I limit which buyers can push to P21?

Yes. On Scale and Enterprise you can set approval ceilings (dollar amount, per-line, per-day) and per-buyer push budgets. Anything above the threshold routes to an Admin for sign-off before reaching P21.

What happens if we add seats mid-cycle?

Growth and Scale support soft overflow — invite people now, get a true-up at renewal. Starter is a hard cap; you'll need to upgrade or remove an inactive user. The Admin → Plan tab shows your seat utilization in real time.

Is there a free trial?

We don't run a self-serve free trial because most value comes from real P21 data, and we'd rather get you connected than show you a sandbox. A demo includes a guided 14-day pilot on your data.

How does cancellation work?

Cancel any time. We export your data on request (CSV + JSON) and retain it for 90 days after cancellation in case you change your mind. We never share it.

Get started

See your Prophet 21 data come to life — in your data, not a sandbox.

A 30-minute call with our team. We connect to your P21 on the call, walk you through Buyer's Guide + Mock PO with real SKUs, and leave you with a 14-day pilot.

What you'll get on the call
  • · Live connection test to your P21
  • · Buyer's Guide rendered on your suppliers
  • · Per-tier pricing tailored to your team size
  • · 14-day pilot setup — no card on file