← Back to Work

Web Application · 2023 · Rock m Roll

Pro Seller Tools

10+ hours saved weekly for Amazon sellers

Role: Software Engineer

Node.jsReactMongoDBAmazon SP APIAdvertising API

10+ hrs

Time Saved

Per seller per week

2

APIs Integrated

SP API + Advertising

100%

Report Automation

No manual pulls

Daily

Data Freshness

Automated refresh

The Challenge

  • —Amazon sellers had no unified tool to track ad performance, COGS and fees in one place
  • —Processing large volumes of data from Amazon SP API and Advertising API efficiently
  • —Building secure multi-user access with role-based permissions for seller teams

Process

  • 01Designed MongoDB schema for high-volume order and advertising data storage
  • 02Integrated Amazon SP API and Advertising API for automated data synchronization
  • 03Built React dashboard with real-time metrics, ad performance charts and COGS tracking
  • 04Implemented JWT authentication and role-based access control for team collaboration
  • 05Created automated financial tracking to calculate Amazon fees and net margins automatically

The Solution

  • ✓Unified dashboard combining Amazon sales, advertising and financial data in one view
  • ✓Automated COGS and fee tracking saving sellers 10+ hours weekly
  • ✓Ad performance optimization tools with bid analysis and campaign insights
  • ✓Secure multi-user access with role-based permissions

Architecture

1

Data Aggregation Layer

Node.js backend polls Amazon SP API for sales, refunds, and fee data, and Advertising API for campaign metrics. Data is normalised and stored in MongoDB with daily refresh jobs.

2

React Dashboard

Single-page application built in React with charts for revenue trends, ACoS, ROAS, and profit margins per SKU. Sellers get the same view across all their Amazon accounts from one login.

3

Automated Financial Tracking

P&L calculated automatically from SP API fee breakdowns, COGs entered by the seller, and ad spend from the Advertising API. Exportable as monthly reports for accountants.

Takeaways

  • →Built a full MERN application solo from architecture to deployment
  • →Deep experience with Amazon SP API and Advertising API data structures
  • →Learned the value of automated financial tracking for e-commerce businesses