Shipment Entry Assistant
A Python desktop tool designed to make shipment registration faster, safer, and more consistent by writing validated shipment data into a traceability workbook.
Problem
Shipment and traceability data can be difficult to manage when entries are added manually across Excel sheets, especially when serial numbers, production lots, articles, quantities, and customers need to stay connected.
Manual entry also increases the risk of overwriting formulas, missing required fields, using inconsistent article logic, or accidentally shipping the same pump serial more than once.
Solution
I built a Python-based desktop assistant that validates shipment input, reads article type logic from Excel, creates backups before writing, and adds new shipment rows only to the correct manual input fields.
The tool supports traceability by helping connect shipment data with production lots, pump serials, articles, customers, dates, and invoice references in a more controlled workflow.
Key Features
- Validated shipment entry into an Excel traceability workbook
- Automatic backup before writing data
- Header checking to avoid writing to the wrong columns
- Article type lookup and material usage hints
- Pump serial check to detect if a pump was already shipped
- Support for sets, pumps, dressings, foam, carry cases, customers, dates, and invoices
- Designed to avoid overwriting formula-driven columns
Tools Used
- Python
- CustomTkinter
- openpyxl
- Excel
- Traceability workbook
- Validation logic
- Backup workflow