Country:
Industry:18 flagship deployments shown
USA · Round Rock, TXProtein & Food Processing

Colinas Foods / Colinas Products

11-App Unified Cloud Ecosystem Built Alongside Live MS Access & SQL Server

Baseline: MS Access 2003 + SQL Server
Sapi Stack: Next.js 16 + Node.js PWA + RFID + WhatsApp AI + SQL Server

Challenge: Operations across cutting, marination, dehydration, freezer storage, DSD delivery, procurement, and customer portals outgrew desktop-only Access workstations without being able to pause daily USDA production.

Solution: Deployed 11 specialized cloud modules over the single source-of-truth SQL Server: HACCP Jerky Batch Tracker, Glove-Ready Warehouse Scanner PWA, MFA Customer Portal, Procurement & AP Matching, RFID FLSA Time Clock, Driver POD App, MotivBoard, CEO BI Cockpit, and a WhatsApp/PDF AI Order Bot.

11 Production Apps Live
Zero Access Disruption
3-Room HACCP Traceability
WhatsApp PO Auto-Drafting
USDA HACCPGS1 Barcode PWARFID AttendanceWhatsApp AISQL Server
USA · Texas & Multi-StateCommercial Insurance & MGAs

Platinum MGA

Zero-Parity-Loss Modernization of Commercial Trucking Raters & Policy Cloud

Baseline: MS Access 2003 (.mdb/.mde) + SQL Server + VBA Raters
Sapi Stack: Next.js Cloud ERP + Prisma + Native DOCX/PDF Binder Engine + S3

Challenge: Decades of proprietary underwriting math across Cargo, Auto Liability, General Liability, and Long Haul raters—plus >255-column SQL schemas and ACORD/carrier DOCX binders—blocked scaling and browser access.

Solution: Engineered a full Next.js Cloud MGA ERP verified via automated parity test suites against legacy VBA/SQL calculations, complete with QQF quoting, native DOCX/PDF binder stamping, ID cards, LexisNexis integration, and Trillion loss-run sync.

4 Specialty Trucking Raters
Automated DOCX/PDF Binders
14-Dimension Parity Verified
Live Multi-State Cloud
MGA PASCommercial TruckingCargo / AL / GL RatersPDF/DOCX Binders
Mexico · Monterrey, NLHeavy Steel & Industrial Mfg

PIASA — Procesadora Industrial del Acero

SmartFab Web Cloud MES for Siemens Energy, Metso & Ternium Steel Fabricator

Baseline: SapiERP (Access 2003) + 15.2 GB SQL Server + 21-Sheet .xlsm Macro Book
Sapi Stack: React / Tailwind Web MES + Rugged QR Floor Tablets + SQL Server

Challenge: Fabricating heavy heat exchangers, pressure vessels, and ductwork caused 24–48 hour shop-floor paper delays, OneDrive Excel locks, late budget-hour alerts, and unbalanced 48.1% overtime across 76 technicians.

Solution: Designed PIASA SmartFab Web Cloud preserving the 15.2 GB SQL Server database while adding a 39-milestone work-order cockpit, 3D CAD viewer, rugged tablet QR digital travelers, 80/90/100% labor burn alerts, and CNC Ikegai / crew heatmaps.

15.2 GB SQL Preserved
39 Fabrication Milestones
76-Tech Capacity Heatmap
QR Machine-Side Capture
SmartFab MESQR TravelersHeavy SteelCAD 3DSQL Server
USA · TexasCommercial Insurance & MGAs

Streamline Insurance & Stream-X

Next.js 16 + Prisma 7 Monorepo Agency Management System on Live SQL Server

Baseline: Access 2003 + StremIns SQL Server
Sapi Stack: Next.js 16 + Turborepo + Prisma 7 + SQL Server + AWS S3

Challenge: Managing retail and wholesale trucking policies, USDOT/FMCSA schedules, endorsements, commissions, and ACORD documents required multi-user browser scale without migrating away from trusted SQL Server records.

