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.

Project Overview

Shopify × Daftra Integration System

Role

Full Stack Developer

Team Size

1 members

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.