The Merchandising, Marketing, and Creative teams created the curated combinations offered within this experience. Every month, they would compile all the data and assets into an Excel spreadsheet. Manually coding up this experience would be very time-consuming. I took their spreadsheets and formatted them into a new Excel document that was clearer and easier for them to update.
With the help of a talented developer team member, we created built-in macros to convert the spreadsheets into JSON data. Once formatted, I was able to take that data and write a Javascript engine to generate the experience. We automated as much of the process as we could, making production simpler and easily repeatable!
Now that I have the data structured, I can use it to create what was designed. Fortunately, the designers trusted me and were willing to adjust the designs based on my feedback and these sketches. It allowed everyone to understand the underlying functionality and what would be needed from each team every time we had to update the content.