04
B2B Wholesale / Catalog AI

AI-poweredcatalogpipelinesandzeroover-sellsatscale.

CompanySundayMalls
YearSundayMalls
TypeB2B Wholesale / Catalog AI
RoleFull Stack Engineer
Scroll
01 — Problem Statement

Three-day vendor onboarding and over-selling during flash sales were blocking growth.

Wholesale merchants manage inventory in bulk 'lots' — each with quantity, size breakdowns, pricing tiers, images, and GST/HSN codes. Listing a single supplier catalog manually required a team member spending 3 full days entering data. With vendors unable to onboard fast enough, the platform couldn't scale. During high-demand flash sales, multiple buyers would simultaneously select the same lot — the system had no concurrency protection, resulting in over-sells, cancellations, and merchant trust erosion. There was no automation anywhere in the catalog or inventory pipeline.

Key Metric latency
3 Days
To manually list one supplier catalog
02 — Solution Framework

Gemini AI invoice parsing with Redis-based distributed lot reservation locks.

Engineered a 4-surface marketplace (Customer App, Vendor App, Admin Panel, Marketing Site) with an AI-powered catalog core. Vendors now upload raw Excel or PDF price sheets — a Gemini AI pipeline reads the unstructured data, infers product categories, maps sizes and quantities to the platform schema, and creates fully structured lot listings with pricing, GST/HSN codes, and categorization automatically. What took 3 days now completes in seconds. For concurrency, Redis-based distributed locks are applied at the lot-reservation layer during checkout — when a buyer claims a lot, a lock is acquired for a configurable TTL. No concurrent buyer can claim the same units during that window, even under peak traffic, guaranteeing inventory integrity.

The Hypothesis

AI invoice parsing compressed 3-day manual onboarding to seconds, while Redis lot-reservation locks eliminated over-selling entirely — enabling flash sales at scale with zero cancellation conflicts.

Engineering Core Principle

03 — Key Features

Architectural Highlights

01

Gemini AI Catalog Pipeline

Vendors upload raw PDF or Excel supplier price lists. The Gemini-powered parser extracts product names, SKUs, quantities, sizes, pricing, and HSN codes from unstructured data, then maps them to the platform taxonomy automatically. Full catalog creation — including sub-category classification — completes in seconds with zero manual input.
02

Redis Distributed Lot Locking

At checkout initiation, a Redis lock is acquired on each selected lot with a configurable TTL (typically 10 minutes). Concurrent buyers attempting to claim the same lot receive an 'unavailable' response immediately. Lock release is handled automatically on checkout completion, abandonment, or TTL expiry — guaranteeing inventory consistency under any concurrency level.
03

Multi-Godown Vendor Management

Vendors with inventory across multiple storage locations get per-godown stock tracking, cross-godown transfer logging, and consolidated dashboard views. Audit logs capture every inventory movement with timestamps. RBAC controls which staff can view, transfer, or modify stock per location.
04 — Results & Impact

Measured outcomes.

3 Days → Sec
Vendor catalog onboarding time
0%
Over-sell rate under concurrent traffic
0
Manual catalog entry per listing
4 Surfaces
Customer, Vendor, Admin, Marketing
Next Case Study

CityCenterMall

05CityCenterMall