THEM - The Horrible Etsy Manager

[tophattwaffle]

Hello!

Just wanted to share what I was able to hack up, as maybe it will help someone with a smaller shop like myself. Etsy's default variation management is frankly abysmal - especially if listings share materials. For instance I 3d print a lot of items, so colors are shared between almost all of my listings. Should I want to add a color, I'd have to edit each listing manually or find another solution. There are many paid solutions out there that are much better than what I have here, but what I have here will work for free on your local (Windows) machine.

Over the past week and some change I whipped this up in PowerShell. Yikes PowerShell, I know - but I'm a system administrator by day so PowerShell is something that I can never get enough of and this project taught me some more things about PowerShell I never knew. PowerShell aside, you can at least easily manage variations though an Excel sheet!

Video of updating multiple listings:
https://user-images.githubusercontent.com/6774125/215305314-84340a18-95b8-4503-955a-3cb5e44be83f.mp4

Another smaller, and also niche feature, was to keep tabs on my open order count in my Smart Home (Home Assistant). So this script can also be scheduled to run automatically and post to a Home Assistant Webhook so you can easily display your order counts there. (This should be a Home Assistant integration, but I have yet to cross into HASS development and this code already worked.)

If you want more information on this horrible pet project, the repo is here: https://github.com/tophattwaffle/THEM