Skip to content
MCP server

eCellar MCP by usefulapi

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

Install
Runs
Remotely
Version
1.5.0
Listing updated
4 days ago

About eCellar MCP by usefulapi

eCellar MCP by usefulapi is an MCP server. It runs as a hosted remote server, so there is nothing to install locally.

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

Install

Run in a terminal

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

Add to Settings → Connectors → Add custom connector

https://ecellar.usefulapi.io/mcp
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "ecellar": {
      "url": "https://ecellar.usefulapi.io/mcp"
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

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

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

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

Tools this server provides (19)

Read directly from the server.

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

eCellar MCP by usefulapi 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