The Bamazon app is an Amazon-like storefront. The app uses mySQL to take in orders from customers and deplete stock from the store's inventory. The store is populated with ten mock data products (inspired by a search on silly products sold online).

1. The app displays a table with all of the items available for sale, including item id's, product names department names and prices.
   

2. Secondly, the app prompts the users to answer two questions:
   

• What is the ID of the product that you would like to buy?
• How many units of the product would you like to buy?
  

3. The app repeats back the user input, and informs the current stock quantity of the requested item id.
   

4. Lastly, if the store has enough of the product to meet the customer's request, it will update the SQL database to reflect the remaining quantity, and show the customer the total cost of their purchase.
   

5. However, if the store does not have enough of the product to meet the customers request, the purchase will not go through.

• mySQL
• inquirer
• cli-table

Screenshot illustrating the table and user input (points 1 and 2).

Screenshot illustrating the response if the item is in stock (points 3 and 4).

Screenshot illustrating the table and user input (points 1 and 2).

Screenshot illustrating the response if the item is NOT in stock (3 and 5).