Inventory Wizard Version 1.0 - Initial Release

Inventory File Wizard

Inventory File Wizard is a powerful and user-friendly desktop application designed to streamline the process of converting inventory data from Excel files into a standardized format compatible with specific Inventory Management Systems (IMS).

Key Features

1. Drag-and-Drop Support
   Effortlessly add files by dragging and dropping them into the interface, or use the file selection dialog for precise input.

2. Multi-File Processing
   Import and process multiple inventory files in one go, saving time and effort.

3. Data Transformation

   • Converts Excel files (.xlsx, .xlsm, .xls) and CSV files into a consistent CSV format.
   • Automatically generates new columns such as Inventory-ID, Inventory-LocationName, Inventory-Cost, and more, with pre-defined default values.
   • Customizes fields like Tracking-Lot Number based on existing data (e.g., Brand and Model).

4. Batch Conversion and Export
   Quickly converts and saves files to a user-specified directory, appending "(Cleaned)" to filenames for easy identification.

5. Error Handling
   Notifies users about unsupported file types or invalid inputs, ensuring smooth operation.

6. Visual Interface
   A clean, intuitive GUI built using Tkinter, featuring branded assets and user-friendly controls.

Target Audience

• Small businesses managing inventory data.
• Nonprofits looking to simplify bulk data preparation.
• Users with limited technical experience who need a simple solution for transforming inventory files.

Technology Stack

• Frontend: Python Tkinter for the GUI.
• Backend: pandas for data manipulation and file conversion.
• Advanced Features: Integration with file operations and metadata management for seamless processing.

Purpose

The Inventory File Wizard bridges the gap between raw inventory data and Inventory Management Systems, enabling users to focus on what matters most—managing their inventory efficiently and accurately.