FORMAFORCE — monthly revenue widget
WordPress plugin — live revenue and leaderboard dashboard for a sales team
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.
1.2.3
Version
15
Aggregator call sites unified
1,800 €
Under-counted revenue fixed
Challenge
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.
Solution
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 all 15 aggregator call sites, fixing a bug that had silently deleted 1,800 € 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.
Stack
- WordPress
- Google Sheets API
- Ringover API
- REST API