Case study · eCommerce analytics SaaS · India

EcommPulse: one analytics dashboard for sellers across marketplaces

How I built EcommPulse's React dashboards: sales, fees, refunds and regional performance across Amazon, Flipkart and Shopify, in one place.

Client
EcommPulse
Industry
eCommerce analytics SaaS
Location
India
My role
Frontend engineer: dashboards and data views
Engagement
Software Engineer at Unico Connect, 2021–2023
EcommPulse revenue calculator comparing marketplace fulfilment with own fulfilment, shown on a laptop
Revenue calculator: marketplace fulfilment against your own.

Outcomes

  • 75%

    less manual operations work for sellers

  • 50%

    faster data-to-insight pipeline

  • 30%

    fewer stockouts across brands

Context

The problem

  • 01.

    Sellers' data was split across marketplaces, each with its own reports, fees and formats.

  • 02.

    Restock decisions came late, so stockouts were common, and prices were rarely revisited.

  • 03.

    Payouts were reconciled only at quarter-end, and a single brand can generate hundreds of thousands of transactions a month.

Approach

Platform decisions

  1. 01

    Normalize, don't flatten

    Each marketplace's source-level detail is kept behind one unified view, so a new marketplace can be added without re-architecting.

  2. 02

    Explainable numbers over black boxes

    Forecasts and pricing suggestions come with their supporting figures, so sellers can see why.

  3. 03

    Grounded natural-language answers

    QueryAI maps plain-English questions to queries on the data model instead of generating free-form answers.

My work

What I built

Software Engineer at Unico Connect, 2021–2023

  • Developed the React dashboards sellers work in: KPI overviews of sales, units, expenses and net profit, with per-marketplace breakdowns and the charts behind them.
  • Built customizable dashboards on top of the platform's automated data sync.
  • Implemented role-based access, so each team member sees the data meant for them.
  • Integrated the platform's REST APIs into the data views and charts.

Built with

  • React.js
  • Charts
  • REST APIs
  • Role-based access

Platform stack

  • React
  • Node.js
  • PostgreSQL
  • AWS
  • QueryAI

Screens

EcommPulse sales and units overview with gross sales, expenses, net profit and units across marketplaces
Sales and units across all marketplaces, with a per-marketplace chart.
EcommPulse revenue calculator looking up a product and comparing fulfilment costs
Revenue calculator: look up a product, compare fulfilment costs.
EcommPulse refund insights table with report type, status and potential refund
Refund insights: claims by type and status, with downloads.
EcommPulse marketing view comparing customer trends with a price-range control
Marketing: customer trends against a price range.
EcommPulse sales by region with a map of India and state-level figures
Sales by region: state-level gross sales, refunds and profit on a map.

More case studies