CHALLENGE
Lenders and liquidation analysts spent days manually collecting and computing Amazon sales velocity and stock liquidation metrics in spreadsheets with high margin for human error.
SOLUTION
Built Velocity System on Django 5.2, Celery, Vue 3/Vuetify, Keepa, SmartScout, and Snowflake to automatically compute stock availability, liquidation value, and Net Order Line Value (NOLV) with a complete audit trail.
Key Features
Evaluation Request Management — Organize work into named project envelopes per company, attach notes and context, manage multiple concurrent analyses across clients
Product Submission Workflow — Upload and manage product lists (ASINs/UPCs), trigger automated data collection from external providers, track collection status per submission line item
Automated Evaluation Engine — Background processing via Celery workers, configurable data source (Keepa, SmartScout, Average) and time period (30d–18mo), real-time status and progress-percentage tracking
Financial Metric Computation — Calculate stock availability, historical sales velocity, liquidation value per unit, expected value flow, and NOLV with full per-step audit trail stored per product result
NOLV & Price Distribution Modeling — Triangular price distribution adjusted for seller competition pressure and product ratings, availability-weighted cash flow projections, configurable base-price and skew coefficients
Company & User Administration — Multi-company tenancy, role-based access control (CASL), customer invitation flow, password reset, and permission-gated UI rendering
Data Snapshots & Provider Logs — Store raw API responses to S3 for auditability, normalize provider-specific formats into a universal snapshot schema, support Keepa and SmartScout as interchangeable data sources
TECH STACK
Python 3.14Django 5.2Django REST FrameworkCeleryRabbitMQPostgreSQLVue 3TypeScriptVuetify 3VitePiniaApexChartsAWS S3SnowflakeTerraformDockerSentryGunicorn
INTEGRATIONS
- Keepa – Amazon product history API: fetches BuyBox prices, sales rank, out-of-stock days, and monthly sales data per ASIN for evaluation inputs
- SmartScout – Amazon market intelligence platform accessed via Snowflake connector; provides an alternative data source for sales velocity and pricing metrics
- AWS S3 – Raw API response archiving (audit trail), file storage for submission artifacts and exported reports
- Amazon SES – Transactional email delivery for user invitations, password resets, and system notifications
- Sentry – Error monitoring and performance tracing across backend and Vue frontend
RESULT
Instant, Audit-Ready Lending Intelligence
