Project Overview
Gulf Atlantic Seafood is a high-volume wholesale importer and distributor managing millions of pounds of inventory through warehouse and drop-ship operations. As the business grew, spreadsheet-driven workflows and legacy cost calculations created significant operational inefficiencies and inaccurate profitability reporting. We developed a modern ERP-style operations platform that centralizes purchasing, receiving, inventory tracking, sales management, invoicing, receivables, payables, and financial reporting. The system introduced a FIFO-based landed cost engine, lot-level traceability, and advanced operational dashboards that ultimately revealed a hidden 20-point margin discrepancy across $29M in revenue. The result is a scalable, accuracy-first platform that provides complete visibility into inventory movement, financial performance, and operational workflows while supporting future business growth.
Overview
Key Challenges
Gulf Atlantic relied on disconnected spreadsheets, email threads, and legacy inventory systems that created inaccurate cost calculations, fragmented operational visibility, and difficult financial reconciliation processes. Weighted-average costing distorted profitability, drop-ship orders lacked proper cost attribution, and inventory, receivables, payables, and purchasing data existed across multiple disconnected systems.
Our Solution
We designed and developed a custom operations platform that unifies purchasing, receiving, inventory management, sales, invoicing, receivables, payables, and reporting into a single system. The platform introduced a FIFO-based landed cost engine, lot-level inventory traceability, role-based access controls, and advanced financial reporting, ultimately uncovering a hidden margin discrepancy of nearly 20 percentage points across $29M in revenue.
Gallery
Visual transformation showcasing the dramatic improvements across all interfaces
Detailed Solution
A) Building an Integrated Ecosystem
- A Slack app that worked seamlessly within channels and threads.
- A modern dashboard for admins to manage users and track engagement.
- A high-performance marketing website designed to convert and communicate value clearly.
B) Agile Delivery in 10 Weeks
The project was broken into 2-week sprints covering planning, development, QA, and deployment. Early wireframes and clickable prototypes were created to validate the UX upfront.
C) User-First UX + Real-Time Feedback
We used Slack’s Block Kit and interactive modals for a frictionless in-app experience. The admin dashboard allowed real-time updates, and the website optimized lead generation through responsive forms and SEO-ready design.
D) Compliance and Approval
We used Slack’s Block Kit and interactive modals for a frictionless in-app experience. The admin dashboard allowed real-time updates, and the website optimized lead generation through responsive forms and SEO-ready design.
E) End-to-End Ownership
From stakeholder interviews to CI/CD to Slack Marketplace listing, the Gaincafe team took ownership of the full product lifecycle.
Implementation & Infrastructure
A modern ERP-style operations platform built for wholesale distribution, combining inventory management, purchasing, sales, finance, and advanced cost accounting in a unified architecture.
Operations Platform Architecture
The platform was built using React, TypeScript, and Supabase with a centralized PostgreSQL database. Purchasing, receiving, inventory, sales, receivables, payables, and reporting modules operate on a shared data model, providing complete visibility across the business.
Core Technical Decisions
- FIFO landed cost engine replacing weighted-average costing
- Lot-level inventory tracking and traceability
- Role-based access control using Supabase RLS
- Server-side reporting through PostgreSQL RPC functions
- Version-controlled database migrations
- Parallel dashboard validation before production rollout
Layered System Architecture
A structured enterprise architecture designed for inventory-intensive distribution operations.
Operations Layer
- Purchase Orders
- Receiving & Freight Allocation
- Inventory Transfers
- Sales & Drop-Ship Orders
Business Logic Layer
- FIFO Cost Attribution Engine
- Margin Calculation Services
- Receivables & Payables Processing
- Role-Based Authorization
Data & Reporting Layer
- PostgreSQL Database
- Supabase RLS Security
- Operational Reporting
- Financial Analytics Dashboard
Performance & Scalability
- Server-side aggregations using PostgreSQL RPCs
- Optimized reporting across millions of pounds of inventory history
- Centralized architecture eliminating spreadsheet dependencies
- Scalable React + Supabase platform
Security & Operational Integrity
- Row-Level Security across operational data
- Dedicated user_roles authorization model
- Security-definer role validation functions
- Versioned migrations for safe production deployments
"The new platform transformed how Gulf Atlantic manages inventory, purchasing, and financial operations while uncovering critical margin inaccuracies hidden within legacy systems."
Operations Team
Gulf Atlantic Seafood