Develop Advanced Chemical Database Website with Search, RFQ, Orders & AI Chatbot

Project Description

We are Quimera Speciality Chemicals, a speciality chemical trading and distribution company in India.

We are planning to develop a modern chemical database and customer-facing website similar in functionality to companies like Tokyo Chemical Industry, BLD Pharmatech, and ChemScene.

We already have large chemical product data available in Excel and scraped datasets. We need a high-performance website that allows customers to search products, request quotations, place orders, download documents, and track shipments.

This project requires database-driven functionality, not a simple static website.

Main Objectives

Develop a fast, scalable chemical product website that includes:

Advanced chemical search
Online quotation system
Online order placement
Order tracking
Product document downloads
AI chatbot integration
Professional character-based assistant
SEO-ready structure
Mobile-friendly responsive design
Core Features Required
1. Advanced Chemical Search System (Most Important)

Search must support:

CAS Number Search
Product Code Search
Chemical Name Search
Molecular Formula Search
Synonym Search
Category Search

Search Results Must Display:

Product Name
CAS Number
Molecular Formula
Molecular Weight
Purity
Grade
Available Pack Sizes
Stock Availability (if enabled)
Add to Quote
Add to Cart

Search must be very fast, even with large datasets.

2. Product Detail Page Structure

Each product page must include:

Product Name
CAS Number
Synonyms
Molecular Formula
Molecular Weight
Chemical Structure Image
Applications
Product Specifications
Storage Conditions
Hazard Information

Download Section:

MSDS (PDF)
COA (PDF)
TDS (optional)
Technical Documents
3. Online Quotation System (RFQ)

Customers must be able to:

Add multiple products to quotation list
Submit RFQ (Request for Quote)
Receive quotation confirmation
Share quotation requests via Email or WhatsApp
Convert RFQ into order
4. Online Order Placement

Customers should be able to:

Place orders online
Upload Purchase Orders (PDF or Image)
Select shipping preferences
Receive order confirmation
5. Order Tracking System

Customers must be able to:

Track order status
View dispatch updates
View shipment details
Download invoices or order documents

Order status example:

New → Processing → Packed → Dispatched → Delivered

6. Product Document Management

Customers must be able to:

Download MSDS files
Download COA files
Access technical documents
Search documents easily

Documents must be:

Linked to respective products
Easy to download
Organized properly
7. Data Integration (From Existing Product Data)

We already have:

Excel files
Scraped chemical product data
Product specifications

Required:

Import data into structured database
Create searchable product catalog
Maintain data accuracy
8. AI Chatbot Integration

We want an AI-powered chatbot integrated into the website.

Chatbot should:

Help customers search products
Provide product information
Guide customers through RFQ process
Provide MSDS links
Answer common queries

Also preferred:

WhatsApp chatbot integration
9. Character Bundle (Brand Mascot)

We want a professional character-based assistant integrated into the website.

The character will:

Guide users visually
Be part of chatbot interface
Be used in marketing materials
Improve brand recognition

Required Deliverables:

Custom character design
Multiple poses
Expressions
Icons
Website-friendly graphics

This feature is intended to create a unique brand identity.

10. SEO Optimization (Very Important)

Website must include:

SEO-friendly URLs
Product metadata
CAS number optimization
Sitemap
Structured schema markup
Google indexing readiness

Goal:

Improve search visibility for chemical products.

11. Performance Requirements

Website must:

Load quickly
Handle 50,000+ products
Support large product databases
Be scalable for future growth

Preferred Technologies:

(Developer may suggest alternatives)

Backend: Laravel / Node.js / Django
Database: PostgreSQL / MySQL
Frontend: React / Vue
12. Website Pages Required
Home Page
About Us
Product Search Page
Product Detail Page
Categories Page
RFQ Page
Cart Page
Customer Dashboard
Order Tracking Page
Contact Page
Blog Page
Technical Library
Data Volume (Estimated)

Expected:

50,000 to 100,000 products
Large MSDS library
Continuous data growth
Deliverables

Expected deliverables include:

Fully functional website
Database setup
Product data import
Performance optimization
Testing
Deployment
Basic user training
Developer Requirements

Looking for developers with:

Experience building database-driven websites
Experience handling large datasets
Strong UI/UX design capability
Experience with product catalog systems

Portfolio required.

Prefer:

Milestone-based payment.

Optional Future Features (Phase 2)

These may be developed later:

Chemical structure drawing search
AI-based product recommendations
Automated product suggestions
OCR-based purchase order reading
Drag-and-drop order proc