Solution: Architected the Stream-X Turborepo monorepo backed directly by StremIns SQL Server, unifying policy administration, driver/vehicle schedules, automated ACORD/PDF document workflows, and role-gated agency portals.

Turborepo Next.js 16 Stack
Live StremIns SQL Parity
USDOT Fleet Schedules
RBAC Security Gates
Agency ManagementNext.js 16Prisma 7FMCSA / USDOTACORD
Mexico · Monterrey, NLFood Mfg, DSD & Cross-Border Trade

Welita Chila & MonteMaíz (Molino del Norte)

Dual-Company ERP, Circular BOM Costing, Driver App & Sunday CFDI 4.0 Automation

Baseline: MS Access 2003 + 295-Table SQL Server
Sapi Stack: Turborepo Web/API + Dual-DB Switcher + /chofer Mobile + SAT FIEL XML + IoT

Challenge: Operating two legal entities supplying 22 Grupo Ramos supermarket stores 363 days/year demanded circular tortilla-to-totopo waste costing, FIFO flour sacks, 5:30 AM route delivery proof, and Sunday 0% IVA CFDI stamping.

Solution: Delivered a single multi-company ERP with instant database isolation, WhatsApp store×SKU demand elasticity matrix, FIFO flour costing, mobile `/chofer` ticket-photo app, 1-click Sunday CFDI 4.0 + PDF packet builder, and SAT e.firma XML reconciliation.

363-Day Route Operation
295 SQL Tables Unified
Sunday 1-Click CFDI 4.0
SAT e.firma XML Sync
Multi-Entity ERPCFDI 4.0 & SATDriver Mobile AppCircular BOMIoT / OEE
Mexico · Monterrey, Escobedo, Celaya & San Antonio, TXAutomotive & Industrial Mfg

Johnson Controls (JCI)

Multi-Plant SCADA Integration & IRIS Supplier Quality Across 8 Plants + 4 CEDIS

Baseline: Plant Shop-Floor Spreadsheets & Isolated Quality Logs
Sapi Stack: SCADA Bridge + IRIS (SMRR / DMR / SCB / 4D-8D) + SQL Server

Challenge: Coordinating supplier material rejections (SMRR), discrepant deliveries (DMR), supplier chargebacks (SCB), and 4D/8D problem-solving across 8 manufacturing plants, 4 distribution centers, and 1 central warehouse.

Solution: Built IRIS (Issue Resolution Information System) connecting plant quality managers, purchasing, and distribution centers—alongside dedicated plant SCADA and MSA deployments across Escobedo, Monterrey, Celaya, Ciénega, and San Antonio.

8 Plants + 4 DCs Connected
SMRR / DMR / Chargebacks
4D & 8D Root-Cause Workflows
US & Mexico Plant SCADA
Fortune-Scale Mfg8D QualitySCADAMulti-PlantSupplier Chargebacks
Australia · Queensland, AustraliaLivestock, Feedlot & Agribusiness

Red Range Stock Supplements

PLC Feedmill Automation & Multi-BOM Agribusiness ERP Across Australia

Baseline: Manual Mix Batching & Disconnected Cost Spreadsheets
Sapi Stack: PLC Automation Integration + SQL Server BOM Costing + Compliance ERP

Challenge: Producing custom livestock mineral and protein supplements required synchronizing multi-ingredient BOM recipes, Commodity Vendor Declarations, batch lot numbers, and dynamic average ingredient costing directly with plant PLC machinery.

Solution: Engineered an end-to-end ERP connecting PLC feedmill automation, batch lot generation, average-cost ingredient accounting, and Australian compliance documentation—actively maintained and upgraded since 2019 through today.

Direct PLC Mill Integration
Dynamic Avg Ingredient Costing
Lot & Vendor Declaration Trace
7+ Years Active Production
PLC AutomationAustralia AgTechBOM BatchingLivestock Supplements
Australia · Queensland & Northern Territory, AustraliaLivestock & Export Depots

Reid River Export Depot & Noonamah Yards

RS-232 Road-Train Weighbridges, Hydraulic Crushes & Live Cattle Export ERPs

