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

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.


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.

Formal wear rental operations
Costly
Errors.
Orders failing at the worst possible moment weddings and proms.

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

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.


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.

CONTACT US

INDIA

210, Om Gurudev Plaza (Savitri Empire)
Near Vikram Urban, Indore M.P. 452010

0731-4980308
info@smtlabs.io

USA

2907 Shelter Island Dr
San Diego, CA 92106, USA

+1 619-954-0044
us@smtlabs.io

SOUTH AFRICA

5 Harold Place, Glenashley
Durban, South Africa

+27 84-5783-965
sa@smtlabs.io

MAURITIUS

305 Jade Court, Jummah
Mosque Street, Port Louis, Mauritius

+230 58-486-656
mu@smtlabs.io

Project inquiry

sales@smtlabs.io

Follow us on

© 2026 SMTLabs. All rights reserved.