Warehouse Consolidation System

Smart warehouse routing system with UPS integration for optimal shipping

Private employer Details are sanitized; architecture and outcomes are described without proprietary identifiers.

At a glance

faster checkout processing
75%
warehouse ranking per order
Sub-second
availability through carrier outages
100%
Role
Full Stack Developer
Year
2025
Category
Backend Software Dev

About This Project

Engineered a multi-warehouse routing engine to optimize order fulfillment across distributed inventory centers. Integrated real-time shipping APIs with concurrent request handling to minimize latency. Developed custom inventory logic for complex product types and implemented robust fallback mechanisms to ensure 100% system availability during third-party API outages.

Engineering Deep Dive

How a checkout-time routing engine classifies order lines, rates candidate warehouses in parallel, consolidates shipments, and falls back to internal ranking when the carrier API goes down.

Read the engineering deep dive

Technologies Used

PHPIBM DB2UPS APIBootstrapcURLJavaScriptGitHub Actions

Engineering Challenges

  1. 01

    Inventory Dependency Logic

    Solved the challenge of tracking 'virtual' stock for kits and custom-cut items that do not hold independent inventory. Implemented a recursive validation system that calculates availability in real-time based on parent component stock levels.

  2. 02

    Logistics Optimization

    Designed an algorithm to handle split-inventory orders, dynamically grouping items to reduce shipping costs and transit times while adhering to specific business constraints for vendor-shipped and backordered goods.

  3. 03

    Performance at Scale

    Addressed high-latency issues inherent in sequential API calls by implementing a concurrent request architecture, reducing processing time by over 75% during the checkout phase.

Technical Highlights

Concurrent API Integration: Utilized parallel cURL processing to query multiple logistics endpoints simultaneously, achieving sub-second response times for complex warehouse ranking operations.

Data Normalization Layer: Built a robust preprocessing engine to sanitize and format geographic data, ensuring high success rates for third-party API address validation and rate requests.

Resilient Architecture: Designed a 'Graceful Degradation' strategy that detects external service failures and automatically switches to an internal fallback ranking system, maintaining a seamless user experience.

Business Logic

Direct-to-Consumer Routing: Automated the detection and exclusion of vendor-managed (dropship) items from internal consolidation to streamline fulfillment.

Intelligent Backorder Handling: Developed logic to isolate out-of-stock items to primary distribution hubs, preventing unnecessary transshipments and reducing overall delivery lead times.

Hybrid Fulfillment Rules: Created a specialized 'Will-Call' workflow that allows for immediate local pickup of available stock while automatically coordinating the consolidation of remaining order items.