Skip to content

Online Retail Store DBMS made using MySQL and Flask

Notifications You must be signed in to change notification settings

aditiisaxena/FastFruits

Repository files navigation

FastFruits Online Retail Store

FastFruits is an online retail store that sells fruits and vegetables. We have tried to design the database and business logic layer for a Quick Commerce retail store specializing in fruits and vegetables. Fruits and vegetables are the most difficult Stock Keeping Unit category for most grocery companies owing to a standard wastage rate of 30%. Our system aims to minimize this wastage through algorithmic end-to-end lifecycle management of fruits and vegetables.
This project is a database management system (DBMS) that has been built using MySQL and Flask to manage the data for FastFruits.

Alt text

Features

  1. Customers can register and login to purchase fruits and vegetables.
  2. Customers can add items to their cart and place an order. Customers can view their order history.
  3. Admins can manage the inventory, update stock and prices of fruits and vegetables.
  4. Admins can view order history of all customers and mark orders as fulfilled.
  5. Admins can add, update, and delete products from the inventory.

Dependencies

Python 3.6 or higher
Flask 2.0 or higher
MySQL 8.0 or higher
Flask-MySQLdb 0.2.0 or higher