Supply Chain Analytics · AWS
Solace — inventory defect analytics & automated chargebacks
A multi-tier analytics and chargeback platform that turns millions of inbound shipment events a day into vendor-level defect intelligence, then drives an automated fine-generation workflow with a self-service vendor portal and human-readable explanations.
01The challenge
Inventory receive defects — late shipments, short-shipped quantities, PO discrepancies — were tracked in fragmented, manual ways. There was no authoritative vendor-level view of performance, and financial recovery for defective shipments was a slow, manual chargeback process prone to disputes.
02The strategy
Architect a clean multi-tier platform with strict separation of concerns: streaming ingestion, AWS Glue for large-scale ETL, labeling and aggregation, OpenSearch for sub-second faceted search, and an API-first React front end. Close the loop by integrating the enterprise invoicing system to auto-generate fines, and integrate Sherpa to explain every fine in plain language.
03The execution
Consumed receive signals from upstream streams and normalized them through transformation stages joining shipment metadata, PO details, and delivery SLAs. Glue jobs and crawlers labeled and rolled data up into vendor-, PO-, and shipment-level defect insights, cataloged for governed access and indexed in OpenSearch. A React SPA gave vendors transparent, filterable visibility; invoicing integration generated fines automatically; Sherpa explained each one and suggested remediation — cutting dispute volume.
04The results
- 2M+
- Inbound receive events processed / day
- 4
- Vendor defect categories classified
- 100%
- Manual chargeback workflow automated
See the system in motion
An interactive walkthrough of the architecture and data flow — hover, click, and drive the simulation.
Signal to recovery, stage by stage
Four zones move a raw receive event all the way to a vendor-visible, explainable chargeback.
Ingestion
Inventory receive signals → Kinesis
ETL & Aggregation
AWS Glue: crawl, label, join, roll up
Crawler · schema + labeling
Glue job graph
Storage & Search
Amazon OpenSearch: sharded, sub-second
OpenSearch · 5 shards
Faceted search · sub-second
Application Layer
Portal · invoicing · Sherpa explainability
React web app
Vendor dashboard
Invoicing system
Chargeback invoice
Sherpa explainability
Sherpa explains
The vendor portal
What a vendor actually sees — every shipment, every defect, every fine. Click a row to see why it was assessed and how to fix it.
| PO # | Expected | Received | Qty | Defect | Fine | Status |
|---|---|---|---|---|---|---|
| PO-48213 | 2026-07-12 | 2026-07-19 | 4800/4800 | Late | $3,200 | Assessed |
| PO-48307 | 2026-07-15 | 2026-07-15 | 5100/6000 | Short-shipped | $5,400 | Disputed |
The impact
A manual chargeback workflow, automated end to end — with measurable recovery.
0
Defects detected / day
$0.0M
Fines auto-generated
0%
Recovery rate
+0pts
Vendor NPS improvement
Have a similar challenge?
Tell us where it hurts — we'll show you what's possible and what it costs.