Crosslane Fulfillment
Order routing and inventory sync automated across four warehouses that used to run on spreadsheets.
Industry
Logistics & Supply Chain
Timeline
10 weeks
Team
2 engineers
Category
Workflow Automation
Where things stood
Crosslane ran inventory across four warehouses on spreadsheets that were only ever accurate right after someone manually reconciled them, which meant orders regularly got routed to a warehouse that was actually out of stock.
How we got there
Central inventory store
Replaced the spreadsheets with a single source of truth that every warehouse writes to directly.
Routing logic
Built order routing that checks live stock and warehouse proximity instead of defaulting to whichever warehouse a rep happened to pick.
Reconciliation alerts
Added automatic alerts when a warehouse's physical count drifts from system count, catching errors within a day instead of a quarter.
What changed
4
Warehouses synced to one inventory system
~80%
Reduction in misrouted orders
Daily
Inventory reconciliation, down from monthly
Tech stack
Next.js
The dashboard warehouse staff use to see live stock and routing decisions.
Node.js
Runs the routing logic that checks live stock before assigning an order to a warehouse.
PostgreSQL
Single inventory record every warehouse reads and writes to directly.
AWS
Hosts the reconciliation jobs that compare physical counts against system counts daily.
TypeScript
Kept routing logic consistent as more warehouse rules were added.
Redis
Caches live stock counts so routing decisions don't hit Postgres on every order.
