After Sales Vendor Management System — Case Study
ProductAssistant Product Manager2024-02

After Sales Vendor Management System

An enterprise supply chain solution for a major retail chain, optimizing the lifecycle of perishable goods from demand forecasting to vendor returns.

Share

Project Overview

I spearheaded the development of an enterprise supply chain solution for the largest retail chain in Bangladesh, designed specifically to digitize the entire after-sales lifecycle for perishable items. The core business problem was that demand quantities given to vendors were completely invisible throughout the fulfillment cycle. Rejected items could not be systematically tracked for vendor quality ratings, and business opportunity losses due to under-fulfillment remained unquantified. Communication was fragmented across phone calls and WhatsApp, leading to massive inefficiencies. My approach involved deep requirement analysis and process mapping using Visio to understand the pain points of outlet managers and category teams. I then engineered a multi-stakeholder platform architecture featuring modules for Demand Declaration, Delivery Verification (including strict QC rejection tracking), Sales Reconciliation, and Wastage Management. I utilized Figma to prototype the user interfaces, ensuring high adoption rates among non-technical staff. The outcome was a centralized, data-driven platform that provides real-time visibility into vendor performance and fulfillment rates. We achieved 100% tracking of demand versus delivery for perishables, enabled data-backed vendor ratings based on actual rejection rates, and successfully quantified lost business opportunities. This system fundamentally transformed how the retail chain manages its perishable goods vendors, replacing chaos with structured, actionable data.

The Challenge

Demand quantities given to vendors were invisible throughout the cycle, rejected items couldn’t be tracked for vendor quality ratings, and business opportunity losses due to under-fulfillment were unquantified.

The Solution

Engineered a multi-stakeholder platform with modules for Demand Declaration, Delivery Verification (with QC rejection tracking), Sales Reconciliation, and Wastage Management. The system provides real-time visibility into vendor performance and fulfillment rates.

Key Features

Automated Demand Forecasting & Declaration
Quality Control (QC) Rejection Tracking
Daily Sales & Wastage Reconciliation
Vendor Return & Gate Pass Management
Real-time Performance Dashboards (Fulfillment/Rejection)
Site-specific Vendor & Item Mapping

Technologies Used

Product StrategyFigmaVisioProcess MappingRequirement AnalysisAgile

Project Impact

  • 100% tracking of demand vs. delivery for perishables

  • Enabled data-backed vendor ratings based on rejection rates

  • Quantified lost business opportunities through fulfillment metrics

  • Streamlined communication between outlet managers and category teams