Back to all days

Day 8 — E-Commerce / Retail

E-Commerce Inventory & Orders

Your Shopify dashboard, but you can talk to it.

An MCP server that connects a DTC beauty brand's product catalog, orders, customers, inventory levels, and sales data to Claude. Ask about your business in plain English.

Example Queries

“What products are running low on stock?”
“Show me all pending orders that need to ship today”
“Who are our VIP customers and when did they last order?”
“What’s our best-selling product this month?”
“Any orders for Maya Thompson?”
“How are skincare sales performing compared to haircare?”

Tools

6 MCP Tools

ToolWhat It Does
product_catalogSearch products — pricing, margins, stock levels, and total sales performance
order_lookupFind orders by number, status, customer, or date — with items, totals, and tracking
customer_insightsCustomer profiles with tier, lifetime value, order count, and recency
inventory_alertsOut-of-stock, low stock, overstocked items, and pending fulfillment count
sales_analyticsRevenue, AOV, top products, category breakdown, and order status distribution
fulfillment_queueOrders awaiting shipment — express first, with overdue flags

Why This Industry

Why E-Commerce?

DTC founders live inside dashboards. Shopify, Google Analytics, Klaviyo, ShipStation — the data exists, but getting a simple answer means clicking through four tabs and running a mental JOIN.

“What's our best-selling product this month?” shouldn't require exporting a CSV. “Which VIP customers haven't ordered in 60 days?” shouldn't require a Klaviyo segment.

This tool answers business questions, not just data questions.

Demo Data

What's Inside

24

Products

20

Customers

36

Orders

6

Categories

Modeled after a DTC beauty brand (Solara). Includes VIP influencer with PR packages, a barbershop owner who bulk orders, a quarterly corporate gifter, out-of-stock sunscreen, overstocked holiday sets, a cancelled order, a refunded order (allergic reaction), and a TikTok-referred first-time buyer.

Setup

Try It Locally

cd day08-ecommerce
npm install && npm run seed && npm run build

Then add the config to Claude Desktop and restart.

Want one for your store?

If you're still exporting CSVs to answer basic business questions, let's fix that.