Multi-Channel Ecommerce•Timeline: 6 weeks from audit to production handover

Belhide Operational Stack

Built a centralized operations stack at erp.belhide.com that consolidates sales, returns, ad efficiency, and inventory status into a unified platform with an automated daily 07:00 executive briefing.

Next.js App RouterSupabase PostgreSQLShopify APIAmazon SP-APIVercel

01. Client Context

Belhide is an international leather goods brand selling custom bags and accessories across Shopify, Amazon, and wholesale channels.

02. The Problem in the Client's Words

"Every morning I have to log into Shopify, then Amazon Seller Central, then Google Ads, then Search Console. I spend the first hour of every day pasting numbers into a Google Sheet just to know what we sold yesterday and what stock is running out in the warehouse."

03. Constraints & Realities

Multi-currency operations (USD, GBP, EUR).
High order volume during promotional surges requiring resilient rate-limited webhook handlers.
Founder wanted a single email and mobile dashboard with zero fluff.

04. Solution & Architecture Blueprint

Data flow showing intake, deterministic validation barriers, and permanent double-entry audit logging:

Architecture Blueprint: Deterministic Agent Staging PipelineZero Direct Database Writes

05. Data & Security Design

Access Rules (RLS)

Owner-only access for executive margins; warehouse operators receive a scoped fulfillment queue without access to customer acquisition costs or net margin figures.

Audit Trail

Every webhook payload is stored in raw JSON format before extraction, enabling full replay and auditability if an upstream platform schema changes.

Staging & Validation

Order values are cross-checked against payment processor capture receipts to prevent false-positive revenue figures.

06. Measured Results (Truth Gate Verified)

Backed by facts.json

4 channels

Integrated Sales & Telemetry Channels

Live API connectors for Shopify, Amazon, GA4, and Google Search Console

Period: Continuous production integration

Daily 07:00

Automated Operations Briefing

Automated execution timestamp of executive morning digest

Period: Sent every morning without fail

100%

Fulfillment & Stockout Visibility

Elimination of manual cross-channel inventory spreadsheets

Period: Measured across 6 months of operations

07. What Went Wrong & What I Changed

Candid Engineering Retrospective

Amazon SP-API throttling limits caused webhook drops during Prime Day surge. We had to implement an asynchronous Redis-backed queue with exponential backoff retries.

09. What I'd Do Differently

I would have built the rate-limiting queue on day one instead of relying on direct webhook execution handlers.

Need a system engineered to this standard?

Book a 20-minute discovery call to review your operational bottlenecks.

Book a 20-minute discovery call