DuBois Orders
shraddha yadav
Rental Order & Inventory Management · Legacy System Integration
DuBois Orders
Full-stack rental management built to handle the full complexity of Single, Wedding, and Prom order workflows with zero tolerance for operational gaps.
Wedding Orders Prom Orders AS400 Sync AWS
Live Order System
100%
Sync Reliability
Status
● Operational
Sync Speed
<2s
Audit Trail
✓ Verified
Peak Season
Stable
Project Overview
A Rental Platform That Can't Miss a Beat
From inventory tracking and size chart logic to order lifecycle management and legacy sync especially during weddings and proms where timing is everything.
Wedding Orders
Event grouping keeps every party member's order connected manage twelve records as one cohesive unit.
Smart Size Filtering
Measurement-driven filtering for Men's and Boys' categories surfaces only valid fits, flags outliers instantly.
AS400 Sync
Rebuilt sync mechanism eliminates CSV mismatch errors legacy data lands accurately in the web app, every time.
Full Audit Trail
Every order change timestamped and attributed who changed what, and when. Critical for peak-season accountability.
The Challenge
A System Under Strain
Technical debt ran far deeper than sync issues. Every layer had a gap and in a rental business, gaps become customer failures.
01
Broken AS400 → AWS Sync
Orders weren't syncing reliably. CSV data parsed inconsistently gap between what the legacy system held and what the web app showed was creating costly errors.
02
Manual Size Validation Errors
Staff were presented with full size lists and left to validate manually a significant source of fulfillment errors during the busiest seasons.
03
No Business Rule Enforcement
Sub-rental style restrictions could be bypassed through the UI. Order state transitions had no lifecycle model states could jump without constraint.
04
Zero Audit Trail
When something went wrong with an order, there was no way to trace what changed, when, or by whom. No accountability, no recovery path.
CostlyErrors.
Orders failing at the worst possible moment weddings and proms.
Our Solution
Stabilize First. Build Upward.
A systematic approach fix the foundation before adding capability. Every layer built on reliable ground.
01
Rebuilt AS400 → AWS Sync
CSV parsing overhauled with improved validation logic. Data from the legacy system now lands accurately and consistently, eliminating mismatch errors that eroded staff confidence.
02
Dynamic Size Filtering
Measurement-driven filtering built separately for Men's and Boys' categories. Height, weight, neck, and sleeve measurements surface only valid options — anything outside tolerance is flagged automatically.
03
Admin-Only Sub-Rental Restrictions
Business rules enforced at the application layer. Standard users can't bypass sub-rental restrictions through the UI exceptions require explicit admin authorization.
04
Order Lifecycle State Machine
Structured lifecycle model prevents orders from jumping states incorrectly. Staff follow the correct process because the system guides them critical under peak-season pressure.
05
Audit Log + Wedding Event Grouping
Every meaningful order change captured with actor and timestamp. Wedding parties grouped cohesively twelve participants managed as one coherent event, not twelve isolated records.
06
AWS Infrastructure + Email Automation
Full EC2, Nginx, and MySQL environment configured and stabilized. Automated email notifications integrated customers and staff stay informed without manual follow-up.
System Architecture
Legacy AS400 System
CSV export → validated sync pipeline
AWS Sync Engine (EC2 + Nginx)
Parse · Validate · Store → MySQL
Size Filtering Engine
Height · Weight · Neck · Sleeve rules
Order Lifecycle State Machine
Enforced transitions · Admin overrides
Audit Log + Wedding Grouping
Timestamped · Actor-attributed · Event-linked
Automated Email Notifications
Customer & staff alerts · No manual follow-up
Outcomes
The Results
Every problem addressed. Every result measurable. The platform performs even when the pressure is highest.
100%
Reliable AS400 Synchronization
Orders flowing in from the legacy AS400 environment now land accurately in the web app consistently and without manual intervention. Staff stopped second-guessing what the system showed.
0
Manual Size Validation Errors
Dynamic size filtering removed a significant source of fulfillment errors. Mismatches caught before they reach the order queue no more back-and-forth corrections eating into operational time.
Full Order Change Visibility
A complete, timestamped record of every modification to every order. For a rental business, that transparency is a risk management tool — a missed alteration shouldn't mean the wrong suit at a wedding.
Business Rules That Actually Hold
Admin-only restrictions and lifecycle transitions mean rules can't be worked around. Staff follow the correct process because the system guides them — exceptions require proper authorization.
10×
Peak Season Performance
Structured pagination, optimized inventory mapping, and stable AWS deployment — the system absorbs peak demand during prom and wedding seasons when errors are most costly.
Wedding Party Cohesion
A wedding party of twelve managed as a single cohesive event — not twelve isolated records. Every order stays connected across participants throughout the full lifecycle.
Stack
Technology Used
Production-grade infrastructure built for reliability under seasonal pressure.
AWS EC2
MySQL
Nginx
Node.js
React
CSV Sync Engine
Email Automation
Audit Logging
Managing Complex Workflows on Aging Infrastructure?
Let's talk about what we can build for you. We stabilize foundations, enforce real business rules, and ship platforms that perform under pressure.
Like this project
Posted Sep 18, 2026
DuBois Orders — full-stack rental order & inventory management with AS400 legacy sync and wedding/prom workflows.
Likes
0
Views
1
