Client: A leading paint manufacturer with over 250 branches/depots across India and a network of more than 1 lakh painters and 40,000 influencers, including architects, builders, interior decorators, developers, and engineers. The distribution supply chain comprises numerous dealers who source materials from depots/branches, maintaining stock levels to meet demand.

Annual turnover: $ 1 Billion

Overview:

The client previously used a SaaS-based product to manage orders from painters and influencers, which then fed into another application for order execution. However, several limitations prompted the need for a customized solution.

Client’s Challenges & Pain Points:

1. Limitations of SaaS:
  • The SaaS product required the client to adapt their requirements to the platform’s available features.
  • Custom SKU structures had to be managed through an ETL process for integration with enterprise systems like Oracle OCI and CRM.
2. Inefficient Data Processes:
  • APIs were used in batch mode for updating dealer and influencer networks.
  • Market Offer Price (MOP) updates were effort-intensive during price revisions.
  • Replicating discounts and schemes involved significant manual effort.
3. Support Issues:
  • Resolution of support tickets was time-consuming.
  • Custom SKU structures had to be managed through an ETL process for integration with enterprise systems like Oracle OCI and CRM.
4. Multi-Tenant Database Concerns:
  • Sensitive data resided in a shared environment.

Solution:

The solution involves developing a custom e-commerce platform for selling paint products online. The administrator will manage product details, sellers, and buyers (e.g., contractors). The architecture will support scalability and onboarding of end clients.

Benefits:

The client previously used a SaaS-based product to manage orders from painters and influencers, which then fed into another application for order execution. However, several limitations prompted the need for a customized solution.

Product Management:
  • Product cataloging and banners.
  • Product comparison functionality.
  • Advanced filtering and search capabilities for easy product discovery.
User Onboarding:
  • Registration and profiling for contractors, painters, and influencers.
  • Onboarding of authorized dealers with verification processes.
Order Management:
  • GPS/voice integration for order placement and site selection.
  • Shopping cart with quick order navigation.
  • Order placement with dealer assignment (dedicated or nearest dealer via round-robin assignment with geo-tagging).
  • Order tracking and real-time status updates.
Pricing & Promotions:
  • Management of Market Offer Prices (MOP), schemes, coupons, and discounts.
  • Automated price adjustments based on demand and stock levels.
Payment & Billing:
  • Online and offline payment processing with multiple gateways.
  • Secure transactions with encrypted payment processing.
  • Invoice generation and re-billing options.
  • Credit-based payment options for authorized dealers.
Dealer Incentives:
  • Month-end dealer incentives to encourage engagement.
  • Automated calculations for incentive payouts.
Shipping:
  • Multiple shipment options with real-time tracking.
  • Integration with third-party logistics providers for enhanced delivery efficiency.
  • Warehouse management system integration.
Data Analytics & Reporting:
  • Dynamic dashboards providing insights into sales, inventory, and performance metrics.
  • Google Firebase & Analytics for real-time monitoring.
  • AI-driven predictive analytics for demand forecasting.
  • Multiple reports for in-depth business analysis.
Enterprise Integration:
  • Integration with ERP/CRM systems such as Salesforce and Oracle OCI.
  • Real-time data synchronization to ensure consistency across platforms.
Marketing Automation Integration:
  • SMS (via Berger Registered Partner – Airtel).
  • Facebook SDK for client accounts.
  • AI-driven personalized marketing campaigns.
Security & Compliance:
  • Role-based access control (RBAC) for user permissions.
  • Smart data security and user identity management with JWT/Refresher Tokens.
  • Compliance with industry standards and data protection regulation.
Quantifiable Benefits:
  • Enhanced operational efficiency.
  • Real-time data processing and reporting.
  • Faster resolution of support issues.
Technology Stack:
  • Core Technology: .NET Core, Azure Cloud
  • Design Tools: Figma
  • Database: SQL Server
Project Features for Platforms:
  • For Buyers & Sellers:
    • Android App
    • iOS App
    • Responsive Web Portal (compatible with top browsers)
For Admins:
  • Responsive Web Portal (compatible with top browsers)