Baseline: Manual Pen Sheets & Disconnected Scale Indicators
Sapi Stack: RS-232 Serial Hardware Capture + Multi-Station Crush/Weighbridge/Admin ERP

Challenge: Northern Australian cattle export depots process thousands of head off road trains under tight vessel loading windows, needing live RS-232 weight capture at the weighbridge, feed mixer, and hydraulic crush without manual re-keying.

Solution: Built synchronized Admin, Crush-Side, and Weighbridge modules reading RS-232 serial scale indicators directly into SQL Server alongside pen-sheet fodder tracking, vendor lot filtering, and international live-export scan manifests (Bassem Dabbah).

RS-232 Weighbridge & Crush
3-Station Synchronized DB
Road-Train Docket Export
Live Vessel Export Manifests
Weighbridge RS-232Hydraulic CrushLive Cattle ExportAustralia NT/QLD
Australia · Northern Territory & Broome, WAAviation & Pastoral Livestock

TopEnd Mustering & ILC Roebuck

Helicopter Mustering Aviation ERP & Pastoral Station Cattle/Meatworks Systems

Baseline: Paper Flight Logs & Offline Station Spreadsheets
Sapi Stack: SQL Server Rolling Window Compliance Rules + Station & Meatworks Tablets

Challenge: Aerial cattle mustering across the Australian Outback demands strict CASA pilot flight-duty compliance (rolling 16-day <100h, 365-day <1200h, and mandatory rest resets) alongside aircraft maintenance release billing.

Solution: Built a dedicated aerial mustering ERP calculating TEO/TT engine times and rolling SQL flight-duty restrictions automatically, plus multi-station tablet and meatworks capture systems for ILC Roebuck Plains.

CASA Rolling Duty SQL Engine
Engine-On to Off Billing
Outback Tablet Deployment
Meatworks Station Control
Aviation ERPFlight Duty ComplianceOutback PastoralAustralia
USA · TexasProtein & Food Processing

Unidos Foods & Unidos Meat Processors

USDA Meat Processing ERP + GS1 Freezer Warehouse PWA with Coexisting Access

Baseline: MS Access 2003 + UnidosFoods SQL Server
Sapi Stack: Node.js/Express + Zebra ZPL Printer + GS1 Scanner PWA + Live SQL Coexistence

Challenge: Every box of meat across coolers, freezers, receiving, and shipping needed mobile GS1 barcode scanning and sub-location tracking on tablets without breaking the existing Access 2003 ERP used by office staff.

Solution: Deployed `sapi-unidos-wh` writing directly through shared stored procedures into production SQL Server (`Tbl_Pr_Etiquetas_Transacciones`), adding Zebra ZPL thermal printing, exception detection, and real-time cold-storage inventory.

GS1-128 Box Traceability
Zebra ZPL Direct Printing
Zero Access Regressions
Multi-Freezer Sub-Locations
GS1-128Zebra ZPLCooler/Freezer PWAUSDA Meat
USA · TexasProtein & Cold-Chain Distribution

Wagyu-X

API-First Sales, Customer-Item Aging & 3PL Cold Storage Allocation Platform

Baseline: Spreadsheet Allocations & Manual 3PL BOL Matching
Sapi Stack: API-First Monorepo + Automated Cold-Storage TXT Releases + Pallet Tracking

Challenge: High-value Wagyu beef allocations required enforcing customer-specific product aging rules, flagging unreceived BOL discrepancies, tracking individual Pallet IDs, and transmitting strict 2:00 PM cold-storage warehouse releases.

Solution: Built WagyuX as the single operational source of truth managing sales orders, pallet-level cold inventory, weekly item velocity, inter-entity transfers, automated 3PL release files, and accounting handoff.

Customer × SKU Aging Rules
Automated 2 PM 3PL Releases
Pallet-Level Inventory Control
BOL Discrepancy Flagging
Wagyu Beef3PL Cold StorageAllocation ControlAPI-First
USA · Idaho & UtahProtein & Food Processing

