Skip to main content
Glama

PO Pilot MCP (po-pilot-mcp)

npm v1.0.0 Get Solo Kit ($49) Get Agency 10-Store ($249) Hosted Cloud ($0 / $29) Glama Grade A License: MIT

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.0

Option 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

calculate_replenishment_plan

Margin-weighted ABC classification, stockout-adjusted daily velocity, Z-score safety stock, and reorder points

skus[], inventory_csv, use_live_shopify, demo_mode, service_level, review_period_days

Per-SKU abc_class, inventory_position, safety_stock_units, reorder_point_units, recommended_order_units, stockout_risk

readOnlyHint: true, idempotentHint: true

build_supplier_purchase_orders

Groups SKUs per vendor, rounds cartons, enforces vendor MOQs, computes US tariff + freight landed cost, enforces Open-to-Buy (max_cash_budget_usd) cash caps, and emits Shopify PO + POS Transfer CSVs

Same as above + supplier_rules[], po_prefix, max_cash_budget_usd, default_import_duty_pct, min_gross_margin_pct

Per-vendor shopify_draft_po_csv, shopify_transfer_import_csv, total_landed_cost_usd, otb_summary, vendor_email_markdown

readOnlyHint: true, idempotentHint: true

reconcile_po_three_way_match

Accounts Payable 3-way match comparing PO vs warehouse receiving vs supplier invoice + accounting CSV export

po_number, vendor, invoice_number, invoice_date, due_date, po_lines[], receiving_lines[], invoice_lines[], agreed_freight_cap_usd, demo_mode

payment_recommendation, verified_payable_amount_usd, total_overcharge_recovered_usd, quickbooks_bill_csv, xero_bill_csv, debit_memo_email_markdown

readOnlyHint: true, idempotentHint: true

migrate_stocky_csv_snapshot

Rebuilds supplier profiles, real lead-time averages/std-dev, and carton multiples from Stocky PO CSV exports

stocky_po_csv, demo_mode

profiles[], ready_supplier_rules_json[], suppliers_recovered, skus_recovered

readOnlyHint: true, idempotentHint: true


Deterministic Math Under the Hood

  1. Inventory Position (prevents double-ordering while stock is in transit): $$\text{IP} = \text{OnHand} + \text{OnOrder} - \text{Committed} - \text{Backorders}$$

  2. 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})}$$

  3. 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.

  4. 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_TOKEN remain 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 POST queries solely for read operations (productVariants and orders) and enforces a strict 15-second AbortSignal timeout.

  • Crash-Proof Error Envelopes: Invalid CSV headers, missing parameters, or network timeouts return structured MCP isError: true responses with remediation steps instead of terminating the stdio process.

  • Zero Known Dependency Advisories: Verified clean under npm audit.


Pricing & Entitlements

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 deploy

See 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 tools
build_supplier_purchase_ordersBuild MOQ-Compliant Supplier POs, Landed Costs, OTB & Shopify PO/Transfer CSVsA
Read-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 PointsA
Read-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 CSVA
Read-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)A
Read-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

    A4/5.0

    Scored across 4 tools

    Disambiguation4/5

    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.

    Naming Consistency5/5

    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.

    Tool Count5/5

    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.

    Completeness4/5

    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

    ActivityMaintained
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      B
      quality
      C
      maintenance
      Multi-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.
      50
      97 npm
      2
      MIT
    • A
      license
      C
      quality
      D
      maintenance
      Enables 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.
      32
      MIT
    • A
      license
      Not graded
      quality
      C
      maintenance
      Enables 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