Available
All workCase study · 03 · Enterprise platform

Six spreadsheets,one source of truth.

Produses runs co-packing, labeling, warehousing, distribution and personnel outsourcing across multiple clients. They needed a single platform that controls production in real time, automates quoting and payroll, and keeps an audit trail every regulator and CFO can read. We built Sistema Fenix.

Client
Produses SA de CV
Industry
Logistics · Co-packing · Outsourcing
Year
2026
Region
El Salvador

Private deployment · demo on request

9+
Modules in production
Real-time
Production tracking
RBAC
Per-row permissions
Audited
Every state change

A glimpse of what we shipped

Internal · production
Operaciones · vista en vivo

Producción · esta semana

Unidades
42,180+8.4%
Personal activo
87+2
Cotizaciones abiertas
12
SLA del mes
98.2%
Throughput por día
meta real
Personal por cliente
  • Cliente A15
  • Cliente B12
  • Cliente C8
  • Cliente D4
Actividad reciente
  • Cotización C-2026-0142 aprobada por finanzas
  • Corrida de planilla quincenal cerrada · 87 comprobantes
  • Asignación diaria publicada · 4 clientes
The challenge

Growth had outrun the spreadsheets — and finance, operations and HR were each running their own.

Production was tracked by hand at the end of each shift. Quotes were a Word template with a calculator. Payroll lived in a separate sheet that nobody trusted on the first try. Each client had different cost structures and outsourcing margins, none of them documented. Anything past 'how did last week go' was an investigation. Audit prep meant a week of cross-referencing. The brief: replace all of it with one system that's still fast on a Tuesday afternoon when twenty supervisors are entering production data at the same time.

Our solution

A modular enterprise platform, shipped iteratively.

Sistema Fenix is a multi-tenant operations platform on Next.js 16 + Supabase + PostgreSQL. Modules launched in order of pain: employees + RBAC first, then production tracking, then client + product catalogs with configurable cost structures, then quoting + invoicing, then outsourcing margins, then PPE inventory, then payroll engine. Row-level security on every table. Audit logs on every state change. Realtime subscriptions so the operations dashboard updates without a refresh. Shadcn + Radix UI for an admin interface that doesn't feel built by engineers.

Key decisions · 06

Built on principles that scale past contact.

// 01

Zero Trust by default

RLS at the DB enforces tenant + role + record-level visibility. The API can be wrong without the DB letting it.

// 02

Audit trail on every state change

Every insert, update and delete writes an audit row with actor, before, after, IP and user agent. Compliance prep is a query.

// 03

Modular monolith

Single deployable, clear module boundaries inside. Faster than microservices for a 30-person ops team, easier to evolve later.

// 04

Configurable cost structures

Each client + service combination defines its own cost model and margin. Quotes generate from the catalog, never by retyping.

// 05

Realtime where it earns its keep

Production dashboards, daily personnel boards and inventory levels update via Supabase Realtime. Everything else is normal SSR.

// 06

Salvadoran payroll, done correctly

ISSS, AFP, rent, deductions, bonuses, vacation, aguinaldo — the engine respects local labor law instead of being a US template translated.

Impact

Operations on real-time control.

  • 6→1

    Spreadsheets retired

    Production, payroll, invoicing, outsourcing margins, inventory and quoting all consolidated into one auditable system.

  • <1d

    Audit prep window

    What used to take a full week of cross-referencing is now a few filtered queries against the audit_log table.

  • Live

    Production visibility

    Supervisors and ops leadership see throughput per client / process / employee in real time. Daily standups skip the recap and start with decisions.

  • 0

    Lost paystubs since launch

    Payroll runs generate signed PDFs into Supabase Storage with versioned history. No more 'I never got my comprobante'.

Tech stack

Modern, opinionated, well-supported.

  • Next.js 16
  • React 19
  • TypeScript
  • Supabase
  • PostgreSQL
  • Row-Level Security
  • Supabase Realtime
  • Radix UI
  • Shadcn UI
  • Tailwind CSS
  • Zod
  • React Hook Form
  • Lucide Icons
  • Geist
  • Docker

Tired of running operations from spreadsheets?

Start a project →
WhatsApp