This is an Amazon-like storefront built with MySQL and Node.js.
When the user is in the customer portal, you can view the inventory, choose an item you'd like to purchase along with the quantity. If the item is in stock, the transaction will be complete! However, if we do not have enough of the selected item in stock, the transaction will not go through.
Once the app is loaded:
It will print the products in the store.
Prompts customer which product they would like to purchase by ID number.
Asks for the quantity.
If there is a sufficient amount of the product in stock, it will return the total for that purchase. If there is not enough of the product in stock, it will tell the user that there isn't enough of the product. If the purchase goes through, it updates the stock quantity to reflect the purchase and will update the product sales in the department table.
