Lager Analyse System

Overview

Lager Analyse System is a Python and PySide6 based desktop application for analyzing warehouse location data from CSV files.

The project was originally developed as an internal tool for a real warehouse environment to simplify daily warehouse operations and provide a faster overview of available storage capacity. While it was initially created for use with JTL-WMS exports, the application is not tied to JTL and can be used with any CSV file that follows the required column structure.

The primary goal of the application is to quickly identify free, occupied, blocked, inactive, and unknown storage locations without manually reviewing large CSV exports.

Note: The application's user interface is currently available in German because it was originally developed for German-speaking warehouse employees.

---

Features

• Import warehouse data from CSV files
• Merge multiple CSV files into a single analysis
• Automatic storage location status detection
• Overview of free storage locations
• Overview of occupied storage locations
• Overview of blocked storage locations
• Overview of inactive storage locations
• Overview of unknown storage locations
• Advanced free-location view
• Configurable priority groups
• Configurable blacklist support
• Optional master location list
• Cross-platform Python application
• Open-source and customizable

---

Screenshots

Main Window

The main window provides access to all core functions of the application.

• Load CSV files
• Add additional CSV files
• Open detail view
• Open advanced free-location view
• Open settings

---

Detail View

The detail view displays all detected warehouse locations and their current information.

Displayed information includes:

• Storage location
• Quantity
• Status
• Item name
• Original CSV status

---

Advanced Free Location View

The advanced view provides a categorized list of currently available storage locations.

Locations can be grouped into custom categories for faster warehouse planning.

Examples:

• Goods Receiving
• Picking Area
• Reserve Storage
• High Rack Storage

---

Settings

The settings window allows direct editing of configuration files used by the application.

---

Status Logic

FREE

The storage location contains no stock and is available.

OCCUPIED

The storage location contains stock.

BLOCKED

The location is blocked either through warehouse data or the blacklist configuration.

INACTIVE

The location has been marked as inactive.

UNKNOWN

The status could not be determined reliably.

---

CSV Structure

The application currently expects the following columns:

Column	Description
0	Storage Location
2	Status
3	Quantity
4	Item Name

Example:

A-01;...;FREE;0;Example Item

---

Configuration Files

Master List

File:

assets/masterlist.txt

Contains known storage locations.

This file is optional and can be used as an additional reference for warehouse structures.

---

Blacklist

File:

assets/blacklist.txt

Locations listed here will be treated as blocked.

Example use cases:

• Damaged locations
• Reserved locations
• Permanently unavailable locations

---

Priority Locations

File:

assets/priority_places.txt

Allows custom grouping of storage locations.

Example:

%GOODS_RECEIVING%
AA-01
AA-02
AA-03

%PICKING%
AB-01
AB-02
BA-03

These categories are displayed in the Advanced Free Location View.

---

Project Structure

LagerAnalyseSystem/

├─ assets/
│  ├─ icon.ico
│  ├─ icon.png
│  ├─ blacklist.txt
│  ├─ masterlist.txt
│  └─ priority_places.txt
│
├─ core/
│  ├─ loader.py
│  ├─ processor.py
│  ├─ statistics.py
│  ├─ priority_loader.py
│  └─ priority_processor.py
│
├─ data/
│  ├─ blacklist.py
│  └─ masterlist.py
│
├─ gui/
│  ├─ main_window.py
│  ├─ detail_window.py
│  ├─ priority_window.py
│  ├─ settings_window.py
│  ├─ popup_window.py
│  └─ table_model.py
│
├─ utils/
│  ├─ file_opener.py
│  ├─ helpers.py
│  └─ paths.py
│
├─ logging/
│  ├─ logger.py
│  └─ error_log.txt
│
├─ Inno/
│  └─ installer.iss
│
├─ config.py
├─ main.py
├─ build.txt
└─ README.md

---

Requirements

Python 3.10+

Required package:

pip install PySide6

---

Build

Windows

pyinstaller --onefile --windowed --icon=assets/icon.ico main.py

Linux

python main.py

Executable builds for Linux can also be created using PyInstaller.

---

Tested Platforms

Fully Tested

• Windows 10
• Windows 11
• Arch Linux

Expected to Work

• Most Linux distributions
• macOS

---

Purpose of the Project

This application was created to solve a practical warehouse management problem in a production environment.

Many warehouse management systems can export location data, but they often do not provide a quick overview of available storage capacity. This tool was developed to automate that process and provide warehouse staff with an immediate overview of free and occupied locations.

The project originated as an internal business tool and was later prepared for public release as an open-source project.

---

License

This project is licensed under the MIT License.

You are free to use, modify, distribute, and publish this software, including for commercial purposes, provided that the original copyright notice and license text are included.

For full license details, see the LICENSE file included in this repository.

Author

Developed by Vipe.

Originally created as an internal warehouse management utility and later released as an open-source project.