NegociosCRM.com

Find hard-to-locate local products and services nearby, ranked by availability, opening hours, and distance, with privacy controls for home-based sellers.

Comment 5

Inspiration

Many small and home-based businesses offer useful products and services but are difficult to discover online, especially outside regular business hours. NegociosCRM.com was created to connect a person's specific need with the closest available local option while protecting the privacy of informal and home-based sellers.

What it does

NegociosCRM.com is a hyperlocal search platform for products and services that are often difficult to find online.

Users can search for a specific need, such as beetroot juice, an HP mouse, carpentry, or dental care. After confirming or manually selecting their location, results are ordered by availability, current opening status, and distance.

Publishers can register without requiring a tax ID, create business profiles, define weekly schedules, contact information, delivery options, and location privacy, and submit businesses and products or services for moderation.

Administrators review businesses and publications before they become publicly searchable. Publishers can choose exact, approximate, or contact-only location visibility.

How I built it

The project was built with PHP 8, MySQL, JavaScript, HTML, CSS, Leaflet, and OpenStreetMap.

Codex with GPT-5.6 accelerated the project from the initial architecture to a working production prototype. It helped me:

  • Design and review the MySQL database schema.
  • Implement proximity search and weekly schedule calculations.
  • Build publisher registration, authentication, and private dashboards.
  • Create separate moderation workflows for businesses and publications.
  • Implement authorization, CSRF protection, prepared statements, and secure sessions.
  • Diagnose and correct the Leaflet map and draggable marker.
  • Review PHP and JavaScript compatibility and perform security checks.
  • Improve the responsive interface and project documentation.

I defined the problem, product rules, privacy requirements, and moderation decisions, and I reviewed and approved each major change before deploying it.

Challenges

One of the main challenges was combining availability, opening hours, and geographic distance into a consistent search order.

Another challenge was protecting home-based sellers. Exact coordinates are stored for distance calculations, but the public interface hides them when the publisher chooses approximate or contact-only visibility.

Separating publisher and administrator sessions and permissions was also important to prevent unauthorized moderation or editing.

Accomplishments

I built and deployed a working end-to-end prototype that includes:

  • Privacy-aware proximity search.
  • Authorized and manual location selection.
  • Weekly schedules and current opening status.
  • Publisher registration and authentication.
  • Business creation and editing.
  • Product and service management.
  • Independent moderation of businesses and publications.
  • Public business profiles with catalogs, schedules, and contact options.
  • Responsive interfaces for desktop and mobile devices.

What I learned

I learned how to model hyperlocal discovery, calculate distance safely, implement privacy-aware geolocation, and structure secure PHP and MySQL workflows.

I also learned how to use Codex iteratively for architecture, implementation, review, testing, debugging, and documentation while retaining responsibility for product decisions and final validation.

What's next

Future improvements include:

  • Email verification.
  • Appointment and order reminders by email and WhatsApp.
  • Image uploads for businesses and publications.
  • Richer searchable product attributes.
  • Address autocomplete and improved geographic coverage.
  • Moderation analytics and administrative audit records.
  • More automated tests and accessibility improvements.
Share this project:

Updates