Skip to main content

Sistema de Control Inteligente de Inventario

An automated Python-based inventory management system that streamlines operational tasks through ETL processing, ABC classification, risk evaluation, Excel reporting, and automated email delivery.

Key Features

ABC Classification

Automatically classify products by sales volume using the proven ABC method

Risk Evaluation

Detect critical stock levels and generate automatic replenishment recommendations

Excel Reports

Generate comprehensive multi-sheet reports with inventory status and alerts

Automated Charts

Create visual analytics for inventory status and ABC distribution

Quick Start

Get up and running with the inventory system in minutes.
1

Install Dependencies

Install Python dependencies from requirements.txt
pip install -r requirements.txt
2

Prepare Your Data

Place your inventory Excel file in the data/ directory
3

Run the System

Execute the main script to process your inventory
python src/main.py

Full Quickstart Guide

Follow the complete guide to set up email notifications and understand all features

How It Works

The system automates the entire inventory management workflow:
  1. Load — Reads inventory data from Excel files
  2. Analyze — Applies ABC classification based on monthly sales
  3. Evaluate — Assesses stock risks and calculates replenishment needs
  4. Report — Generates detailed Excel reports with multiple sheets
  5. Visualize — Creates charts for inventory status and classification
  6. Notify — Sends automated email reports to stakeholders

Built For

This system solves common inventory management challenges:
  • Manual Analysis — Automates time-consuming inventory reviews
  • Human Errors — Eliminates mistakes in classification and calculations
  • Missed Alerts — Provides early warnings for stock shortages
  • Inconsistent Reports — Generates standardized, professional reports

Explore the Documentation

Installation

Set up the system and configure your environment

Configuration

Configure email settings and system parameters

Architecture

Understand the system’s modular design

Module Reference

Explore all functions and their parameters

Build docs developers (and LLMs) love