Stockforce

ES | Resumen Ejecutivo

Stockforce es un SaaS multi-tenant para comercio retail de productos, construido con PHP + MySQL. Esta enfocado en tiendas y retailers que venden productos fisicos con POS, integrando inventario, clientes y analitica operativa en una sola plataforma.

Valor Para Reclutadores

• Problema de negocio real: operacion comercial diaria de retail.
• Cobertura end-to-end: catalogo, inventario, clientes, ventas POS, reportes.
• Enfoque SaaS: aislamiento por tenant y sesiones por rol.
• Preparado para monetizacion: base clara para planes de suscripcion.

Funcionalidades Clave

• Autenticacion por sesion y control por rol.
• Dashboard con KPIs de ventas, productos top y alertas de stock.
• CRUD de productos, categorias y clientes con alcance por tenant.
• Flujo POS con rebaja automatica de inventario.
• Endpoints API para consulta de productos y ventas.

Arquitectura y Tecnologia

• Backend: PHP 8+, PDO, MySQL/MariaDB.
• Estructura: controllers, models, views, middleware y router central.
• Integridad de datos: flujo transaccional en ventas y movimientos de inventario.
• Despliegue: compatible con hosting compartido/cPanel.

Demo Rapida (5 minutos)

1. Iniciar sesion con usuario admin semillado.
2. Crear categorias y productos.
3. Registrar cliente.
4. Ejecutar una venta POS.
5. Validar cambios en stock y metricas del dashboard.

Monetizacion Sugerida

• Plan Basic: catalogo, clientes, POS, stock.
• Plan Pro: analitica avanzada, reportes y automatizaciones de bajo inventario.
• Plan Enterprise: multi-sucursal, integraciones API y onboarding personalizado.

Checklist de Publicacion Segura

• No commitear .env con credenciales reales.
• Mantener solo .env.example en el repo.
• No subir dumps SQL de produccion con datos reales.
• Rotar credenciales antes del lanzamiento publico.

---

EN | Recruiter Snapshot

Stockforce is a multi-tenant SaaS for product retail commerce, built with PHP + MySQL. It is designed for stores and retailers selling physical products via POS, combining inventory, customer management, and operational analytics in one platform.

Portfolio Signal

• Real business problem: day-to-day retail operations.
• End-to-end product scope: catalog, stock, customers, POS sales, reporting.
• SaaS mindset: tenant isolation and role-aware sessions.
• Monetization-ready: clear structure for subscription plans.

Core Features

• Session-based authentication with role-aware access.
• KPI dashboard (sales trends, top products, low-stock alerts).
• Tenant-scoped CRUD for products, categories, and customers.
• POS workflow with automatic stock deduction.
• API endpoints for products and sales data.

Technical Highlights

• Backend: PHP 8+, PDO, MySQL/MariaDB.
• Structure: controllers, models, views, middleware, central router.
• Data reliability: transactional sales and inventory movement handling.
• Deployment-ready: works on shared hosting/cPanel.

Quick Demo Flow (5 minutes)

1. Sign in with seeded admin user.
2. Create categories and products.
3. Create a customer.
4. Complete a POS sale.
5. Validate inventory updates and dashboard metrics.

Suggested Monetization

• Basic: catalog, customers, POS, stock control.
• Pro: advanced analytics, reporting, low-stock automations.
• Enterprise: multi-branch, API integrations, custom onboarding.

Setup

1. Create/import the MySQL database stockforce_db.
2. Copy .env.example to .env and configure database credentials:
   • DB_HOST
   • DB_PORT
   • DB_DATABASE
   • DB_USERNAME
   • DB_PASSWORD
3. Import database/completeschema_db.sql.
4. Create the first admin user by setting seed variables and running:

php database/seed_admin.php

Required seed variables:

• SEED_TENANT_NAME
• SEED_ADMIN_NAME
• SEED_ADMIN_EMAIL
• SEED_ADMIN_PASSWORD

Optional seed variables:

• SEED_TENANT_PLAN
• SEED_ADMIN_ROLE

Routes

• GET /login
• POST /login
• GET /dashboard
• GET /pos
• POST /pos
• GET /products
• GET /products/create
• GET /products/edit?id={id}
• POST /products
• POST /products/update?id={id}
• POST /products/delete
• GET /categories
• GET /categories/create
• GET /categories/edit?id={id}
• POST /categories
• POST /categories/update?id={id}
• POST /categories/delete
• GET /customers
• GET /customers/create
• GET /customers/edit?id={id}
• POST /customers
• POST /customers/update?id={id}
• POST /customers/delete
• GET /api/products
• GET /api/sales
• POST /api/sales
• POST /logout

Authenticated sessions store user_id, tenant_id, user_name, and user_role.

cPanel

Upload the project contents to the site root and keep index.php in the root. Apache rewrites all app routes to that file, serves assets from public/assets, and blocks direct access to internal folders.