Ubícate - Local business directory

Platform designed to bridge the gap between small businesses and the community in Mosquera. It serves as a comprehensive directory and marketplace where local merchants can establish an online presence without technical barriers, while residents can easily discover products, services.

Live Demo View Source
Ubícate - Local business directory

The Problem

Local micro-enterprises in Mosquera often lack the resources or technical expertise to maintain their own websites or compete on major e-commerce platforms. This invisibility limits their growth and prevents the local community from discovering nearby services. Residents effectively had no centralized way to find specific products or verify business hours and locations without physically visiting them.

The Solution

I developed a web-based platform that democratizes digital visibility for local merchants, featuring a smart search engine to find businesses by name, product, price, or keywords, a merchant dashboard with an easy CMS for managing profiles and products, a product showcase with optimized images for fast loading, and built-in lead generation that connects buyers directly with verified merchants through contact info, location, and hours.

My Role

Full stack developer

Tech Stack

HTML5 CSS3Bootstrap jQueryPHPMySQLGoogle AnalyticsGoogle AdSense

Key Decisions

  • 1

    Vanilla PHP implementation: I chose native PHP over heavy frameworks to maximize performance on shared hosting environments and to have granular control over the application's resource usage, which kept operational costs near zero.

  • 2

    File system image storage: Instead of using expensive cloud object storage, I implemented a local file storage strategy using a composite naming convention (User ID + Business Name + Product Name). This reduced dependencies and kept the architecture self-contained.

  • 3

    Server-side rendering (SSR): The application uses PHP for SSR to ensure maximum SEO performance. This is critical for a directory site, ensuring that search engines can easily index every business and product page so they appear in Google search results.

  • 4

    Mobile-first design: recognizing that users searching for local businesses are predominantly on the go, the UI was built with a "mobile-first" philosophy using Bootstrap's grid system to ensure perfect usability on smartphones.

Screenshot Gallery

Ubícate - Local business directory Screenshot