Welcome to TiendaRopa
TiendaRopa is a comprehensive CRUD-based inventory management system designed specifically for clothing retail businesses. Built with PHP and MySQL, it provides a complete solution for managing products, employees, suppliers, and stock movements.Quick Start
Get up and running with TiendaRopa in minutes
Database Setup
Configure your MySQL database and import the schema
User Guide
Learn how to manage your inventory effectively
Database Reference
Explore the complete database schema
Key Features
Product Inventory Management
Product Inventory Management
Comprehensive product tracking with support for multiple categories, sizes (tallas), and colors. Each product includes pricing, current stock levels, and full categorization for easy organization and retrieval.
Employee & Supplier Tracking
Employee & Supplier Tracking
Manage your team with employee records including role assignments (empleado/gerente). Track supplier relationships with contact information and address details for seamless procurement management.
Stock Movement Recording
Stock Movement Recording
Record all inventory movements including:
- Entrada (incoming stock)
- Salida (outgoing stock)
- Ajuste (inventory adjustments)
Price Update History
Price Update History
Track all price changes over time with the actualizaciones system. View historical pricing, who made changes, and when they occurred for complete transparency and business intelligence.
Advanced Search & Sorting
Advanced Search & Sorting
Powerful search capabilities across product names, colors, sizes, categories, and prices. Sort by any column with ascending/descending order for quick data access.
Registration & Audit Trail
Registration & Audit Trail
Complete product registration system linking products to employees and suppliers. Maintain full traceability of when products were added to your inventory and by whom.
System Architecture
TiendaRopa is built as a traditional server-side web application:- Frontend: Bootstrap 5.3 for responsive UI components
- Backend: PHP with PDO for database operations
- Database: MySQL/MariaDB with normalized schema design
- Server: Designed to run on XAMPP, WAMP, or similar LAMP stacks
TiendaRopa was developed as a database workshop project (“Taller de Bases de Datos”), demonstrating practical CRUD operations, database normalization, foreign key relationships, and real-world inventory management workflows.
Core Modules
The system is organized into several functional modules:| Module | File | Purpose |
|---|---|---|
| Inventory | index.php | Main product listing with search and sorting |
| Product Management | crear.php, editar.php, eliminar.php | Create, update, and delete products |
| Catalog Management | categorias.php, colores.php, tallas.php | Manage product attributes |
| People Management | empleados.php, proveedores.php | Employee and supplier records |
| Stock Operations | movimientos.php, actualizaciones.php, registros.php | Track inventory changes |
Getting Started
Ready to dive in? Start with the Installation Guide to set up your development environment.