Jun 2023 – Jan 2026

Textile ERP Platform with X12 EDI & QuickBooks Integration

Silva Screenprinting & Distribution · Backend & Infrastructure Engineer

3 Apps

Factory · Admin · Customer

180+

Apparel Brands Catalogued

X12 EDI

Bidirectional + 997 Ack Loop

QuickBooks

Online Accounting Sync

Growth & Stability

~60%

API Response Time Reduced

30+

Manual Workflows Eliminated

1000s

Real-time Synced Users

Overview

At Silva Screenprinting & Distribution, I built the backend, data layer, and cloud infrastructure behind a complete custom-apparel and screen-printing ERP — three React applications for the factory floor, administrators, and customers. The platform runs the business end to end: a catalog of 180+ apparel brands, customer ordering, a multi-method production pipeline (heat transfer, embroidery, screen printing) with staged proof approval, inventory, procurement, shipping with tracking, role-based access, full audit logging, bidirectional X12 EDI with trading partners, and QuickBooks Online accounting. I owned the backend, database, infrastructure, DevOps, and CI/CD.

The Problem

A custom-apparel decorator needed one ERP to run ordering, production, and fulfillment end to end

Three audiences — factory, administrators, and customers — needed tailored apps on one backend

Orders moved through multiple decoration methods and a staged proof-approval workflow

A large product catalog had to stay sourced from apparel suppliers

Trading partners exchanged orders and invoices over X12 EDI, not modern APIs

Accounting lived in QuickBooks, separate from day-to-day operations

The business needed auditability, role-based access, and shipment tracking

The Solution

A unified backend and data model powering three React apps (Factory, Administrator, Customer)

A catalog of 180+ apparel brands sourced from suppliers such as SanMar and S&S Activewear

A production pipeline across three decoration methods — heat transfer, embroidery, and screen printing

A staged workflow: artwork → pre-production → production, with verify-proof, client-approval, proof-ready, and packaging steps

Order status states (start, flagged, exception) with notifications

Role-based access (Admin, Supervisor, Operations, Customer) and full event/audit logging

Bidirectional X12 EDI (parse 850; generate 855, 856, 810; with the 997 ack loop)

QuickBooks Online accounting sync and built-in shipment tracking

Architecture

Core Components

Customer ordering portal — place orders, track status, view invoices, raise and resolve item issuesProduct catalog — 180+ apparel brands sourced from suppliersOrder management and status workflow (start, flagged, exception)Production pipelines — heat transfer, embroidery, screen printing (ink)Proof and approval workflow — artwork, pre-production, productionInventory and stock controlProcurement and purchasing (vendor POs)Shipping, fulfillment, and shipment trackingX12 EDI engine (810/850/855/856/997)QuickBooks Online accounting syncRole-based access control (Admin, Supervisor, Operations, Customer)Event logging and audit trail

Technical Design

Unified REST backend serving three React apps: Factory, Administrator, and Customer

AWS serverless (Lambda, S3, IAM), provisioned with Terraform

MySQL relational data model spanning catalog, orders, production, inventory, and shipping

Production pipeline across heat-transfer, embroidery, and screen-printing methods with staged proof/approval

X12 EDI engine: envelope/segment handling, outbound generation, 997 ack loop, and control-number reconciliation

QuickBooks Online API integration for accounting sync

OAuth / OpenID authentication with role-based access (Admin, Supervisor, Operations, Customer)

System-wide event logging / audit trail and built-in shipment tracking

Exchange PowerShell (Get-Mailbox) for inbound invoice / EDI email parsing

CI/CD pipelines for automated deployments

My Role: Backend, Infrastructure & DevOps

Architected and built the backend and database for the full ERP

Owned cloud infrastructure (AWS), Terraform IaC, DevOps, and CI/CD

Built the order and production-pipeline workflows (heat transfer, embroidery, screen printing) with staged proof approval

Modeled and served the 180+ brand product catalog sourced from suppliers

Built the bidirectional X12 EDI integration (810/850/855/856/997) with the 997 ack loop and reconciliation

Integrated QuickBooks Online to sync accounting with operations

Implemented role-based access (Admin, Supervisor, Operations, Customer) and system-wide audit logging

Built shipping/fulfillment with shipment tracking and the customer issue-management flow

Built reporting endpoints across the ERP

Key Achievements

🔥

Delivered the backend and infrastructure for a complete custom-apparel ERP across three apps

🔥

Modeled a product catalog spanning 180+ apparel brands from suppliers

🔥

Built a multi-method production pipeline (heat transfer, embroidery, screen printing) with staged proof approval

🔥

Built full bidirectional X12 EDI (generation + acknowledgment loop), not parse-only

🔥

Synced operations with accounting via QuickBooks Online

🔥

Implemented role-based access and full audit logging across the system

Impact

📊

Ran a custom-apparel decoration business end to end on one platform, from order to shipment

📊

Gave customers self-service ordering, tracking, invoices, and issue resolution

📊

Automated business-document exchange with trading partners

📊

Kept operations and accounting in sync, cutting manual data entry

📊

Made every action auditable and access role-appropriate

Tech Stack

Backend

REST APIs, OAuth, OpenID

Frontend

React (Factory, Administrator, Customer apps)

EDI

X12 (810, 850, 855, 856, 997)

Accounting

QuickBooks Online API

Cloud

AWS (Lambda, S3, IAM), Terraform

Database

MySQL

DevOps

CI/CD pipelines

Other

RBAC, audit logging, shipment tracking, PowerShell/Exchange

What I Help With

Scalable Backend Systems

High-performance APIs and microservices

Complex Integrations

Stripe, Shopify, Microsoft Graph, telecom

AI & Automation

LLM workflows, document processing

Identity & Security

OAuth, Entra ID, Cognito

Let's discuss your system or project

Get expert input on your architecture, integrations, or scaling challenges.

Book a Call to Discuss Your Project