CHALLENGE
Fragmented reporting workflows across orders, delayed bi-weekly settlements, PPC ad spend, and hidden FBA storage fees made product-level net profitability invisible.
SOLUTION
Built a high-density intelligence platform combining Django REST, Celery/RabbitMQ async data pipelines, and Vue 3/Vuetify to provide reliable, near-real-time multi-account P&L insights.
Key Features
Profitability Analytics — Unified sales and profit reporting, category-level analysis, storage fee tracking, order payment reconciliation, traffic-performance correlation
Dashboard Intelligence — KPI summary widgets, sales/profit comparison views, top-gainer and top-loser analysis, top-10 product insights, period-based product metrics
Catalog & Product Management — SKU and seller ID management, manufacturing cost configuration, organic keyword tracking, product tagging, keyword position timelines
Data Ingestion & Synchronization — Amazon account onboarding, marketplace authorization flows, async report pulling, scheduled background processing, import template workflows
Operational Data Exchange — Configurable export templates for orders and products, export parameterization, file import pipelines, report export dialogs, CSV-based manager assignments
Alerting & Monitoring — Alert rule settings, alert status management, model-based alert tracking, activity logging, centralized error observability via Sentry
Access & Team Administration — Token-based authentication, Google login support, password reset flow, user/group/team management, role-aware permissions and profile controls
TECH STACK
Python 3.12DjangoDjango REST FrameworkCeleryRabbitMQRedisPostgreSQLVue 3VuetifyVitePiniaAmazon SP-API SDKSentryBoto3Docker Compose
INTEGRATIONS
- Amazon Selling Partner API (SP-API) – Pulls marketplace, product, finance, inventory, and report data for account-level synchronization
- Amazon Advertising API – Supports ads authentication and PPC-related data workflows
- Google OAuth – Enables Google-based login flow for user authentication
- Sentry – Captures backend and frontend exceptions for production monitoring and incident triage
- AWS Services (via Boto3 / django-storages / django-ses) – Supports cloud storage and email delivery infrastructure
RESULT
Immediate Profit Clarity
