FairWay Furniture Resell Application
My peers and I created a furniture reselling application inspired by the website Wayfair. First, we developed a logical model for a MySQL relational database. We then devised and implemented a REST API using Flask to provide access to the data. Following this, we drafted a set of user interface pages that served as a minimum viable product (MVP) for the application. These pages outlined major features and presented data views tailored to key archetype users, offering a clear vision of the product's functionality and user experience.
Synopsis:
FairWay is North America’s one-stop fix for buying and selling furniture and home goods on a straightforward e-commerce website. On the backend, we act as the middleman, building a database of manufacturers and sellers, partnering with both small and large companies that wish to sell their products online and need customers to ship them to. On the frontend, customers visit our website, enter the type of goods they need, and connect to the database we have created. Ideally, this provides a simple way for customers and manufacturers to explore all of their home furnishing options. With an increased focus on online shopping and delivery-focused shopping, FairWay makes it easy for home goods-specific businesses to connect to customers. Focusing entirely on this area of goods, we aim specifically at new homeowners, college students, and anyone looking to decorate their home quickly and efficiently.
User Archetype 1 (Customer) -
A customer is a person who purchases products marketed by FairWay. The system should allow the user to store the following information: their first and last name, a unique ID, phone number, email address, address, and an invoice listing the purchased products. The system should also allow the customer to select products that they would like to buy and complete transactions.
User Archetype 2 (Manufacturer) -
A manufacturer is a person who produces goods for sale to customers. The system should allow manufacturers to store the following information: First name, Last name, Manufacturer ID (unique), phone number, email address, products available, and who sells their products. FairWay should also allow the manufacturer to see which products sellers require and the volumes of those products that need to be manufactured.
User Archetype 3 (Seller) -
A seller is a person who purchases goods from manufacturers and sells goods to customers. The system should allow the seller to store the following data: First name, Last name, Seller ID(unique), phone number, email address, product purchased from manufacturer, manufacturer ID, manufacturer name, product available for sale, customer order, customer name, and customer ID. Fairway should allow the seller to see which goods are available from manufacturers and which orders customers have placed.
