FORMAFORCE: monthly revenue widget
A WordPress dashboard plugin reading FORMAFORCE's sales data straight from Google Sheets: a monthly revenue total, a top-performer leaderboard, and Ringover call correlation, on top of the same team's automation pipeline.
- CRM & automation
- WordPress plugin: live revenue and leaderboard dashboard for a sales team
- 2026
Problem
The revenue total had to net refunds correctly instead of dropping them, dedupe re-synced spreadsheet rows without deleting a real sale, and expose the cache-clear route without leaking the sync token that had been sitting in the plugin's own git history.
System
Refund amounts are now netted into the revenue total across every render and auto-refresh path that computes it; deduplication was moved to a single choke point shared by every aggregator call site, fixing a bug that had silently deleted over 1,500 € of real bookings; and the cache-clear REST route now checks the sync token with a constant-time comparison instead of a plain string match.
Built with: WordPress, Google Sheets API, Ringover API, REST API
Result
- 10+ aggregator call sites unified.
- Under-counted revenue fixed: 1,500+ €.