VINE: Enterprise Wine Logistics SaaS Platform | Eraaz Tech Case Study

The Challenge

Andreas Larsen operates a growing network of wine wholesale businesses across Scandinavia. Before VINE, each wholesaler managed suppliers, inventory, and distribution through disconnected spreadsheets, email chains, and manual phone calls. This created several critical pain points:

•       No centralized system to manage suppliers, distributors, and inventory across multiple wholesale operations.

•       Stock levels were tracked manually, causing frequent stockouts of high-demand wines and excess inventory of slow movers.

•       Wholesaler managers had no visibility into sales trends, top-performing products, or seasonal demand patterns.

•       No role-based access control meant every staff member had access to everything, creating data integrity and security risks.

•       Scaling to onboard new wholesalers required duplicating infrastructure and processes manually each time.


Andreas needed a single platform that could serve as the operating backbone for his entire wholesale network, with isolation between businesses, automated inventory alerts, and granular role-based permissions.

Our Solution

Eraaz Tech designed and built VINE, a multi-tenant SaaS platform purpose-built for wine wholesale logistics. The architecture supports three distinct user roles, each with scoped access and functionality:

Multi-Tenant Role Architecture

Core Platform Features

•       Supplier Management: Full CRUD with contact details, wine catalog association, and order history tracking per supplier.

•       Distributor Management: Manage distribution partners with region mapping, delivery schedules, and performance metrics.

•       Inventory Management: Real-time stock tracking with bulk update capability, category filtering, and product search. Supports wine-specific metadata (vintage, region, varietal, ABV).

•       Automated Low-Stock Alerts: Configurable threshold-based email notifications to suppliers when stock drops below set levels (e.g., Wine A < 10 units triggers auto-email to assigned supplier).

•       Analytics Dashboard: Interactive sales analytics with weekly, monthly, and yearly views. Highlights top-selling products, revenue trends, and category-level performance breakdowns.

•       Granular Access Control: Admins create sub-admins with task-specific permissions (e.g., only product entry, only supplier management), ensuring data security across teams.

Technology Stack

Layer	Technology
Frontend	React + Vite + TypeScript + Material UI
Backend	NestJS + TypeScript + BullMQ (job queues)
Database	MySQL on AWS RDS
Deployment	AWS EC2 with Docker containers
CI/CD	GitHub Actions (build, test, deploy pipeline)
Email Automation	BullMQ job queues + Nodemailer (threshold-triggered supplier alerts)
Authentication	JWT with refresh tokens + role-based middleware

Implementation Process

The project was executed across four focused phases over 14 weeks:

Phase 1: Discovery & Architecture (Weeks 1–2)

Mapped the full wholesaler workflow with Andreas, defined the multi-tenant data model with strict tenant isolation in MySQL, designed the role hierarchy and permission matrix, and finalized the API contract between frontend and backend.

Phase 2: Core Platform Build (Weeks 3–8)

Built the NestJS backend with modular service architecture: auth module (JWT + refresh tokens + role guards), inventory module with bulk operations, supplier and distributor CRUD with relational mapping, and the BullMQ-powered email automation pipeline for low-stock alerts. The React frontend was built simultaneously with Material UI components, responsive data tables, and the analytics dashboard with chart visualizations.

Phase 3: Analytics & Access Control (Weeks 9–11)

Implemented the sales analytics engine with aggregations across weekly, monthly, and yearly intervals. Built the top-selling products ranking system, category-level filters, and exportable reports. Developed the granular sub-admin permission system allowing admins to scope access per task module.

Phase 4: Deployment & Launch (Weeks 12–14)

Containerized the full stack with Docker, configured AWS EC2 instances with RDS for production MySQL, set up the GitHub Actions CI/CD pipeline with automated builds and deployments, conducted load testing, security audit, and launched with three initial wholesaler tenants onboarded.

Results & Impact

Within the first 90 days of deployment, VINE delivered measurable business impact across all key operational metrics:

•       85% reduction in manual stock tracking — automated inventory monitoring replaced daily spreadsheet reconciliation across all wholesaler operations.

•       3x faster order processing — integrated supplier and distributor workflows eliminated manual coordination bottlenecks.

•       60% fewer stockout incidents — threshold-based automated supplier emails ensured replenishment orders were triggered before stock depletion.

•       40% lower operational overhead — centralized platform replaced multiple disconnected tools, reducing software costs and training time.

•       Zero-downtime onboarding — multi-tenant architecture allows new wholesalers to be provisioned and operational within hours, not weeks.