{“fitment_generator”}
Data Automation (Excel)
To make life easier for an e-commerce company juggling multiple platforms (eBay, Amazon, Dealers, you name it), I took on the annoying task of endless data manipulation. In the auto industry, there’s this thing called fitment, which is basically a list of cars that a product fits. Instead of driving myself crazy manually listing every year, make, model, and submodel for each product, I decided to automate the process. Oh, and I threw in a little bit of authentication magic too!
ACES Generator
I broke down the task into a few parts. The first was to automate SEMA DATA ACES. For this phase, we developed the GUI and the underlying logic, which is the backbone of the final version—the Fitment Generator ACES Function.
I faced some challenges since it was my first time using Tkinter. I never expected to be developing GUIs, but here I am. The development process and the logic behind it weren’t too bad because it mostly involved data manipulation with pandas, which has pretty good documentation.
myFitment Generator
The second step is the big ol’ myFitment platform. This wasn’t too bad as the logic behind it was pretty straight-forward (data manipulation using pandas still), but this time we needed two logic functions, one for eBay and one for Amazon. I was thinking of somehow combining the two into one function and just manipulate it to cover both but at the end I just said fuck it and made two
As this is the second step, I originally didn’t plan to make the final fitment generator. But as I thought it over in my head, I realized I might as well create one so the data guy doesn’t need to keep switching apps and use one instead
THE FINAL FITMENT Generator
The third and final step is the creation of the big boi. I didn’t know how I wanted to lay it out so I actually went ahead and developed a little wireframe haha. Honestly, comparing it to the end product, I like the final product more. The drop down list was an idea that popped in my head, I was thinking, instead of making a app that has to generate a file for all the products, why not just use the ones we need so when creating it, its not going to fry someone’s computer?
That was actually the most challenging part, I thought of just combining both ACES Generator and the myFitment Generator together but I was like lemme add a bit of UX / UI into this shit. Learning and leaning into ttk was a fun little rabbit hole and it turned out nicely!
I added a but of authentication with a username and password to it as to make sure its not used by a random employee, and to add a little bit of *security*
ALl in all, a fun project that I’m proud to put in my portfolio and resume!