Case Study

Inquiry Management System (IMS)Procurement Inquiry Automation & Vendor Communication

The Inquiry Management System (IMS) is a web‑based platform built with React.js, .NET Core, Python, and SQL Server that automates the full inquiry lifecycle.

USA
Supplier/Vendor Management
Hero-Image

Project Detail

The Inquiry Management System (IMS) is a web‑based platform built with React.js, .NET Core, Python, and SQL Server that automates the full inquiry lifecycle: Users raise chemical‑product inquiries. Parallel Python “grabbers” fetch supplier emails from SMTP/IMAP/POP mailboxes and internal databases. IMS sends bulk, templated inquiry emails to selected suppliers. Incoming replies are automatically parsed and linked to their original inquiry. All inquiries, responses, and user actions are logged centrally for real‑time visibility and audit.

Client Overview

Echemportal is a chemical‑products company that manages a broad network of suppliers and needs a centralized system to automate vendor inquiries, track supplier responses, and maintain a structured vendor database for its internal procurement workflows.

Industry

Supplier/Vendor Management

Project Type

Internal B2B Inquiry Management Platform

Technologies

React.js
.NET Core
Python
SQL Server
SMTP, IMAP/POP
JavaScript
C#

Major Features Delivered

Comprehensive solutions designed to enhance user experience and drive business growth.

Inquiry Management Module

Handles end-to-end inquiry processing: Initialize Inquiries: Send inquiries using grabbers and store vendor data. Define Inquiries: List and track sent inquiries. Processed Inquiries: Review vendor responses. Unmapped Responses: Identify replies that do not match any inquiry. Inquiry History: Full action log for audit and traceability. Delete Inquiry: Remove outdated inquiries while preserving records.

Product Module

Products: Manually manage product data not captured by grabbers, with EchemProductId and Chem Browser ProductId mapping.

Vendor Module

Master Vendors: Maintain a database of active vendors. Vendor Groups: Organize vendors by region, expertise, or tier. Vendor Preference: Set default vendor priorities. Unregistered Vendors: Track potential vendors pending registration. Deleted Vendors: Log removed vendors for traceability.

Configuration Module

Email Templates: Create and manage multiple email formats for inquiries, quotations, etc. Email Sync Settings: Configure SMTP for sending emails from a designated sender ID.

Challenges & Solutions

We identified key pain points and developed targeted solutions to transform the resort's digital presence.

Challenges

Disparate Data Sources

Manually locating supplier records across multiple databases and mail servers was slow and error‑prone.

Inefficient Email Outreach

Sending individual inquiry emails led to inconsistent messaging, missed replies, and delays.

Response Mapping Errors

Manually matching supplier replies to inquiries resulted in lost or misfiled responses.

Lack of Audit Trail

No centralized history made compliance reporting and issue investigation difficult.

Inconsistent Communications

Different users crafted emails in varied formats, weakening brand consistency and clarity.

Solutions

Parallel Python Grabbers

Lightweight, concurrent processes that continuously harvest supplier data and emails from multiple sources, eliminating manual lookups.

Bulk Templated Email Dispatch

A built‑in templating engine for sending hundreds of branded, structured inquiries at once—ensuring speed and consistency.

Automated Reply Parsing & Linking

An email‑reading service that extracts metadata from incoming mail and automatically associates replies with their original inquiry records.

Centralized Dashboard & Audit Log

A React.js console displaying inquiry statuses, response timelines, and a complete, immutable action history for compliance and reporting.

Standardized Communication Framework

Managed email templates and configuration settings enforce uniform, professional messages and reduce follow‑up clarifications.

Project Snippets

Visual highlights showcasing the transformation and key features of the new website.

Projrct Snippetsechem-eps
Projrct Snippetsechem-eps
Projrct Snippetsechem-eps
Projrct Snippetsechem-eps
Projrct Snippetsechem-eps
Projrct Snippetsechem-eps

Ready to Build Something Amazing?

Let's discuss your project and create a custom web application that drives your business forward. Get started with a free consultation today.

Call us: +1-945-209-7691
Email: inquiry@mol-tech.us
2000 N Central Expressway, Suite 220, Plano, TX 75074, United States

Business Value Provided

Faster Procurement Process

Faster Procurement Process

Accurate Inquiry Tracking

Accurate Inquiry Tracking

Enhanced Transparency & Auditing

Enhanced Transparency & Auditing

Stronger Supplier Engagement

Stronger Supplier Engagement

Informed Decision Making

Informed Decision Making

Operational Efficiency Gains

Operational Efficiency Gains

Connecting Continents, Empowering Businesses
Our branch offices ensure seamless support across the globe.
USA flagUSA
12
3
6
9
00:00
2000 N Central Expressway
Suite 220
Plano, TX 75074
United States
inquiry@mol-tech.us
+1-945-209-7691
Singapore flagSingapore
12
3
6
9
00:00
408 Joo Chiat Place
Singapore (428085)
inquiry@mol-tech.us
+65 8753 5833
Switzerland flagSwitzerland
12
3
6
9
00:00
Kirchmooshöhe 4
4800 Zofingen
inquiry@mol-tech.us
India flagIndia
12
3
6
9
00:00
5th Floor, 506,
Dwarkesh business hub
Opp. Visamo Society, Motera,
380005, Ahmedabad, Gujarat
inquiry@mol-tech.us
+91 81286 94374