SterriaR logo
SterriaR
Back to Case Studies
EC Platform

B2B Matching-Style EC Service Development & Operational Refactoring

Development and operational refactoring of an EC platform with B2B matching features. Integrated listing, purchasing, payment, inventory, and inter-business messaging.

Ongoing·Role: Development
Next.jsTypeScriptPrismaPostgreSQL

Challenge

  • B2B-specific complex pricing schemes (volume tiers / member rank / transaction history) needed flexible expression.
  • A product master at the scale of tens of thousands required cross-category search, faceting, and recommendations.
  • New features needed to be released incrementally without halting existing operations.

Solution

  • Modeled flexible pricing in the Prisma schema and centralized price-determination logic on the server.
  • Implemented lightweight cross-product search using PostgreSQL full-text search + Prisma raw queries (no Elasticsearch needed).
  • Used feature flags + gradual rollouts for zero-downtime releases.

Technology Decisions

Why Prisma ORM

Type-safe DB access dramatically reduced runtime bugs. Migration diff management is automated by Prisma Migrate, lowering operational overhead.

Outcomes

New Feature Releases

4-6/month

Zero-downtime gradual rollout via feature flags

Product Search Response

p95 < 300ms

At a scale of 100,000 items

Pricing Patterns

5+ axes (volume tier / tier rank / history etc.)

Expressed flexibly in Prisma schema

Production Rollbacks

0

Operational record after introducing gradual rollout

Team

1 of our engineers + partner developers

Have a similar requirement?

If you face a comparable challenge in industry, scale, or technology stack, please don't hesitate to reach out.

Schedule a free consultation