WooCommerce Power BI ConnectorWooCommerce Power BI Connector
Buy Now
View Demo
  • Getting Started

    • Introduction
    • Quick Start (5 min)
    • Features
    • Installation
    • Azure AD Setup
    • Power BI Account Setup
    • Setup Wizard
  • Configuration

    • Settings
    • Access Control
  • Reports & Alerts

    • Dashboard
    • Reports & Dashboards
    • Alerts
  • Data & Sync

    • Workspaces, Datasets & Tables
    • Sync & Scheduler
    • Data Load Profiles
    • Query Builder
    • Export Center
  • Advanced

    • Logs & Audit Trail
    • REST API & WP-CLI
    • Troubleshooting
    • FAQ
    • Glossary
Support
Buy Now
View Demo
  • Getting Started

    • Introduction
    • Quick Start (5 min)
    • Features
    • Installation
    • Azure AD Setup
    • Power BI Account Setup
    • Setup Wizard
  • Configuration

    • Settings
    • Access Control
  • Reports & Alerts

    • Dashboard
    • Reports & Dashboards
    • Alerts
  • Data & Sync

    • Workspaces, Datasets & Tables
    • Sync & Scheduler
    • Data Load Profiles
    • Query Builder
    • Export Center
  • Advanced

    • Logs & Audit Trail
    • REST API & WP-CLI
    • Troubleshooting
    • FAQ
    • Glossary
Support
  • Getting Started

    • Introduction
    • Quick Start — 5 Minutes
    • Features
    • Installation — Full Setup Guide
    • Azure AD Setup
    • Power BI Account Setup
    • Setup Wizard
  • Configuration

    • Plugin Settings
    • Access Control
  • Reports & Alerts

    • Dashboard
    • Reports & Dashboards (Embedding)
    • Smart Alerts
  • Data & Sync

    • Workspaces, Datasets & Tables
    • Sync & Scheduler
    • Data Load Profiles
    • Query Builder
    • Export Center
  • Advanced

    • Logs & Audit Trail
    • REST API & WP-CLI
    • Troubleshooting
    • FAQ
    • Glossary

Smart Alerts

Alerts notify you via email when an important store metric crosses a threshold — for example, when refund rate spikes above 5%, or when stock for any product drops below 10 units. The plugin evaluates alerts automatically after every sync.

URL: /wp-admin/admin.php?page=wkpbic-alerts

Smart Alerts pageAlerts page — create threshold alerts for sales, orders, AOV, refunds, and stock.


Supported Metrics

MetricDescription
Total SalesSum of order totals over a window
Order CountNumber of orders in a window
Average Order Value (AOV)Sales ÷ Orders
Refund RateRefunds ÷ Orders × 100
Low Stock CountNumber of products below the WC low-stock threshold
Profile CompletionFires on success or failure of any Load Profile
Sync FailureFires when a scheduled sync fails

Condition Types

ConditionExample
AboveSales > $10,000
BelowOrders < 50
BetweenAOV between $40 and $80
Outside RangeAOV outside $40–$80
EqualsOrder Count = 0 (dead store alert)

Creating an Alert

  1. Click + Create Alert on the Alerts page.

  2. Fill in the form:

    FieldDescription
    NameFriendly label, e.g. "High Refund Rate Warning"
    MetricOne of the supported metrics
    Time WindowLast hour / Last 24 hours / Last 7 days / Last 30 days
    ConditionAbove / Below / Between / Outside Range / Equals
    Threshold Value(s)The numeric comparison
    RecipientsComma-separated emails (defaults to the Alert Email in General Settings)
    Email SubjectCustom subject line
    Email BodyCustom body with placeholders like {metric}, {value}, {threshold}, {timestamp}
    Enabled ToggleActive/inactive
    CooldownMinimum minutes between repeat emails to avoid spam
  3. Click Save.

  4. (Optional) Click Test — the plugin sends a sample email and shows the currently calculated value for the metric.


How Alerts are Evaluated

  • After every scheduled or manual sync, the plugin runs a cron job wkpbic_check_alerts.
  • For each enabled alert, it calculates the current metric value over the configured window.
  • If the condition matches, an email is sent (respecting the cooldown) and an entry is written to Logs → Alert History.
  • You can force evaluation manually via WP-CLI:
wp cron event run wkpbic_check_alerts

Alerts Grid

ColumnDescription
NameFriendly label
MetricThe tracked metric
ConditionHuman summary (e.g. "Refund Rate > 5%")
Last TriggeredWhen the alert last fired
Status✅ OK / Triggered / Disabled
ActionsEdit, Test, Enable/Disable, Delete

Alert History

Every fire is recorded in Logs with:

  • Timestamp
  • Metric name
  • Calculated value
  • Threshold
  • Recipients
  • Email delivery status

Example — Refund Rate Alert

  1. Name: "Refund Rate > 5%"
  2. Metric: Refund Rate
  3. Window: Last 7 days
  4. Condition: Above
  5. Threshold: 5
  6. Recipients: [email protected]
  7. Cooldown: 360 minutes (6 hours)

The plugin will now email your ops team at most once every 6 hours whenever the 7-day refund rate exceeds 5%.


Disabling an Alert Temporarily

Rather than deleting the alert, toggle Enabled → Off. The configuration is preserved; you can re-enable it at any time.

Prev
Reports & Dashboards (Embedding)