Bamazon-node-MySQL

Amazon like store front using MyQSL and Node.js

List of Tables

1. Products - Used to store items in the store
2. Shopping Cart - Used to store items in a users shopping cart
3. Purchased - Used to store items that users have purchased

Overview

This program is a simulation of a storefront in a terminal environment.

When an item is chosen it is removed from the Products table and sent to the Shopping Cart table. Items in the shopping can be removed prior to closing out the transaction.

When the shopping is done the transaction can be completed. When the Checkout option is selected the items in the Shopping Cart table are removed from the Shopping Cart and then added to the Purchased table to keep a history on transactions.

Link to Project Video

Project Video

Future

Remove from the shopping cart

Need to create a function to remove a selection from the shopping cart and add it back to inventory.

Future tables

1. departments

Enhanced view

Table from NPM can be used to enhance the command line look.

Manager View actions

1. View products for sale
2. View low inventory
3. Add to inventory
4. Add new products

Supervisor View actions

1. View product sales by Department
2. Create new Departments