# eCellar MCP by usefulapi

> eCellar MCP by usefulapi is an MCP server. Read orders, customers, club and stock; add tracking, mark shipped and adjust stock in eCellar. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Website:** https://usefulapi.io/ecellar/
- **Repository:** https://github.com/m190/usefulapi-mcp/tree/HEAD/servers/ecellar
- **MCP Registry name:** io.usefulapi/ecellar
- **Listing updated:** 2026-11-13

## About

Read orders, customers, club and stock; add tracking, mark shipped and adjust stock in eCellar.

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http ecellar https://ecellar.usefulapi.io/mcp
```

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://ecellar.usefulapi.io/mcp
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "ecellar": {
      "url": "https://ecellar.usefulapi.io/mcp"
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "ecellar": {
      "type": "http",
      "url": "https://ecellar.usefulapi.io/mcp"
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "ecellar": {
      "serverUrl": "https://ecellar.usefulapi.io/mcp"
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "ecellar": {
      "type": "http",
      "url": "https://ecellar.usefulapi.io/mcp"
    }
  }
}
```

## Tools

- `ecellar_get_reference_data`: Lookup lists of the winery's eCellar account: brands = brands (brand_key + name); locations = locations (location_id, name, timezone); customer_types = customer types; customer_sources = customer sources; customer_tags = customer tags; order_tags = order tags (tag groups and tags); reservation_types = reservation types; terminals = POS terminals; billing_statuses = billing statuses (enum values fo
- `ecellar_search_customers`: Customers (club members and buyers) with contact details, type, source, tags, email consent and default addresses. Personal data: use only what the task needs. POST /customers.
- `ecellar_search_addresses`: Customer billing and shipping addresses. POST /addresses.
- `ecellar_search_notes`: Notes on customer records (type, text, dates). POST /notes.
- `ecellar_search_orders`: Orders (web, POS, club and phone) with totals, status, billing and shipping details, and their lines, payments, tracking records and tags. Statuses are the enum values from ecellar_get_reference_data purchase_statuses / billing_statuses. Contains customer personal data. POST /orders.
- `ecellar_search_order_lines`: Order lines (product, SKU, quantity, price, discount, tax) across orders. POST /orders/lines.
- `ecellar_search_order_payments`: Order payments (amount, type, billing status, dates, card brand, last digits and expiry; no card numbers). POST /orders/payments.
- `ecellar_search_order_trackings`: Carrier tracking records of orders (carrier, tracking number, shipped and delivered dates). POST /orders/trackings.
- `ecellar_search_products`: Products (wines and merchandise): name, SKU, price, vintage-related fields, categories and inventory SKUs. POST /products.
- `ecellar_search_product_categories`: Product categories (tree: parent_category_id, category_id, name). POST /products/categories.
- `ecellar_get_inventory_counts`: Current inventory per SKU and location: on_hand, on_hold, invoiced and available. Filter by SKUs and/or locations (ids or names from ecellar_get_reference_data locations); with no filter every SKU and location is returned. POST /inventory/counts.
- `ecellar_search_club_subscriptions`: Wine club subscriptions of customers: tier, signup/cancel/hold dates, billing and shipping address, card brand, last digits and expiry (no card numbers). POST /subscriptions.
- `ecellar_search_club_tiers`: Wine club tiers (id, name, description, brand). POST /club/tiers.
- `ecellar_search_club_events`: Club events / shipments (name, date, ship group, tier, pickup location, product totals, remix window). POST /club/events.
- `ecellar_search_reservations`: Tasting-room and experience reservations (party, times, status, host, notes, contact phone and email). POST /reservations.
- `ecellar_mark_order_shipped`: WRITE: set the shipped date and status of ONE order, to be used when ALL its packages have shipped. eCellar refuses it unless the order status is EXPORTED, HOLD_SHIP, SHIPPED, TO_PICKUP or UNSHIPPED, the date is not before the order date, and the date matches the latest tracking ship date. Check the order and its tracking records first. PATCH /order/{order_id}/shipped.
- `ecellar_mark_order_delivered`: WRITE: set the delivered date and status of ONE order, to be used when ALL its packages were delivered. eCellar refuses it unless the order status is DELIVERED or SHIPPED and the date matches the latest tracking delivered date. PATCH /order/{order_id}/delivered.
- `ecellar_add_order_tracking`: WRITE: add a carrier tracking record (carrier + tracking number, optional shipped/delivered dates) to ONE order. Adds a record each call; a duplicate tracking number on the same order is refused by eCellar. Get carrier_enum from ecellar_get_reference_data carriers. POST /order/{order_id}/tracking.
- `ecellar_adjust_inventory_count`: WRITE: change the on-hand count of ONE SKU at ONE location by a signed amount (+12 adds, -3 removes; it is a delta, not a new total, so repeating it repeats the change). Pass location_id or location_name; eCellar refuses an unknown or ambiguous location, a SKU that is not at that location, or a result below zero. Check ecellar_get_inventory_counts first. PATCH /inventory/counts/{SKU}.

## FAQ

### How do I add eCellar MCP by usefulapi to Claude Code?

Run this command in your terminal: claude mcp add --transport http ecellar https://ecellar.usefulapi.io/mcp

---
Source: https://ai-powered.com/mcp/ecellar-mcp-by-usefulapi
