Inspiration

This morning, as I arrived to sign up for the Wayfair Ski Trip, I realized how chaotic and dysfunctional it can get when hundreds (or even thousands) of Wayfair employees all want to be a part of a company sponsored event. As the lines collided, tempers flared, and frustration grew that everybody had come into the office at 7:00am to no avail, it became obvious that we need a better way to manage event lotteries at Wayfair!

What it does

When you enter our tool you can add events or sign up for events. The process is streamlined, you don't even have to provide anything on the sign up page because your employee id is automagically pulled from the session. Once you've signed up for an event, as the deadline arrives, a lottery will run and determine who gets a spot in the event.

How we built it

Our Lottery App is on Admin home and runs as a simple React component view. The backend is powered with PHP and SQL.

Challenges we ran into

Calendars in React are hard. Deciding winners based on tenure is hard.

Accomplishments that we're proud of

We have an MVP Lottery tool which can be used to create and sign up for events. We also have a SPROC which can get the winners (even based on tenure)

What we learned

Calendars in React are more difficult than they seem.

What's next for Wayfair Event Lottery App

If we can get people behind the idea, this will be the clear future for Event Tickets and other events such as the Wayfair Ski Trip. An enhancement to the MVP would be adding an admin view to update the events and run the lottery. We can also add a job to send out emails to the winners.

Share this project:

Updates