ecommerce-command-center-mcp

E-commerce Command Center MCP

Core Problem

Multi-channel sellers operate across disconnected dashboards and miss stockouts, listing issues, and shipping failures.

What This Server Provides

This folder contains a production-minded MCP server scaffold with typed JSON tool responses, connector health metadata, OAuth-oriented configuration, rate-limit guards, stable error envelopes, and deterministic demo data until live vendor integrations are attached.

This server has received a production pass. It now includes local ecommerce operations models for multi-channel revenue, inventory coverage, listing health, shipping exceptions, daily operating briefs, restock recommendations, and channel performance comparisons.

Connectors

• Shopify Admin API via OAuth scope read_orders; env prefix SHOPIFY
• Amazon SP-API via OAuth scope sellingpartnerapi::notifications; env prefix AMAZON_SP
• Walmart Marketplace API via OAuth scope marketplace.read; env prefix WALMART
• TikTok Shop API via OAuth scope seller.read; env prefix TIKTOK_SHOP
• ShipStation API via OAuth scope orders:read; env prefix SHIPSTATION
• Inventory Platform API via OAuth scope inventory.read; env prefix INVENTORY
• EasyPost API via OAuth scope shipments.read; env prefix EASYPOST

MCP Tools

• get_multi_channel_revenue - Revenue, orders, margin, refunds, and channel mix.
• get_inventory_alerts - Low-stock, stockout, and overstock alerts.
• get_listing_health - Suppressed listings, buy box loss, policy flags, and severity.
• get_shipping_exceptions - Late, stalled, and exception shipments.
• get_daily_brief - One concise operating brief with priorities.
• get_restock_recommendations - Restock quantities using velocity and lead time.
• compare_channel_performance - Rank channels by margin, growth, fulfilment risk, or revenue.

Current Local Capabilities

• Summarizes revenue, orders, refunds, net revenue, gross profit, AOV, and channel mix.
• Flags stockouts, low-stock SKUs, and overstock cash tied up.
• Reports marketplace listing suppression, buy box loss, policy flags, and severity.
• Finds stalled, delayed, and exception shipments with value at risk.
• Produces a daily operating brief composed from revenue, inventory, listing, and shipping signals.
• Calculates restock quantities from velocity, lead time, and safety threshold.
• Compares channels by margin, growth, fulfillment risk, or revenue.

Test

python -m pytest .\tests -q -p no:cacheprovider

Partial Platform Support

Customers only need to connect the commerce platforms they actually use. Missing Shopify, Amazon, Walmart, TikTok Shop, ShipStation, inventory, or EasyPost credentials do not prevent the server from starting or running local intelligence tools.

Use get_live_connector_status to see configured connectors. Use test_shopify_admin_connection for a read-only live smoke check when Shopify is connected.

Running Locally

powershell python -m venv .venv .\.venv\Scripts\pip install -e . .\.venv\Scripts\python -m ecommerce_command_center_mcp.server

Claude Desktop Config

json { "mcpServers": { "ecommerce-command-center": { "command": "python", "args": ["-m", "ecommerce_command_center_mcp.server"], "cwd": "D:\CUSTOMS\EARNALL\MCP Servers\02-ecommerce-command-center" } } }

Production Checklist

• Create OAuth 2.1 apps for each connector and set *_CLIENT_ID plus *_CLIENT_SECRET.
• Store refresh tokens in a secrets manager, never in repo files.
• Replace deterministic demo rows in server.py with API adapter calls.
• Persist raw snapshots and normalized warehouse tables for trend analysis.
• Add integration tests with recorded fixtures for every connector.
• Validate every tool in MCP Inspector before publishing.
• Deploy with a /health route through FastMCP streamable HTTP on Railway or Render.