Get Quote
Home Projects Steel Mumbai

Steel Mumbai.

A premium Vercel-inspired B2B directory portal mapping 300+ steel suppliers and 140+ material products in Mumbai.

Steel Mumbai showcase visual

SteelMumbai.com is a high-performance, search-engine-optimized B2B directory designed to connect global buyers with verified steel stockists, fabricators, and manufacturers in Mumbai (Girgaon, C.P. Tank, and Khetwadi).

Built using a zero-dependency vanilla PHP architecture, the portal delivers sub-0.3 second page speeds and ranks first for high-intent maritime sourcing keywords.

A to Z Project Lifecycle Breakdown

A. Core Requirements

  • Zero-Dependency Stack: Pure PHP frontend routing, MySQL InnoDB database.
  • Aesthetics: Vercel-inspired stark design system (ink black text, clean canvas backdrop, mesh gradients, and monospaced layout metadata).

B. Database Schema & Architecture

The relational model matches industrial inventory dynamics:
  • businesses: Manages supplier profiles, contact numbers, map embeds, verified status, and dynamic ratings.
  • products: Holds steel grades, dimensions, custom specifications list, and SEO titles.
  • business_product: Junction join table mapping many-to-many supplier/material associations.
  • blogs: Manages price alerts, regulatory updates, and blog entries.

C. URL Routing & Front Controller

Uses a Front Controller pattern (router.php) to resolve public clean URLs:
  • Enforces automatic 301 redirects for legacy .html extensions.
  • Implements a trailing slash gate (adds slashes for directory folders, strips them for detail sitemaps).
  • Integrates a fuzzy matching algorithm to redirect partial query match variations and minimize search console index bloat.

D. Automated Database Seeding

Features a programmatic seed_injector.php containing over 300 verified suppliers and 140 products embedded as static PHP array nodes, allowing one-click data installation.

E. Deployment & Optimization

  • WebP Compression Pipeline: Implemented an automated graphics script that transcodes uploaded supplier logos and product diagrams into lightweight WebP format.
  • Sitemap Protocols: Features dynamic sitemap generations matching modern indexing structures (ignoring priority/changefreq fields and mapping file System timestamps).

---

Project Outcomes

  • Indexability: Commands 100/100 Core Web Vitals score.
  • Conversion: Captures real-time WhatsApp RFQ submissions directly from product specification tables.