An amazon-inspired inventory tracker made with MySQL. The app takes in orders from customers and depletes stock from bamazon's inventory.
Records in products database before shopping transactions:
Prompting shopper to enter SKU and available quantity:
Confirmaton of valid quantity based on active inventory and quoting total price:
Records in products database after successful shopping transaction:
Response to shopper request for higher quantity than available inventory:
Records in products database unchanged after unsuccessful shopping transaction:
