Order Form Builder & Order Import Automation
The Challenge: As an action sports wholesaler, our company manages preorders for future product ranges from numerous customers. While some customers use our B2B website directly, many prefer submitting orders via Excel spreadsheets. This created two time-consuming manual processes: creating customized Excel order forms for each preorder and manually entering submitted orders back into our B2B system. The Solution: I developed a desktop application using Python and PySide6 (Qt framework) to automate both processes. The application: • Generates customized Excel order forms which can map directly to an individual preorder listing or combine multiple into 1 order form. • Creates hidden import worksheets that enable seamless data transfer to our B2B website • Eliminates manual data entry by automating the order import process Technical Implementation: • Built the GUI using PySide6 for a modern, user-friendly interface • Connected to SQL Server databases using SQLAlchemy & raw T-SQL queries • Processed and transformed data using Pandas DataFrames • Generated formatted Excel files (.xlsx) using OpenPyXl
Back to Portfolio
