Meta Ads Lead-Gen Dashboard
Self-hostedPaid ads · Lead generation
A self-hosted dashboard that syncs Meta lead ads, contacts every new lead within minutes and uses a local AI to cut cost per lead.
Wholesale operations · ERP integrationInternal dashboardMalta
Sage & WooCommerce Integration Case Study
An operations platform that joins WooCommerce orders, warehouse work and purchasing to Sage Evolution invoicing and stock.
The brief
A wholesale distributor takes orders through its WooCommerce shop, by phone and at a sales counter, while stock and invoicing live in Sage Evolution. Picking, packing, reservations and purchasing sit between those systems. The goal was one workspace that runs that operational work and keeps Sage as the system of record, built so it can be demonstrated and tested fully before any live system is touched.
What I built
- 01
Designed a modular platform with separately deployable parts: a Next.js interface, an ASP.NET Core REST API with role-based access, a Hangfire background worker and a Windows connector that is the only process allowed to use the Sage SDK.
- 02
Built the order flow from intake through picking, packing, Sage invoicing and dispatch, with explicit states and an exceptions queue for shortages and failed syncs.
- 03
Connected WooCommerce through signed webhooks and its REST API, and Sage through an outbound-polling connector, so the on-premises Sage server opens no inbound ports.
- 04
Wrote every external call through durable inbox/outbox records with idempotency keys, so a failed synchronisation is retried safely instead of lost or duplicated.
- 05
Added a Live Operations Center that moves the business from demo data to read-only imports to live write-back one reversible step at a time.
What the dashboard does
Dashboard
Orders today, the picking queue, stock shortages, documents ready for Sage and integration health at a glance.
Orders
Website, phone and counter orders through validated states, with priorities and an exceptions queue.
Inventory
Physical stock, active reservations and available-to-sell quantities per warehouse, protected against double-booking.
Purchasing
Supplier recommendations from current stock, reservations, incoming deliveries and expected demand events.
Integrations
Sage Evolution, WooCommerce, database and worker health, with test, configure and log actions for each.
Live Operations Center
Business details, connector setup, read-only imports and reconciliation before any live write is enabled.
Inside the system
Result
- One workspace for orders, stock, warehouse tasks, purchasing and integration health, with Sage still the financial system of record.
- Every workflow can be tested end to end against controllable mock services before a live connector is switched on.
Stack
- ASP.NET Core
- Entity Framework Core
- PostgreSQL
- Hangfire
- Next.js
- TypeScript
- Sage Evolution
- WooCommerce
- Podman
Need something like this?
This project draws on the services below. Each page explains how I scope, build and hand over this kind of system.
More work
View all
Onyx Clinic CRM
Tirana, AlbaniaClinic CRM
Clinic CRM for client records, staff calendars, online booking and WhatsApp reminders.
Onyx Hairline CRM
Tirana, AlbaniaStudio CRM
Studio CRM that registers each client with their service and keeps in touch on WhatsApp.