E-Commerce Operations2026

Full Route IQ

Shopify PlusAmazon SP-APIWalmartBullMQPostgreSQLFulfillment

Unified order ingestion and intelligent routing across 5 sales channels and 5 fulfillment providers — with cost-aware split shipment logic, SLA enforcement, and tracking push-back to originating channels.

The Challenge

Multi-channel Shopify Plus merchants operating across D2C, B2B, Amazon, Walmart, and marketplace channels face fragmented order flows, disconnected fulfillment providers, and no unified routing logic. Each channel has different SLA requirements, tracking formats, and carrier code conventions.

The Solution

A unified order ingestion system with channel connectors that normalize orders from every source into a single format. A rules-based routing engine evaluates each order against inventory availability, geographic proximity, SLA deadlines, and fulfillment cost. Split shipment logic calculates minimum location coverage and compares costs. Tracking pushes back to each originating channel in its required format.

Design

Code

Result

engine/route-order.tstypescript
  1async function routeOrder(order: UnifiedOrder): Promise<RoutingDecision> {  2  const warehouses = await getWarehousesWithInventory(order.lineItems)  3  4  // Check single-warehouse fulfillment first  5  const singleFulfill = warehouses.find(w =>  6    canFulfillComplete(w, order.lineItems)  7  )  8  9  if (singleFulfill) { 10    return { type: 'single', warehouse: singleFulfill } 11  } 12 13  // Calculate split shipment vs inventory transfer 14  const splitCost = calculateSplitShipment(warehouses, order) 15  const transferCost = calculateTransferThenShip(warehouses, order) 16 17  return splitCost.total < transferCost.total && splitCost.meetsSlA 18    ? { type: 'split', plan: splitCost } 19    : { type: 'transfer', plan: transferCost } 20} 21

Scroll to explore

Tech Stack

TypeScriptHonoBullMQRedisPostgreSQLDrizzle ORMReactRechartsDocker

Interested in similar work?

Let's discuss how I can help bring your Shopify project to life.