Abe's Kosher Meats & Mountain West Food

Kill-House to Cold Storage ERP with Multi-Hold QC Release & Driver Tablets

Baseline: Disconnected Kill House, Cold Warehouse & Further Processing Systems
Sapi Stack: Unified Multi-Company SQL ERP + GTIN-14 Scanning + Driver Tablet POD

Challenge: Coordinating cattle slaughter (Ida Beef), cold logistics (Burly Cold), further processing (Mountain West), and e-commerce (Beef Reserve) required hot/cold yield tracking, strict QC micro holds, and 4-decimal catch-weight driver deliveries.

Solution: Delivered integrated kill-floor, GTIN-14 production scanning, BOM cooking lots, multi-hold QC release gates, live inventory, and mobile driver tablets capturing customer signatures and payments at delivery.

4 Entities Unified
4-Decimal Catch-Weight
Multi-Hold Micro QC Gates
Driver Signature & Payment
Kill House YieldGTIN-14Catch WeightDriver Tablet
Mexico · Monterrey, NLIndustrial Manufacturing

Durosa

Angular + Java Cloud ERP Upgrade with Automated Engineering Cost & Quoting Engine

Baseline: Legacy Desktop ERP + Manual Quotation Costing
Sapi Stack: Angular Frontend + Java REST API + SQL Server + Automated Cost Calculator

Challenge: Industrial engineering quotations required recalculating net part weight, raw materials, machining hours, labor, and overhead while unifying engineering catalogs and cost accounts in the cloud.

Solution: Upgraded the legacy ERP into an Angular + Java enterprise platform featuring reactive cost-line calculation matching legacy rules, automated engineering catalog endpoints, and full client/parameter management.

Angular + Java Enterprise
Auto-Calculated Cost Quotes
Engineering Catalog Sync
Multi-Year Sapi Partnership
Angular + JavaIndustrial QuotingEngineering BOMSQL Server
Mexico · Monterrey, NLAutomotive Supply & Manufacturing

Curtidos Treviño & TYCSA

Automotive Leather & Fastener ERPs: EDI/ASN, Kanban, Scales & JobBOSS Bridge

Baseline: Isolated Production, Weighing & Accounting Tools
Sapi Stack: SapiERP + Automotive EDI/ASN + Android Production + Weighbridge + SAT CFDI

Challenge: Supplying tier-1 automotive and industrial accounts demanded strict Kanban production scheduling, automated ASN/EDI flat-file generation, weighbridge control, Android floor apps, and bidirectional sync with JobBOSS & SAT CFDI.

Solution: Delivered comprehensive manufacturing ERPs combining daily executive parameter reporting, Kanban scheduling, weighbridge capture, automotive ASN flat-file builders, Android mobile inventory, and full Mexican CFDI compliance.

Automotive EDI / ASN
Kanban & JobBOSS Bridge
Android Floor Capture
Moprosoft & CFDI Ready
Automotive EDIKanbanJobBOSS BridgeAndroid App
Mexico · Monterrey, NLIndustrial Distribution & Packaging Mfg

Grupo Kopar & Printel

Web ERP + CRM, Foreign Trade Pedimentos, Master-Lot Costing & CFO Analytics

Baseline: Manual Foreign Trade Reconciliations & Static Excel Costing
Sapi Stack: Sapi Web ERP + CRM + Pedimento Audit + Coroplast/Ink Cost BI

Challenge: Industrial automation distributor Grupo Kopar needed cross-border pedimento policy reconciliation and web CRM/visits tracking, while Printel required deep CFO-level variance analysis across master lots, ink, Coroplast, and direct labor.

Solution: Built custom Web ERP + CRM suites integrating foreign-trade inventory average costing, supplier balance reconciliation ($192M+ MXN audited), Coroplast installation tracking, RFQ intake blueprints, and executive CFO BI.

Web ERP + Field CRM
Customs Pedimento Audit
Master-Lot Margin BI
Multi-Currency Accounting
Web ERP + CRMCustoms PedimentosCFO AnalyticsCFDI
Canada · Alberta / North AmericaLivestock Economics & Protein Trading

