Problem

---

When interacting with other players of Animal Crossing: New Horizons, you often are exchanging lists of items you want and items you're willing to trade. Some players utilize Google Sheets, while others use community solutions to host for trade and wanted lists. None of these options were seamless and easy enough for my liking, so I built my own.

Objectives

---

🗄️ Build a database of every item in the game that can be pulled from to maintain the lists of items I want and have for trade

📋 Make it easy to add and remove items from each list

🖥️ Create a simple frontend webpage to view my wanted/for trade lists

How it works

---

First a program was needed to take a community spreadsheet of all the game items and populate a MySQL database with the item data. Then a simple command line application to quickly edit database tables representing my wanted and for trade lists.

Once the backend was setup, all that was needed was a simple site that populated with the items found in the wanted or for trade tables. After some CSS styling and some additional features (such as filtering by category and a search function), it was done!