ERP Integrationlarge projectproduction⭐ Featured
Shopify × Daftra Integration System
A production automation system built for a Gulf-region 3PL warehouse operator. Eliminated a fully manual fulfillment workflow by bridging Shopify storefronts with Daftra ERP — every incoming merchant order instantly triggers invoice creation and stock deduction with zero human intervention and a complete audit trail.

Role
Full Stack Developer
Team Size
1 members
Key Metrics
Tech Stack
JavaScriptTypeScriptNext.jsTanStack QueryRadix UITailwind CSSshadcn/uiNode.jsExpress.jsPostgreSQLDockernginxBrevo SMTPShopify Webhooks APIDaftra APInodemailercrypto (HMAC)
Key Features
- Real-time Shopify webhook processing for order creation, updates, and cancellations
- HMAC signature verification on every incoming webhook request
- Multi-merchant architecture — each merchant operates with fully isolated credentials
- Vendor-based line-item filtering to process only relevant products per merchant
- Dual product code resolution: barcode lookup first, SKU prefix fallback
- Automatic Daftra sales invoice creation with real-time stock deduction
- Order update sync using GET-then-PUT to preserve existing invoice data integrity
- Order cancellation handled via Daftra refund receipts with precise item record targeting
- Deduplication guard prevents double-processing of already-handled orders
- Transactional email notifications covering invoice creation, updates, and cancellations
- Next.js admin dashboard for merchant onboarding and credential management
- Sync log viewer with granular status tracking: success, failed, ignored, cancelled, updated
- Docker Compose deployment with nginx as a unified reverse proxy entry point
- Basic Auth enforcement on all admin endpoints via nginx
Project Impact
- Replaced a fully manual warehouse fulfillment process with an end-to-end automated pipeline. Every Shopify order across all connected merchants now instantly generates a Daftra invoice and deducts stock in real time — no human involvement, no missed orders, and a full sync history for auditing and debugging.