Mackenzie Agriculture & Lakeland

Cattle Feeding Breakeven Simulators, Country Carry & F&O Trading Back Office

Baseline: Disconnected Commodity Models & Spreadsheet Trading Logs
Sapi Stack: SQL Server + F&O Trading Back-Office + USDA/WASDE Econometric Engine

Challenge: Cross-border beef trading and cattle feeding across Canada and the US required real-time margin calculation, Country Carry analytics, historical USDA/WASDE modeling (1973–present), and organized back-office position tracking.

Solution: Engineered custom back-office trading software, cattle feeding breakeven simulators, boxed-beef analytical reporting, and automated WASDE data ingestion pipelines trusted across North America.

Canada & US Beef Trading
50-Year Margin Models
F&O Position Back-Office
Boxed Beef BI Reports
Canada AgTechF&O TradingCattle BreakevenWASDE Analytics
Mexico · Nuevo León & CoahuilaAggregates, Mining & Quarries

Industrias Caltec, Pedrera Hidalgo & Triturados

Multi-Site Quarry & Aggregates ERPs with Automated Truck Weighbridge Integration

Baseline: Manual Scale Tickets & Isolated Site Accounting
Sapi Stack: Multi-DB Quarry ERP + Live Scale Serial Capture + Full General Ledger

Challenge: High-volume stone quarries and calcium industrial plants needed zero-leakage truck scale ticketing tied automatically to dispatch pricing, customer credit limits, shift telemetry, and general accounting.

Solution: Deployed dedicated scale-house terminals synchronized with administrative ERPs across Caltec Saltillo/Monterrey, Pedrera Hidalgo, and Triturados San Jerónimo, supporting multi-company isolation and SAT invoicing.

Anti-Leakage Scale Tickets
Multi-Plant SQL Architecture
Credit Limit Enforcement
Integrated GL & Costing
Quarry ERPTruck WeighbridgeMulti-EntitySAT Accounting
Australia · Australia (National)Ag Insurance & Ranch Field Tech

Crawford Agriculture, Dowlco & Hammers

Offline iPad Reinsurance Claims + Long-Range Ranch WiFi & Tractor Scale Telemetry

Baseline: Paper Field Assessments & Manual Feed Scale Logs
Sapi Stack: Offline-Sync iPad/Android Apps + Ubiquiti Long-Range WiFi + RS-232 Tractor App

Challenge: Cotton and crop assessors across remote paddocks needed offline iPad claims apps with geo-tagged imagery for European reinsurers, while cattle stations needed tractor feed scales and earthmoving equipment synced over long-range ranch WiFi.

Solution: Engineered offline-first mobile claim capture syncing to desktop underwriting hubs, paired with Android tractor feed-scale & earthmoving apps connected via directional Ubiquiti links directly to SQL Server.

Offline Paddock Claim Sync
Geo-Tagged Loss Evidence
RS-232 Tractor Scale App
Long-Range Ranch WiFi
Offline iPad/AndroidAg Insurance ClaimsTractor TelemetryAustralia
Complete Track Record

Deployed Systems Directory by Country

Every organization below represents live operational software, hardware integration, or ERP engineering delivered by Sapi.

United States

Headquartered in Austin, TX — Powering USDA meat plants, cold-chain distributors, MGA trucking insurers, and industrial suppliers nationwide.

