PO Pilot MCP
PO Pilot MCP gives Shopify merchants and wholesalers deterministic back-office purchasing tools for replenishment forecasting, supplier PO creation, AP 3-way matching, and Stocky CSV recovery.
Calculate replenishment plans: compute ABC classes, stockout-adjusted velocity, safety stock, reorder points, inventory position, days of cover, and carton-rounded order recommendations.
Build supplier purchase orders: group SKUs by vendor, enforce MOQs/case packs/vendor minimums, calculate tariff + freight landed costs, flag margin erosion, apply Open-to-Buy cash limits, and output Shopify Draft PO CSV, POS Transfer CSV, and vendor emails.
Reconcile invoices with 3-way match: compare PO vs. receiving vs. supplier invoice to catch price creep, short shipments, unapproved surcharges, and freight overages; produce verified payable amount, QuickBooks/Xero Bill CSVs, and a debit memo email.
Recover Stocky supplier data: reconstruct supplier profiles, observed lead times, carton packs, historical minimum spend, and ready-to-use supplier rules JSON from Stocky PO CSV exports.
Run flexibly: use zero-key demo/CSV mode, optional read-only Shopify Admin GraphQL, or Streamable HTTP for n8n/cloud integrations.
Connects to the Shopify Admin GraphQL API using read-only credentials to read products, inventory, and orders, enabling replenishment planning, supplier purchase order generation, and Accounts Payable 3-way invoice matching; also generates Shopify Draft Purchase Order CSV blocks for import into Shopify Admin.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@PO Pilot MCP build this week's vendor POs and export Shopify draft PO CSVs"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
PO Pilot MCP (po-pilot-mcp)
Post-Stocky replenishment math, Open-to-Buy & US tariff landed-cost Purchase Orders, Shopify POS barcode Transfer CSVs, Stocky CSV supplier recovery, and Accounts Payable 3-way invoice matching (with QuickBooks Online & Xero Bill CSV exports) for Shopify merchants and US wholesalers.
Shopify retired Stocky on August 31, 2026. Native Shopify Admin stores inventory counts and draft PO records, yet drops the purchasing logic merchants relied on: reorder point calculation, carton/case-pack rounding, vendor minimum order thresholds, supplier export, and invoice discrepancy checks. Meanwhile, Shopify's official Storefront and UCP MCP endpoints (catalog, cart, checkout, policies) serve front-office shoppers only.
po-pilot-mcp connects Claude Desktop, Claude Code, Cursor, or n8n to four deterministic back-office purchasing tools. Every tool runs locally or over Streamable HTTP with zero required credentials in demo_mode or CSV mode, and optionally connects to live Shopify Admin GraphQL (2026-04) when read-only store credentials are supplied.
Setup in Under 60 Seconds
Option A: Zero-Key Quickstart (Claude Desktop / Cursor)
Add this block to claude_desktop_config.json or .cursor/mcp.json (exact version pin recommended for reproducible deployments):
{
"mcpServers": {
"po-pilot": {
"command": "npx",
"args": ["-y", "po-pilot-mcp@1.0.0"]
}
}
}Option B: Claude Code CLI (One Command)
claude mcp add po-pilot -- npx -y po-pilot-mcp@1.0.0Option C: Live Shopify Store Mode (Optional Read-Only Admin Token)
Create a custom app in Shopify Admin -> Settings -> Apps and sales channels -> Develop apps with three read-only scopes: read_products, read_inventory, and read_orders.
{
"mcpServers": {
"po-pilot": {
"command": "npx",
"args": ["-y", "po-pilot-mcp@1.0.0"],
"env": {
"PO_PILOT_LICENSE_KEY": "your_polar_or_pop1_license_key",
"SHOPIFY_STORE_DOMAIN": "your-store.myshopify.com",
"SHOPIFY_ACCESS_TOKEN": "shpat_your_read_only_token"
}
}
}
}Option D: Remote Streamable HTTP (n8n / Cloud Gateways / MCPize)
npx -y po-pilot-mcp@1.0.0 --http
# Listening on http://0.0.0.0:8080/mcp (Health check: GET /health)Related MCP server: Shopify MCP Server
3 Copy-Paste Prompts (Test Immediately)
Prompt 1: Monday Morning Vendor PO Run + Landed Cost + POS Barcode CSV (Zero API Keys Needed)
Use po-pilot to run `build_supplier_purchase_orders` with `demo_mode: true`, `service_level: "95%"`, and `max_cash_budget_usd: 3800`. Show me:
1. Which SKUs are at CRITICAL stockout risk after adjusting for past stockout days,
2. True landed unit costs after US import tariffs + freight (and any margin-erosion warnings) plus how Open-to-Buy rationed cartons under my $3,800 cash cap,
3. Both the Shopify Admin Draft PO CSV (`SKU,Supplier SKU,Quantity,Cost,Tax %`) and the Shopify POS Inventory Transfer CSV (`SKU,Barcode,Quantity`), and
4. The ready-to-send PO emails for each vendor.Prompt 2: Rescue Un-Exportable Supplier Data from Stocky CSV
Shopify Stocky never exported our supplier directory before shutting down. Run `migrate_stocky_csv_snapshot` with `demo_mode: true` (or use the Stocky Purchase Orders CSV I paste below) to reconstruct each vendor's real observed lead time in days, inferred carton pack sizes, latest unit costs, and a ready `supplier_rules` JSON configuration.Prompt 3: Finance Ops 3-Way Match Audit + QuickBooks/Xero Verified Bill CSV
Run `reconcile_po_three_way_match` with `demo_mode: true`. Cross-check our original Purchase Order against warehouse dock receiving counts and the supplier's billed invoice. List every unit-price overcharge, short-shipment billed in full, unapproved surcharge, and freight cap overage, then give me the verified USD amount to pay ($2,386.20), the ready-to-import QuickBooks Online & Xero Bill CSVs (excluding unapproved fees), and the Debit Memo email to send their AR team.Tool Reference (4 Workflow Tools)
Tool Name | Purpose | Inputs | Key Outputs | Annotations |
| Margin-weighted ABC classification, stockout-adjusted daily velocity, Z-score safety stock, and reorder points |
| Per-SKU |
|
| Groups SKUs per vendor, rounds cartons, enforces vendor MOQs, computes US tariff + freight landed cost, enforces Open-to-Buy ( | Same as above + | Per-vendor |
|
| Accounts Payable 3-way match comparing PO vs warehouse receiving vs supplier invoice + accounting CSV export |
|
|
|
| Rebuilds supplier profiles, real lead-time averages/std-dev, and carton multiples from Stocky PO CSV exports |
|
|
|
Deterministic Math Under the Hood
Inventory Position (prevents double-ordering while stock is in transit): $$\text{IP} = \text{OnHand} + \text{OnOrder} - \text{Committed} - \text{Backorders}$$
Stockout-Adjusted Daily Velocity (prevents artificially depressed velocity when a bestseller was out of stock for part of the month): $$d = \frac{\text{UnitsSold}}{\max(1,; \text{WindowDays} - \text{StockoutDays})}$$
Demand + Lead-Time Variability Safety Stock: $$\text{SS} = \left\lceil Z \cdot \sqrt{\text{LT} \cdot \sigma_d^2 + d^2 \cdot \sigma_{\text{LT}}^2} \right\rceil$$ where $Z \in {1.04, 1.28, 1.65, 1.96, 2.33}$ for $85%, 90%, 95%, 97.5%, 99%$ cycle service levels.
Periodic Review Order Quantity & Carton Rounding: $$\text{ROP} = \lceil d \cdot \text{LT} + \text{SS} \rceil, \quad S = \lceil d \cdot (\text{LT} + R) + \text{SS} \rceil$$ When $\text{IP} \le \text{ROP}$, raw order need $Q_0 = \max(\text{SKU-MOQ}, S - \text{IP})$ is rounded to carton multiples $\lceil Q_0 / \text{CasePack} \rceil \times \text{CasePack}$. If a vendor PO falls short of
min_order_value_usd(such as a $2,200 wholesale minimum or free-freight tier), the engine adds carton increments to the highest-velocity A-class SKU rather than padding slow C-items.
Security, Privacy & Reliability Guarantees
Zero Credential Persistence: Tokens passed via
SHOPIFY_ACCESS_TOKENremain in memory for the request lifetime only and are never logged, written to disk, or echoed in error payloads.Read-Only Store Access: Live Shopify GraphQL integration issues
POSTqueries solely for read operations (productVariantsandorders) and enforces a strict 15-secondAbortSignaltimeout.Crash-Proof Error Envelopes: Invalid CSV headers, missing parameters, or network timeouts return structured MCP
isError: trueresponses with remediation steps instead of terminating the stdio process.Zero Known Dependency Advisories: Verified clean under
npm audit.
Pricing & Entitlements
Local Free Sandbox (
npx -y po-pilot-mcp@1.0.0):$0— unlimited Stocky CSV supplier recovery (migrate_stocky_csv_snapshot), fulldemo_mode, and up to 25 SKUs / 15 unique invoice SKUs per call via CSV or JSON.Self-Hosted Lifetime Licenses + 3 n8n Automation Workflows (Solo $49 → | Agency $249 →):
Early-Bird Launch —
$49one-time (First 25 Buyers):Solo Store Unlimited— 1 Shopify store, Unlimited SKUs & invoice lines, Live Shopify Admin GraphQL, Open-to-Buy cashflow optimizer, and all 3 ready-to-import n8n workflows (#01,#02,#03) viaPO_PILOT_LICENSE_KEY.Regular Solo Store:
$99one-time (after first 25 launch licenses).3PL / Fractional CFO / Agency License —
$249one-time: Authorized for up to 10 client Shopify stores + multi-warehouse & QuickBooks/Xero AP workflow deployment rights.
MCPize Managed Cloud (Subscribe on MCPize →):
Free Sandbox (
$0/month) — 15 requests/month (instant zero-setup evaluation).Cloud Pro (
$29/month) — 500 requests/month (unlimited SKUs + Live Shopify sync + Landed Cost/OTB + QBO/Xero Bill CSVs).Cloud Agency / 3PL (
$79/month) — 3,000 requests/month (for multi-brand operators, 3PLs, and automated n8n AP monitors).
Maintainer Publish & Deploy Commands
# 1. Verify build, automated test suite, and zero security advisories
npm test && npm audit
# 2. Publish to npm
npm login
npm publish --access public
# 3. Deploy & activate Free/Pro tiers on MCPize
npx mcpize login
npx mcpize deploySee docs/LOOM-SCRIPT.md for the 3-minute product walkthrough script and docs/RESEARCH-REPORT.md for the market audit behind this build.
License
MIT License — see LICENSE.
Available Tools
4 toolsbuild_supplier_purchase_ordersBuild MOQ-Compliant Supplier POs, Landed Costs, OTB & Shopify PO/Transfer CSVsARead-onlyIdempotent
Turns SKU demand signals into ready-to-send Purchase Orders grouped by vendor. Enforces carton/case-pack multiples, per-SKU MOQs, supplier-level minimum units/USD thresholds (topping up A-class SKUs first), US import tariff + freight landed unit costs with margin-erosion alerts, and optional Open-to-Buy (max_cash_budget_usd) cashflow rationing. Outputs ready-to-import Shopify Native Draft PO CSV (SKU,Supplier SKU,Quantity,Cost,Tax %), Shopify POS Inventory Transfers CSV (SKU,Barcode,Quantity), and formatted vendor PO emails.
Inputs: skus, demo_mode, po_prefix, inventory_csv, +7 more.
calculate_replenishment_planCalculate Stockout-Adjusted Replenishment & Reorder PointsARead-onlyIdempotent
Replaces Shopify Stocky's retired forecasting brain. Computes margin-weighted ABC classes, stockout-adjusted daily sales velocity, demand + lead-time variability safety stock (SS = Z * sqrt(LTsigma_d^2 + d^2sigma_LT^2)), reorder points, inventory position (On-Hand + On-Order - Committed - Backorders), days of cover, and carton-rounded order recommendations. Free Local Sandbox processes up to 25 SKUs per call; Pro/License unlocks unlimited SKUs and Live Shopify sync.
Inputs: skus, demo_mode, window_days, inventory_csv, +4 more.
migrate_stocky_csv_snapshotRecover Supplier Directory, Real Lead Times & MOQs from Stocky PO CSVARead-onlyIdempotent
Shopify Stocky shut down on August 31, 2026 and never provided a Supplier Directory export. Paste a historical Stocky Purchase Orders CSV export (or pass demo_mode: true) and this tool reconstructs every supplier profile: actual observed lead-time average and standard deviation from Created-to-Received timestamps, latest SKU unit cost, GCD-inferred carton pack sizes, historical minimum PO spend, and ready-to-use supplier_rules JSON for build_supplier_purchase_orders.
Inputs: demo_mode, stocky_po_csv.
reconcile_po_three_way_matchAudit PO vs Receiving vs Supplier Invoice (3-Way Match + QuickBooks/Xero CSVs)ARead-onlyIdempotent
Deterministic Finance Ops 3-way match engine for wholesalers and Shopify merchants. Cross-examines approved Purchase Order lines, warehouse dock receiving counts (good vs damaged units), and billed supplier invoice lines to catch silent unit-price creep, short-shipments billed in full, unapproved surcharges, and freight cap overages. Emits ready-to-import QuickBooks Online (quickbooks_bill_csv) and Xero (xero_bill_csv) Purchase Bill CSVs containing ONLY verified payable quantities and unit costs, plus a vendor Debit Memo email. Free Local Sandbox audits up to 15 invoice lines per call; Pro/License unlocks unlimited invoice audits.
Inputs: vendor, currency, due_date, po_lines, +10 more.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 4 tools
The four tools target mostly distinct stages of the purchasing workflow: forecasting, PO construction, reconciliation, and Stocky migration. The main possible confusion is between calculate_replenishment_plan and build_supplier_purchase_orders, since one produces order recommendations and the other turns demand into vendor POs, but the descriptions clarify the handoff.
All tool names use consistent snake_case with a clear verb-first pattern: calculate_, build_, reconcile_, and migrate_. The names are predictable and readable despite being fairly long.
Four tools is well-scoped for a focused PO/inventory planning server. Each tool represents a meaningful workflow stage rather than a marginal convenience operation.
The surface covers the core forecast-to-PO-to-reconciliation lifecycle and includes a migration path from Stocky. Minor gaps remain around explicit supplier directory maintenance, receiving/invoice ingestion, and PO status lifecycle operations, but agents can work around these by supplying data as tool inputs.
Maintenance
Related MCP Connectors
Demand forecasts, reorder points, order quantities and inventory health for Shopify stores.
Read and update live small-business inventory, suppliers, reorder suggestions and purchase orders.
Warehouse ops from Claude: orders, stock, forecasts, parcel rates, labels you buy in the console
Create contacts, move deals, send proposals and invoices, read your inbox, from Claude or ChatGPT.
Related MCP Servers
- AlicenseBqualityCmaintenanceMulti-channel inventory intelligence for Shopify and Amazon sellers. 28 tools for stockout risk, demand forecasts, purchase order management, and sales analytics — with human-in-the-loop safeguards.5097 npm2MIT
- AlicenseCqualityDmaintenanceConnects your Shopify store data to Claude Desktop, enabling access to products, orders, customers, inventory, and more through natural language.152,952 npm4MIT
- AlicenseCqualityDmaintenanceEnables AI assistants like Cursor or Claude Desktop to fully manage a Shopify store using the Model Context Protocol, with tools for products, orders, customers, inventory, discounts, and analytics.32MIT
- AlicenseNot gradedqualityCmaintenanceEnables small shopkeepers to manage inventory conversationally, tracking daily burn rates, predicting stockouts and spoilage, generating supplier-grouped purchase orders, planning reorders under budget constraints, creating near-expiry clearance markdowns, and projecting profit margins.MIT