Wareflow Analysis

Warehouse data analysis tool for ABC classification, inventory analysis, and reporting.

Features

• CLI Interface: Command-line tool for automation and scripting
• GUI Application: User-friendly graphical interface for non-technical users
• ABC Analysis: Classify products by importance (A/B/C categories)
• Inventory Analysis: Analyze warehouse stock and movements
• Excel Export: Generate professional Excel reports with formatting
• SQLite Storage: Local database for fast queries and data persistence

Installation

Option 1: Using pip (Recommended for developers)

pip install wareflow-analysis

Option 2: Using the standalone Windows executable (Recommended for users)

Download the latest Warehouse-GUI.exe from the Releases page. No Python installation required.

Quick Start

Using the GUI (Recommended for non-technical users)

If installed via pip:

wareflow-gui

Or run the executable directly:

./Warehouse-GUI.exe

The GUI provides an intuitive interface for:

• Creating and managing projects
• Importing Excel data
• Running analyses
• Exporting reports

Using the CLI (Recommended for automation)

1. Initialize a new project:

   mkdir my-warehouse
   cd my-warehouse
   wareflow init

2. Place your Excel files in the data/ directory:

   • produits.xlsx (Products catalog)
   • mouvements.xlsx (Stock movements)
   • commandes.xlsx (Orders)

3. Import data:

   wareflow import

4. Run analyses:

   wareflow analyze abc
   wareflow analyze inventory

5. Generate reports:

   wareflow export abc --output output/abc_report.xlsx
   wareflow export inventory --output output/inventory_report.xlsx

CLI Commands

Command	Description
wareflow init	Initialize a new project
wareflow import	Import Excel data to SQLite
wareflow analyze abc	Run ABC classification analysis
wareflow analyze inventory	Run inventory analysis
wareflow export abc	Export ABC analysis to Excel
wareflow export inventory	Export inventory analysis to Excel
wareflow status	Show database and project status
wareflow run	Run the complete pipeline

Project Structure

After initialization, your project will have:

my-warehouse/
├── config.yaml          # Excel-to-SQL configuration
├── data/                # Place your Excel files here
│   ├── produits.xlsx
│   ├── mouvements.xlsx
│   └── commandes.xlsx
├── output/              # Generated reports will be saved here
├── warehouse.db         # SQLite database
└── scripts/             # Custom analysis scripts

Development

Building from Source

See BUILD.md for detailed build instructions.

Running Tests

pip install -e ".[dev]"
pytest

Building the Windows Executable

See BUILD.md for instructions on building the standalone executable.

License

MIT License - see LICENSE file for details.

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

Support

• Issues: GitHub Issues
• Documentation: Project Docs

Acknowledgments

Built with:

• Typer - CLI framework
• CustomTkinter - Modern GUI framework
• Pandas - Data analysis
• OpenPyXL - Excel handling
• PyYAML - Configuration management