22 Featured Accounts
Colinas Foods / Colinas Products11-App Meat & Food Cloud Suite
Platinum MGACommercial Trucking MGA Cloud ERP
Streamline Insurance & Stream-XAgency & Policy Management System
Unidos Foods & Unidos Meat ProcessorsUSDA Processing & GS1 Warehouse PWA
Wagyu-XWagyu Sales, Allocation & 3PL Sync
Abe's Kosher Meats / Mountain West FoodKill-House, QC Hold & Driver Tablet
Dean & Peeler MeatworksMeatworks ERP & Scale Labeling
Waves & Winds / Chefs Fresh / Forward FarmsLabel-Level Meat Production Control
Ranch House Meat Co.Beef Processing & Concessions ERP
Pederson's Natural FarmsNatural Protein Supply & Ops Support
729 BeefBeef Sales & Inventory System
El Rancho FoodFood Distribution & Warehouse ERP
Gann ServicesDSD Route Sales & QuickBooks Sync
Quality DEF SolutionsMulti-Warehouse & Job Margin ERP
Select ImportsBeverage/Food Import & PO Control
Forum Energy Technologies (Plantersville)Energy & Industrial Systems
Drilling Structures InternationalHeavy Oilfield Mfg ERP
SteelBreeze / EAFabSteel Fabrication & Pedimentos
Sorfin YoshimuraIndustrial Trading CRM & ERP
Blue Fish SeafoodSeafood Processing & Traceability
Holmes Foods / ISA Beefmasters / AgTrinsicPoultry, Cattle & AgTech Systems
FCS / StockyardHQ / Nature’s Healthy GourmetCommodity Analytics & Food Ops

Mexico

Deep engineering presence across Monterrey, Saltillo, Bajío & Tamaulipas — Heavy steel MES, multi-plant SCADA, automotive EDI, and SAT CFDI 4.0 automation.

14 Featured Accounts
Johnson Controls (JCI — 8 Plants + 4 DCs)IRIS 8D Quality & Multi-Plant SCADA
PIASA (Procesadora Industrial del Acero)SmartFab Web MES & QR Shop-Floor
Welita Chila & MonteMaíz (Molino del Norte)Multi-Company Food ERP & CFDI 4.0
DurosaAngular/Java Industrial ERP & Quoting
Curtidos TreviñoAutomotive Leather ERP, EDI/ASN & Scales
Grupo KoparWeb ERP, CRM & Customs Pedimentos
PrintelManufacturing Cost BI, Coroplast & RFQ
TYCSA (Tuercas y Tornillos)Kanban, CFDI & JobBOSS Bridge
Praderas Huastecas (GUSI)Integrated Beef Ranch-to-USA Export
Industrias Caltec & Caltec SaltilloIndustrial Calcium & Weighbridge ERP
Pedrera Hidalgo & Triturados San JerónimoQuarry & Aggregates Weighbridge ERPs
Dicabsa / Transformación Cárnica / El NogalBeef Processing & Cold Distribution
Los Fertres / Procar / Proboca / GicoFeedlots, Meat Deboning & BI
Mortex / Innova WMS / Multipap / Ceingis / SitMfctWarehouse, Paper, Lab & Maintenance ERPs

Australia

Proven across Queensland, Northern Territory, WA & NSW — Connecting PLC feedmills, RS-232 weighbridges, hydraulic crushes, aviation & export depots.

8 Featured Accounts
Red Range Stock SupplementsPLC Feedmill Automation & BOM ERP
Reid River Export DepotWeighbridge, Crush & Live Export ERP
Noonamah Export YardsCattle Yard & Feedlot Weighbridge ERP
TopEnd MusteringHelicopter Aviation & Pilot Duty ERP
ILC Roebuck (Roebuck Plains)Pastoral Station & Meatworks Tablets
Crawford AgricultureOffline iPad Crop Reinsurance Claims
Dowlco LivestockRanch WiFi & RS-232 Tractor Feed Scale
Hammers / Bundarra / Austrex / Ravensworth Ag / Curly MeatsPedigree, Earthmoving & Livestock Ops

Canada & Cross-Border

Supporting Canadian cattle feeding economics, boxed-beef analytics, and North American USMCA cross-border protein and industrial supply chains.

3 Featured Accounts
Mackenzie AgricultureF&O Trading Back-Office & Country Carry
LakelandCattle Feeding Breakeven Modeling
North American Beef & Logistics ClientsCross-Border US–Canada–Mexico Ops

Have a Similar Operation or Legacy Database?

Talk directly with the architects behind these 100+ deployments. We can audit your legacy system or launch a pilot Cloud SaaS module in weeks.