Documentation/tools reference

Reports

Free

Sales reports, top sellers, revenue trends, and stock alerts.

Reports power the "ask anything" analytics use case. Basic reports are Free; advanced period-based analytics require Pro.

store_mcp_report_sales

Total sales for a period.

Tier: Pro (basic totals available on Free via store_mcp_get_totals)

Parameters

ParameterTypeRequiredDefaultDescription
periodstringnoweekday, week, month, year, custom
date_minstringnoStart date (required if period: custom)
date_maxstringnoEnd date (required if period: custom)
comparebooleannofalseAlso return the previous period for comparison
group_bystringnodayhour, day, week, month

Example prompt

"Compare this week's revenue to last week, grouped by day."

Example response

{
  "success": true,
  "data": {
    "period": "week",
    "total_sales": "8412.30",
    "net_sales": "7210.00",
    "orders": 142,
    "items_sold": 389,
    "average_order_value": "59.24",
    "currency": "USD",
    "by_day": [
      { "date": "2026-04-08", "total": "980.50", "orders": 18 },
      { "date": "2026-04-09", "total": "1104.00", "orders": 22 }
    ],
    "comparison": {
      "period": "2026-04-01 to 2026-04-07",
      "total_sales": "7122.90",
      "delta_pct": 18.1
    }
  }
}

store_mcp_report_top_sellers

Best-selling products by units sold.

Tier: Free

Parameters

ParameterTypeRequiredDefaultDescription
periodstringnomonthweek, month, year, custom
date_minstringnoStart date
date_maxstringnoEnd date
limitintegerno10Max rows

Example response

{
  "success": true,
  "data": [
    { "product_id": 4371, "name": "Agua Mineral 750ml", "quantity": 234 },
    { "product_id": 4108, "name": "Tiramisú Dolceria Alba", "quantity": 189 },
    { "product_id": 3992, "name": "Huevo Pascua Baci", "quantity": 156 }
  ]
}

store_mcp_report_top_earners

Highest-grossing products by revenue.

Tier: Pro

Same parameters as top sellers but returns revenue per product.

store_mcp_report_low_stock

Products with stock below a threshold.

Tier: Free

Parameters

ParameterTypeRequiredDefaultDescription
thresholdintegerno10Alert threshold
limitintegerno50Max rows

Example prompt

"Which products have fewer than 5 units in stock?"

store_mcp_report_customer_ltv

Customer lifetime value and cohort analysis.

Tier: Pro

Parameters

ParameterTypeRequiredDefaultDescription
cohort_bystringnomonthweek, month, quarter
limitintegerno20Top customers to return