Industry
Automotive and Retail Service
Technologies
Angular, .NET Core, Microsoft SQL Server
About Our Client
The client is a Tier-1 European automotive manufacturer headquartered in Germany, with a network of over 400 authorized B2B dealers and service centers across Europe. The company supplies OEM and aftermarket parts to partners and needed a scalable digital solution to streamline part ordering and reduce dealer support dependency.
Challenge
The client relied on outdated email-based and spreadsheet-driven order processing, which led to delays, miscommunication, and order errors. The lack of self-service access and real-time inventory data was a major pain point for distributors.
Key problems:
- Need for secure access control by dealer role/location
- Manual parts ordering is causing processing delays
- Frequent order fulfillment errors due to a lack of system checks
- No real-time stock visibility for dealers
- High dependency on customer support for status tracking and invoices
Solution
Celestial Infosoft partnered with the client to develop a robust B2B Parts Ordering Web Portal, tailored for their dealer ecosystem. The solution was tightly integrated with their ERP (SAP) and hosted on Microsoft Azure for high availability and performance.
Solution Features:
- Mobile & Tablet-Optimized UI for warehouse access
- Advanced Part Search & Filtering with category, SKU, and vehicle compatibility
- Real-Time Inventory Sync with SAP via REST APIs
- Role-Based Access Control using Azure Active Directory
- Multi-Tiered Dealer Dashboard to manage orders, returns, and credits
- Order Tracking & Notifications via email and portal alerts
- PDF Invoices & Historical Orders are exportable directly from the portal
Project Highlights
- Integrated with SAP ERP for inventory and pricing sync
- 3-layer dealer permission model: distributor, dealer, service center
- Built with enterprise-grade architecture on Microsoft Azure
- Delivered in 16 weeks, including full UAT with 50+ dealers
- Multilingual support: English, German, French
Results
- Reduced order processing time from 3 days to real-time
- 60% fewer invoice queries reported to support staff
- 30% increase in order volume within the first 6 months
- Centralized dealer authentication using Azure AD
- Real-time tracking reduced order status inquiries by over 50%
Technologies and Tools
- Frontend: Angular 14, TypeScript
- Backend: .NET Core 6.0, Entity Framework
- Database: Microsoft SQL Server
- Cloud Hosting: Microsoft Azure (App Services, Blob Storage)
- Authentication: Azure Active Directory (AAD)
- Integration: REST APIs for SAP ERP
- Monitoring & DevOps: Azure Monitor, GitLab CI/CD
Client Feedback
“We were impressed by Celestial’s ability to understand the complexity of our B2B network and ERP systems. The portal transformed our entire supply chain interface it’s faster, more accurate, and exactly what our dealers needed.”
– Client Says
