Skip to content

jenilrupapara001/retail-ops

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

98 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

GMS Dashboard Pro β€” Technical Manual & Architecture Guide

Project Version Infrastructure Visuals

GMS Dashboard Pro is an enterprise-grade E-commerce Intelligence Platform tailored for high-volume Amazon India operations. This document provides an exhaustive technical deep-dive into the platform's architecture, data models, automated pipelines, and intelligence layers.


πŸ›οΈ System Architecture

The platform is designed around a Service-Oriented MERN Stack, prioritizing data integrity, high-speed aggregations, and automated marketplace synchronization.

1. High-Level Ecosystem

graph TD
    subgraph "Frontend Layer (React 19)"
        UI[Pro Dashboard UI] --> Store[Context API / State]
        Store --> Components[ApexCharts / Tabler Icons]
    end

    subgraph "API Gateway (Express.js)"
        API[API Router] --> Middleware[Auth/RBAC Middleware]
        Middleware --> Controllers[Module Controllers]
    end

    subgraph "Automation & Intelligence"
        Controllers --> Sync[Octoparse Sync Service]
        Sync <--> Jobs[Self-Healing Sync Loops]
        Controllers --> AI[Perplexity / NVIDIA NIM SDK]
    end

    subgraph "Persistence Layer"
        Controllers --> MongoDB[(MongoDB Atlas)]
        MongoDB --> Models[Mongoose Schema Layer]
    end
Loading

πŸ“‚ Project Structure (Full Tree)

gms-dashboard/
β”œβ”€β”€ backend/                # Node.js / Express Server
β”‚   β”œβ”€β”€ config/             # DB & App Configuration
β”‚   β”œβ”€β”€ controllers/        # Business Logic (30+ Controllers)
β”‚   β”œβ”€β”€ cron/               # Scheduled Task Orchestration
β”‚   β”œβ”€β”€ middleware/         # Auth, Upload, RBAC Logic
β”‚   β”œβ”€β”€ models/             # Mongoose Schemas (33 Models)
β”‚   β”œβ”€β”€ routes/             # REST API Definition
β”‚   β”œβ”€β”€ services/           # External API Wrappers (Octoparse, NIM)
β”‚   β”œβ”€β”€ uploads/            # Local Asset Storage (ASIN Images)
β”‚   └── utils/              # Calculation & Validation Helpers
β”œβ”€β”€ src/                    # React 19 Frontend
β”‚   β”œβ”€β”€ components/         # Premium UI Component Library
β”‚   β”œβ”€β”€ contexts/           # Global State Management
β”‚   β”œβ”€β”€ hooks/              # Reusable Logic (API, UI)
β”‚   β”œβ”€β”€ pages/              # Module-Specific Views
β”‚   β”œβ”€β”€ styles/             # Zinc Design System Utilities
β”‚   └── utils/              # Frontend formatting & UI logic
β”œβ”€β”€ public/                 # Static Assets
└── package.json            # Core Dependencies (ApexCharts, Lucide, etc.)

πŸ—„οΈ Database Strategy & Core Schemas

The system utilizes MongoDB Atlas for document-oriented storage, with heavy optimization for time-series data (Ads) and relational-like tracking (ASINs).

1. Asin Model (The Platform Anchor)

The Asin model is a sophisticated document that tracks 110+ data points including:

  • Identity: ASIN, SKU, Seller ID, Brand, Category.
  • Market State: currentPrice, bsr, rating, reviewCount, soldBy.
  • Historical Arrays:
    • history: Daily snapshot of Price/BSR/Rating.
    • weekHistory: Week-over-week performance metrics for trend analysis.
  • Intelligent Wrappers: lqsDetails (Listing Quality Score) and feePreview (FBA Profitability).

2. AdsPerformance Model (Attribution Engine)

Optimized for daily/monthly performance tracking:

  • Core KPIs: Spend, Sales, Impressions, Clicks, Orders.
  • Attribution Logic: Automated calculation of ROAS, ACoS, CTR, and AOV.
  • Indexing: Partial unique indexes ensure zero data duplication at the ASIN + Date + reportType level.

3. Action & Goal (OKR Hierarchy)

Supports the AI-driven strategy layer:

  • Goal: High-level business intent (e.g., "Improve Margin").
  • Action: Decomposition of goals into trackable tasks with Time to Complete and Status loops.

πŸš€ Advanced Module Capabilities

πŸ›‘οΈ ASIN Manager Pro (Horizontal Layout)

The redesigned ASIN interface provides a "Mission Control" experience:

  • Horizontal Product Intelligence: A top-bar summary housing all vital stats + live Buy Box monitoring.
  • ApexCharts Triple-Stack:
    • Price History: Indigo area chart with gradient fills.
    • BSR Trend: Emerald line chart with Reversed Y-Axis (Top ranking visibility).
    • Rating Progression: Amber line chart for long-term customer sentiment tracking.
  • Smart Filtering: Integrated range selectors (7D, 30D, 90D, All) that slice through historical arrays in real-time.

πŸ€– Automation Service (Octoparse Engine)

The octoparseAutomationService manages complex web-scraping lifecycles:

  • Self-Healing Sync: When local data deviates from marketplace reality, the system automatically queues a background scrape.
  • Concurrent Orchestration: Manages 100+ concurrent seller tasks with automated retry and fallback logic.
  • Data Reconciliation: Ingests disparate marketplace results into the unified Asin history layer.

🧠 Intelligence & AI Layer

πŸ–ΌοΈ NVIDIA NIM Image Optimization

  • SD3 Workflow: Automatically generates high-quality lifestyle images for ASINs failing the LQS image count threshold (< 7).
  • Automation: Triggered directly from the ASIN Manager when "Image Optimization" is required.

🎯 Perplexity AI OKR Engine

  • Decomposition: Uses advanced LLM prompts to split vague intentions into 4-week execution plans.
  • Validation: Ensures every task generated is measurable against marketplace KPIs (ACoS, ROAS).

πŸ› οΈ API Reference & Key Endpoints

asinController.js

  • GET /api/asins: Unified list with seller filtering and aggregation.
  • PATCH /api/asins/:id: Partial updates for LQS and marketplace status.
  • POST /api/asins/sync: Manual trigger for the Octoparse orchestration.

uploadController.js

  • POST /api/upload/ads-data: Complex CSV parser with Case-Insensitive Header Mapping supporting standard Amazon Advertising reports.

πŸš€ DevOps & Maintenance

1. Environment Management

  • Production-grade .env includes secrets for Clerk Auth, Keepa SDK, Octoparse API, and NVIDIA NIM.

2. Performance Optimization

  • MongoDB Indexing: Compound indexing on asinCode + seller and date + reportType ensures sub-100ms query performance on 1M+ records.
  • Vercel Edge Rendering: The frontend is optimized for zero-latency loading of massive DataTables.

🎨 Design System: Zinc Pro

Built on a bespoke design system focusing on Clarity and Precision.

  • Typography: Inter (UI) / Outfit (Header) for maximum readability.
  • Grid: 24px unified corner-radius system.
  • Effects: 12px Backdrop Blur (Glassmorphism) for focused detail modals.

πŸ“„ License & Proprietary

Β© 2026 Easysell Projects. Distributed under the ISC License. Confidential and Proprietary. All Rights Reserved.

About

Retail Ops is a MERN-based BI and execution platform for Amazon sellers that unifies OKR management, ASIN analytics, structured task workflows, real-time updates, and AI-driven goal generation into a scalable dashboard. Built with strict RBAC, multi-tenant isolation, and performance tracking for enterprise retail operations.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors