Vincent Aboy

Selected work / ProductWatch

ProductWatch

Pulls product, stock and order data from BaseLinker and Trendyol into one dashboard, with order analytics and a searchable product table.

  • React
  • TypeScript
  • PostgreSQL
  • BaseLinker
  • Trendyol

Built for an e-commerce company. Jan 2026 to May 2026; still running.

screenshot coming soonProductWatch version 2 dashboard with total SKUs, orders today, revenue today and recent orders

Version 2 dashboard on live data, screenshot from the running app in 2026. Total products, orders and revenue today, recent orders and a searchable product table.

Product table with product code, SKU, name, price, stock, total units sold and total orders
Latest products
Pop-up with one product's total items, total orders, average items per order, first and last order and last net price
Order item stats
Orders dashboard with total orders, orders today, monthly order volume and revenue trend
Orders dashboard
Orders by month with totals, a monthly breakdown table and order share per month
Orders by month
Orders and units per month, and value trend in thousands of RON
Monthly orders and value charts
Daily orders for one month with average per day, peak day and total value
Daily orders
Daily value in RON and a 7-day rolling average of orders
Daily value and 7-day average
Daily breakdown table with orders, units, value and comparison to average
Daily breakdown, 1 of 2
Daily breakdown table, continued, with orders, units, value and comparison to average
Daily breakdown, 2 of 2
Order-level lines for one day with order ID, product, quantity, price, shipping and total
Transactions for one day

The problem

Product, stock and order data sat in BaseLinker and Trendyol, with no single view across them. To see how many orders came in today, which products were selling, how orders and revenue moved month to month, or what was running low, someone had to open each platform by hand every day. Low stock was easy to notice too late.

What I built

A React and TypeScript dashboard that pulls stock, order and listing data from BaseLinker and Trendyol into PostgreSQL on a schedule, so leadership could see stock levels and orders in one place.

  • Overview: total products, orders and revenue today, and recent orders.
  • Products: a searchable product table with stock, price, units sold and order counts, plus per-product order statistics.
  • Orders: monthly and daily order volume and value, and order lines for any day.
  • Trendyol: a page for the Trendyol listings.

How it works

  1. BaseLinker and Trendyol
  2. Scheduled retrieval
  3. PostgreSQL
  4. React dashboard

What it changed

~15 min → a few min daily

Leadership used it daily to check stock levels, orders and low-stock warnings in one place. I estimate the daily check went from 10 to 20 minutes to a few minutes. That is my own estimate, not a measured figure.

Stock warnings supported earlier reorders and supplier follow-up.

My role

I designed it and set the workflow and business rules, and built it with AI coding assistants under my direction.

Skills shown

API integration (BaseLinker, Trendyol), PostgreSQL, React and TypeScript, scheduled data jobs, order analytics, dashboard design, working with AI tools.