WooAnalytics Pro is a comprehensive analytics plugin for WooCommerce that surfaces the business intelligence a serious store operator needs, but WooCommerce's built-in reports don't provide. WooCommerce natively shows revenue and order counts; it does not calculate profit, does not segment customers by value, and does not generate actionable recommendations.

The plugin introduces five distinct analytics modules as dashboard tabs: a KPI Dashboard with trend charts, a Profit Engine that calculates true margin after cost-of-goods-sold, a Customer Analytics module with RFM (Recency-Frequency-Monetary) segmentation, an AI Insights tab powered by Anthropic Claude, and an Email Reports module for scheduled delivery of summaries to team inboxes.

Performance is a first-class concern. All KPIs are pre-computed via a nightly background aggregation job using Action Scheduler, writing to a dedicated wap_daily_stats table. The dashboard page loads read from this pre-computed table rather than running expensive live queries on wp_posts and wp_postmeta. This architecture supports stores with 100,000+ orders without degrading dashboard load times.

The plugin reads WooCommerce data exclusively; it never writes to WooCommerce tables. All custom data (daily stats, product costs, customer segments, AI insights, and email report configs) is stored in five dedicated tables with the wap_ prefix, keeping the WooCommerce data layer untouched and the plugin fully uninstallable without residual effects.

KPI Dashboard

•       Revenue (gross and net), orders, average order value, refund rate: daily and period-over-period

•       Trend charts: 7-day, 30-day, 90-day, and custom date range

•       Top products by revenue, top products by order volume

•       New vs returning customer ratio

•       Hourly order heatmap (identifies peak trading hours)

•       Pre-computed from wap_daily_stats: instant load on any store size

Profit Engine

•       Per-product COGS (cost of goods sold) input: bulk import via CSV or per-product inline editor

•       True profit margin calculation: (revenue - COGS - refunds) / revenue

•       Profit ranking table: all products sorted by margin %

•       Loss-leader detection: products with negative effective margin flagged

•       COGS vs revenue chart: visual breakeven line

•       Profitability by category aggregate view

Customer Analytics & RFM Segmentation

•       RFM scoring for all customers: Recency (days since last order), Frequency (number of orders), Monetary (lifetime spend)

•       Automatic segment assignment: Champions, Loyal Customers, Potential Loyalists, At Risk, Hibernating, Lost

•       Segment distribution chart and customer list per segment

•       Customer lifetime value (LTV): historical and projected

•       Repeat purchase rate and average days between orders

•       Churn risk indicator: customers who haven't ordered in 2× their average reorder interval

•       Customer CSV export (full list with LTV + segment + last order date)

AI Insights (Anthropic Claude)

•       Claude analyses aggregated store KPIs and returns 3–5 prioritised, actionable recommendations

•       Insight categories: pricing strategy, inventory, customer retention, marketing timing

•       Insights cached for 24 hours to minimise API token usage

•       User-supplied Anthropic API key: no markup, no subscription

•       Insight history: view previous AI analyses and compare over time

Automated Email Reports

•       Weekly or monthly scheduled reports sent to a configurable recipient list

•       Report contents: revenue, orders, new customers, top 5 products, trend summary

•       HTML-formatted email with inline charts (base64 encoded chart images)

•       Test send button: preview report before scheduling

•       Send day and time configurable (reports fire at 08:00 on chosen day)

•       CSV attachments: products (with COGS + margin) and customers (with LTV + segment)

Architecture & Performance

•       5 custom DB tables: wap_daily_stats, wap_product_costs, wap_customer_stats, wap_ai_insights, wap_email_reports

•       Nightly aggregation job via Action Scheduler (runs 02:00 store local time)

•       Weekly customer segment refresh via Action Scheduler

•       5-minute transient cache on all REST endpoints

•       Zero writes to WooCommerce core tables (wp_posts, wp_postmeta, wp_wc_order_*)

•       HPOS (Custom Order Tables) compatible: reads from both legacy and HPOS order storage

User Guide Woo StoreAnalytics Pro