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 processing My Suggestion (Very Important) Before posting this project, you should also prepare: Estimated product count (exact number) Sample Excel file (5–10 products) Sample MSDS & COA files