Ajio Return Tracking
The Bottleneck
"E-commerce sellers on Ajio struggle with tracking thousands of returns manually, leading to lost inventory and unclaimed refunds."
Key Features
Automated Return Status Sync via Logistics APIs
Claim Filing Assistant for Lost/Damaged Shipments
Real-time Analytics on Return Reasons & SKU Performance
Centralized Dashboard for Multi-Account Management
Automated Alerts for stalled or delayed returns
The Architecture
Developed an automated dashboard that syncs with logistics partners to track return shipments in real-time and flag discrepancies.
Overcoming Challenges
Scraping and standardizing data from multiple logistics provider portals.
Handling inconsistent return status updates from courier APIs.
Designing a UI that can handle thousands of active return rows efficiently.
Protocol & Process
Analyzing the return lifecycle of Ajio sellers to identify pain points.
Reverse-engineering courier tracking APIs for real-time status updates.
Building a robust background job system for periodic data syncing.
Designing a high-density data grid for efficient bulk operations.
Engineered Impact
Recovered over $50k in lost inventory value by identifying undelivered returns and automating claim filing.