← All releases
core

v1.0.0

  • First production release with full WooCommerce Revenue Report
  • Revenue by channel — 8 channels including a dedicated AI Assistants channel (14 hosts: ChatGPT, Claude, Gemini, Perplexity, Copilot, NotebookLM, Meta AI, Le Chat (Mistral), DeepSeek, You, iAsk, Jasper, Writesonic)
  • Cart-to-purchase funnel — Viewed product → Added to cart → Started checkout → Completed purchase, with per-step conversion rates
  • Top products report, ranked by units and revenue, with refunds applied
  • Zero-touch backfill of historical WooCommerce orders via Action Scheduler on first open of Revenue Report (CLI alternative: `wp statnive woocommerce-backfill`)
  • READ-ONLY against WooCommerce — only `$order->get_*()` getters, never writes to WC tables or post meta
  • Drop-in upgrade from 0.4.x — 5 new tables via `dbDelta`; existing tables and data preserved

First production release — Statnive 1.0.0

The headline of 1.0.0 is the WooCommerce Revenue Report: net revenue, AOV, refund rate, conversion rate, and revenue per visitor — all on one admin page, free, on WordPress.org. Built on WooCommerce 8.5+ Order Attribution; HPOS + Block Checkout compatible.

What’s new

WooCommerce Revenue Report (Reports → Revenue Report)

A dedicated admin page surfacing 5 KPIs and 3 breakdowns. Currency, decimal formatting and timezone are taken from your WooCommerce store settings.

KPIs

  • Orders — count of orders in processing + completed status.
  • Revenue (net)net_total − refund_total (excludes tax and shipping). A Gross: $X helper appears underneath.
  • Average Order Valuenet_revenue / orders.
  • Refund total + Raterefund_total and refund_rate = refunds / gross.
  • Tax + Shipping — combined value, explicitly labelled “Excluded from revenue” so the headline net number is not confused with what WooCommerce calls gross.

Breakdowns rendered in the v1.0.0 UI

  1. Revenue by Channel. Sortable table with Channel · Orders · Revenue · AOV across the 8 channels Statnive groups traffic into: Direct, AI Assistants, Organic Search, Social Media, Email, Referral, Paid Search, Paid Social.
  2. Top Products. Top 10 by default (sortable by units or revenue). Variations are grouped under their parent product. Refunds are applied to the line item.
  3. Cart-to-Purchase Funnel. Four stages, server-side from WooCommerce — no extra JS to install: Viewed product → Added to cart → Started checkout → Completed purchase. Per-step and overall conversion rates displayed alongside session counts.

The internal events that drive the funnel are wc_product_view, wc_add_to_cart, wc_checkout_start, and wc_purchase.

AI Assistants channel — 14 hosts

AI-assistant traffic is its own channel rather than being miscategorized as Direct or Organic. v1.0.0 detects 14 hosts:

  • OpenAI / ChatGPTchatgpt.com, chat.openai.com
  • Anthropic / Claudeclaude.ai
  • Googlegemini.google.com, bard.google.com, notebooklm.google.com
  • Microsoftcopilot.microsoft.com
  • Metameta.ai
  • Mistralchat.mistral.ai (Le Chat)
  • DeepSeekdeepseek.com, chat.deepseek.com
  • Perplexityperplexity.ai
  • Otheryou.com, iask.ai, jasper.ai, writesonic.com

Detection happens before the search-engine classifier, so an AI referral will never be misattributed to “Organic Search”.

Zero-touch backfill

The first time you open the Revenue Report after activating 1.0.0, Statnive enqueues background jobs through Action Scheduler to import historical WooCommerce orders. No setup, no CLI. The status is visible at the top of the Revenue Report while it runs.

For sites where Action Scheduler is unavailable or you want to trigger the import manually:

wp statnive woocommerce-backfill

Chunk size is 500 orders per hook. Counted statuses: processing, completed, refunded.

Three top-level admin pages

The admin navigation collapses to three scoped pages: Overview, Revenue Report, Settings.

v0.4.x analytics preserved

Real-time visitors, channel grouping, geography, devices, languages, and AI source tracking from v0.4.x all carry forward unchanged. Existing tables and stored data are preserved on upgrade.

Privacy + safety

  • READ-ONLY against WooCommerce. Only $order->get_*() getters; Statnive never writes to a WooCommerce table or post meta. Verified empirically with CHECKSUM TABLE before/after on a 1,933-order site.
  • All existing privacy invariants intact — cookieless, daily-rotating salts (CSPRNG, 48-hour overlap window), IP anonymization at ingest (IPv4 last octet zeroed, IPv6 last 80 bits zeroed), GPC + DNT respected server-side, WordPress Privacy API exporter + eraser registered.
  • Opt-in uninstall (default OFF). Reinstalling preserves analytics and revenue history.

Upgrading from 0.4.x

Drop-in upgrade. Five new tables are added via dbDelta; the existing 21 tables and their data are untouched.

The five new tables:

  • wp_statnive_orders — order metadata, attribution snapshot, channel
  • wp_statnive_order_attribution — channel, UTM parameters, referrer host, funnel steps
  • wp_statnive_order_items — line items, products, SKU, refund tracking
  • wp_statnive_order_refunds — refund events with amount and reason
  • wp_statnive_order_coupons — coupon usage per order, discount amounts

On a WooCommerce site the Revenue Report fills in within a few minutes of activation. No code change required.

Get Statnive Free