Can I vibe code Pipe17?

Build an open-source order routing and integration server in TypeScript using Express, PostgreSQL, Prisma, and BullMQ.

1. DATA MODEL
- Orders: id, external_id, source_channel (e.g. shopify, amazon), status, raw_payload (JSONB), normalized_payload (JSONB), allocated_location_id, created_at.
- Inventory: sku, location_id, quantity_available, quantity_reserved.
- Locations: id, name, priority, endpoint_url, api_key_encrypted.
- RoutingRules: id, priority, condition_json, target_location_id.
- SyncLogs: id, order_id, direction, payload, status, error_message, created_at.

2. CORE FUNCTIONALITY
- Webhook Ingestion: Expose endpoints to ingest raw order payloads from Shopify and Amazon.
- Normalization Engine: Transform incoming external payloads into a standardized InternalOrder schema (line items, shipping address, order total).
- Routing Engine: Process normalized orders against RoutingRules sorted by priority. Support conditions based on postal code prefixes, line-item SKUs, and real-time inventory levels per location.
- Fulfillment Dispatch: Push routed orders to destination 3PL APIs via HTTP POST. Store response tracking IDs.
- State Management & Inventory Reserve: Deduct local reserved quantities upon allocation. Fire inventory sync webhooks back to sales channels.
- Background Retries: Use BullMQ queues to handle transient destination API failures using exponential backoff (up to 5 attempts).

3. FAILURE MODES & RESILIENCE
- Idempotency: Deduplicate incoming webhooks using external_id + source_channel to prevent duplicate orders.
- Dead-Letter Queue (DLQ): Send orders failing after max retries to a 'DLQ' state. Expose an admin API endpoint /api/orders/:id/retry to manually trigger re-processing.
- Rate-Limit Queueing: Enforce per-location request rate limits using Redis leaky-bucket throttlers.

4. OUT OF SCOPE
- Complex EDI file parsing (EDIFACT/ANSI X12).
- GUI workflow builder (use strict JSON rules in database).
- Native accounting software general-ledger reconciliation.

$ each button prefixes agent-specific run instructions · build your own product, never copy proprietary code, trademarks or designs