Apulia Power

Database-first CRM for an energy & utilities reseller

A full bespoke CRM for an energy/utilities reseller managing thousands of supply points (POD/PDR) across multiple stores and administrators — built database-first, with GoHighLevel kept in sync in the background.

What we built

✓Database-first architecture: Supabase is the source of truth, mutations queue and sync to GoHighLevel with retry/backoff — fast UI that never blocks on the CRM API.
✓Bulk import pipeline for the client’s daily Excel exports (supply points, administrators, switch-outs), auto-skipping report preambles and normalizing stores.
✓Per-administrator commission engine: per-POD 6-month cycles anchored on the supply start date, a configurable payment rule (supply start, or +30 days), advance payments and forward-only billing.
✓Switch-out handling that stops commissions from the real execution date without clawing back the already-paid semester.
✓Stores module with per-store supply-point counts over any date range, plus a payments view (next payment, due/overdue, mark-paid).
✓Performance pass: RPC-backed aggregates, partial indexes and optimistic inline editing.

Screenshots

Want something like this for your agency?

Invite-only · contact us to get set up.