/projects

StuckOrders

one owned queue for everything stuck between Shopify and ShipStation

  • TypeScript
  • Node.js
  • Postgres
  • Docker

stuckorders.com ↗

When a warehouse runs on Shopify and ShipStation, the problems hide in the gaps between them: paid orders aging unshipped, a SKU blocker that stalls a shipment, returns stuck on a refund decision, damaged receipts and vendor claims nobody owns. StuckOrders watches those systems read-only and turns everything that’s stuck into a single queue — each item with an owner, an age, and a next action — something a team clears by 9am instead of discovering in a lawsuit or a quarterly surprise.

It’s a real multi-tenant SaaS build: a dependency-free Node server with scrypt session auth, role-based org accounts, and an append-only audit log; real Shopify (GraphQL), ShipStation (REST), and Slack integrations behind OAuth connect flows; an AES-256-GCM credential vault; Stripe billing with signature-verified webhooks; and an in-process scheduler that posts a daily Slack exception digest per organization. The detection logic lives in pure TypeScript domain modules, and the whole thing runs on Postgres with automatic migrations — or on JSON files with nothing configured — behind 270+ tests that need no external services.

The wedge is deliberately narrow: not a WMS, no rip-and-replace, connect in minutes. It goes to market as a free 30-day exception audit for Shopify-led warehouse teams in LA, Orange County, and the Inland Empire, with monthly plans scaling from a single warehouse up to multi-client 3PLs. Production-ready and dockerized, with the public launch ahead. (Built under the working name Warehouser.)