Skip to main content
Pro Stock Tool Hero Light

​
Welcome to Pro Stock Tool

Pro Stock Tool is a modern, full-stack inventory management system designed to streamline warehouse operations, product tracking, and supplier management. Built with PHP and JavaScript, it provides a robust RESTful API backend with an intuitive, responsive frontend interface.

​
Key Features

Warehouse Management

Create and manage multiple warehouses with detailed location tracking and real-time inventory visibility

Product Categorization

Organize products with categories and subcategories, with color-coded visual organization

Inventory Tracking

Track stock levels with min/max thresholds, expiration dates, and automated alerts

Supplier Management

Manage supplier information, contact details, payment terms, and product associations

User Authentication

Secure user registration and login with bcrypt password hashing and session management

Real-time Reporting

Generate inventory reports, track product movements, and analyze warehouse performance

RESTful API

Complete REST API with JSON responses for all CRUD operations on warehouses, products, and suppliers

Product Categorization

Organize products with categories and subcategorories, with color-coded visual organization

Inventory Tracking

Track stock levels with min/max thresholds, expiration dates, and automated alerts

Supplier Management

Manage supplier information, contact details, payment terms, and product associations

User Authentication

Secure user registration and login with bcrypt password hashing and session management

Real-time Reporting

Generate inventory reports, track product movements, and analyze warehouse performance

RESTful API

Complete REST API with JSON responses for all CRUD operations on warehouses, products, and suppliers

Customizable Parameters

Define custom product states and attributes with color coding for visual identification

​
Technology Stack

Backend

PHP 7.4+
  • RESTful API architecture
  • MySQLi database connectivity
  • JSON response formatting
  • CORS support for cross-origin requests

Frontend

HTML5 / CSS3 / JavaScript
  • Vanilla JavaScript (ES6+)
  • Fetch API for HTTP requests
  • Responsive design
  • Real-time UI updates

Database

MySQL
  • Database: prostocktool
  • Relational schema design
  • Foreign key constraints
  • Timestamp tracking

​
System Architecture

Pro Stock Tool follows a clean separation of concerns with a three-tier architecture: 
┌─────────────────────────────────────────┐
│         Frontend (View Layer)          │
│  HTML Templates + JavaScript Controllers│
└────────────────┬────────────────────────┘
                 │ HTTP/JSON
┌────────────────▼────────────────────────┐
│        Backend (API Layer)              │
│     PHP REST API Endpoints              │
└────────────────┬────────────────────────┘
                 │ MySQLi
┌────────────────▼────────────────────────┐
│      Database (Data Layer)              │
│         MySQL Database                  │
└─────────────────────────────────────────┘
Project Structure: The application is organized into three main directories:
  • /view - HTML templates and user interface
  • /controllers - JavaScript frontend logic
  • /database - PHP REST API endpoints and database connection

​
Quick Example

Here’s a simple example of fetching warehouses using the Pro Stock Tool API: 
// Fetch all warehouses
const API_URL = 'http://localhost/Pro-Stock-Tool/database/bodega.php';

const response = await fetch(API_URL, { 
  cache: 'no-store' 
});

const data = await response.json();

if (data.success) {
  console.log('Warehouses:', data.data);
  // data.data contains array of warehouse objects
}

​
Core Entities

The system manages several core entities:
EntityDescriptionKey Fields
Warehouses (Bodegas)Physical storage locationsnombre, descripcion, fecha_creacion
CategoriesProduct classificationnombre, descripcion, color, estado
SubcategoriesSecondary classificationnombre, categoria_id
Suppliers (Proveedores)Vendor informationnif, nombre, contacto, email, terminos
Parameters (Parametros)Custom product attributescodigo, nombre, color
Users (Usuarios)System usersemail, nombre, identidad, password
ProductsInventory itemsnombre, bodega_id, categoria_id, proveedor_id

​
Getting Started

Quick Start

Get Pro Stock Tool up and running in minutes with our quick start guide

Installation

Detailed installation instructions for setting up your development environment

API Reference

Complete API documentation for all endpoints and operations

Configuration

Learn how to configure and customize Pro Stock Tool for your needs

Configuration

Learn how to configure database connections and application settings

​
Need Help?

If you need assistance or have questions:
Security Note: The default database configuration uses root with no password. Always change this in production environments and implement proper access controls.

Build docs developers (and LLMs) love

Get started for freeTalk to us