Partner
Agilico GmbH
All projects
Case study01
Agilico Media Workflow Platform
An end-to-end platform for media price lists, quotations, publication planning and production-ready ad orders
Media & AdvertisingAgilico GmbH
Industry
Media & Advertising
Core technologies
Next.js · Express · PostgreSQL
Project work
From requirements to a resilient solution.
A concise look at the context, implementation and technical decisions behind the project.
Starting point
DuoByte built an end-to-end platform for Agilico that digitizes the complex workflow from media price list to booked and production-ready advertisement. Instead of manually transferring data between heterogeneous publisher PDFs, quotations, calendars and third-party systems, the platform brings print and digital products into one operational workspace.
Implementation
An automated import monitors publisher sites, classifies new price lists and extracts prices, formats, circulation data, discounts and surcharges into structured product records. Teams then create quotations with customer and agency contacts, synchronize offers with Bexio, and schedule print and digital placements in calendars and exportable publication plans.
Quality & operations
A public German- and French-language ordering flow guides customers from ad template, image editing and format selection to secure Stripe payment, while the server generates print-ready PDF/X-4 files with color profiles, bleed boxes and embedded fonts. The role-based Next.js and Express application connects PostgreSQL, Prisma, OpenAI-assisted document analysis, Microsoft sign-in, Bexio, Stripe and automated Docker deployments in a maintainable platform for daily media operations.
System architecture
A technical foundation with a clear structure.
Technologies were combined to suit the task, operating model and long-term maintainability.
Frontend
Next.js 16React 19TypeScriptTailwind CSSshadcn/ui
Backend
ExpressTypeScriptPrismaZodREST API
Database
PostgreSQL
AI & Analytics
OpenAI APIPythonPyMuPDFpdfplumber
Integrations
Bexio APIMicrosoft SSOMicrosoft Graph
Payments
Stripe CheckoutStripe TaxWebhooks
Infrastructure
Docker ComposeCaddyGitHub ActionsPlaywrightGhostscript
Keep exploring
Next case study
EHR Backend Development
Your project
Turn a complex challenge into a clear next step.
Tell us what your system needs to do. We bring structure to requirements, architecture and delivery.