Dokumentation | warenquelle

Architecture Authentication Tools Reference

get_revenue

GET api.warenquelle.store/mcp/revenue.php

Returns order count and gross/net revenue for a given date range.

Parameters

Parameter	Type	Required	Description
`from`	string	Yes	Start date `YYYY-MM-DD`
`to`	string	Yes	End date `YYYY-MM-DD`

Example response

{
  "merch_uuid": "OELMAA",
  "market_uuid": "CH001",
  "period": { "from": "2026-05-01", "to": "2026-05-31" },
  "revenue": [
    {
      "order_count": "12",
      "revenue_gross": "1840.00",
      "revenue_net": "1520.00"
    }
  ]
}

get_orders

GET api.warenquelle.store/mcp/orders.php

Returns a list of orders with customer address. Filterable by status or customer name/email.

Parameters

Parameter	Type	Required	Description
`status`	string	No	`placed` · `shipped` · `approved` · `cancelled`
`customer`	string	No	Name or email (partial match)
`limit`	integer	No	Max results (default 50, max 100)

get_customers

GET api.warenquelle.store/mcp/customers.php

Returns customer statistics and top buyers by revenue for a given period.

Parameters

Parameter	Type	Required	Description
`period`	string	Either/or	`last7days` · `last30days` · `last90days` · `thismonth` · `lastmonth`
`from`	string	Either/or	Start date `YYYY-MM-DD`
`to`	string	Either/or	End date `YYYY-MM-DD`

get_order_items

GET api.warenquelle.store/mcp/order_items.php

Returns order line items with product name and customer info. When filtering by product or SKU, also returns a top_buyers aggregation.

Parameters

Parameter	Type	Required	Description
`product`	string	No	Product name (partial match)
`sku`	string	No	Exact SKU
`limit`	integer	No	Max results (default 100, max 500)

get_stock

GET api.warenquelle.store/mcp/stock.php

Returns current warehouse stock levels calculated from inventory movements (inventory_IN – inventory_OUT via v_merchant_stock view).

Parameters

Parameter	Type	Required	Description
`product`	string	No	Product name (partial match)
`sku`	string	No	Exact SKU
`low`	integer	No	Only products with stock ≤ this value
`sort`	string	No	`asc` (low first) · `desc` (high first)
`limit`	integer	No	Max results (default 100, max 500)