Stock Data Processing API
REST API for automated CSV ingestion of stock movements, FG aging data, and paper roll logs — deployed live on Render
CATEGORY
Python / API
STATUS
Live
TECH STACK
The Problem
What This System Was Built to Solve
Warehouse and production teams generated daily data exports from multiple operational systems in CSV format. Manual import processes introduced delays, transcription errors, and inconsistent records across stock categories — slowing down reporting and decision-making.
The System
What Was Built
A Flask REST API deployed on Render that serves as the data ingestion layer for warehouse and stock operations. Teams upload daily CSV exports through secured API endpoints — the API validates, processes via Pandas, and loads the data directly into MySQL. Handles five data types: stock-in, stock-out, issued/return movements, finished goods aging, and paper roll logs. API key authentication secures all endpoints.
Capabilities
Key Features
Core capabilities built into this system — designed around operational workflow, not feature checklists.
Dedicated endpoint per data type: stock-in, stock-out, issued/return, FG aging, paper roll
CSV validation and transformation via Pandas before database write
API key authentication on all upload endpoints
Direct MySQL write with structured error handling
Deployed live on Render with always-on availability
Supports daily automated upload pipelines from any source
Work Together
Need something
similar built?
Every system starts with an operational problem. No obligation — discussions are practical and workflow-first.