woocommerce-whisperer
Provides read-only access to WooCommerce store analytics, enabling queries for revenue, top products, pending orders, top customers, and refunds via AI agents. Developers and store managers use it to fetch e-commerce metrics programmatically. Applications include dashboard integrations and automated reporting.
Overview
The WooCommerce Whisperer MCP server delivers read-only analytics from WooCommerce stores. It supports natural language queries through AI agents to retrieve metrics such as revenue totals, top-selling products, pending orders, leading customers, and refund data. This enables integration of store insights into custom applications without direct database access.
Key Capabilities
- query_revenue: Fetches total revenue, time-based breakdowns, and comparisons across periods.
- top_products: Lists highest-revenue or most-ordered products with sales volumes and trends.
- pending_orders: Retrieves details on unfulfilled orders, including customer info and order values.
- top_customers: Identifies customers by lifetime value, recent purchases, or order frequency.
- refunds: Queries refund amounts, reasons, and associated products or orders.
These capabilities operate in a read-only mode, ensuring store data integrity while allowing AI-driven analysis.
Use Cases
- A developer builds a custom dashboard by querying top_products and query_revenue to display real-time sales trends in a React app.
- Store managers use pending_orders via AI agents to generate daily reports on fulfillment status sent to Slack.
- Analysts query top_customers and refunds to analyze churn patterns and export data to Google Sheets for deeper review.
- E-commerce agencies integrate query_revenue into client portals for automated monthly performance summaries.
Who This Is For
E-commerce developers integrating WooCommerce data into apps, store owners monitoring operations via AI queries, data analysts extracting metrics for BI tools, and agencies building client analytics without custom plugins.