1. After installing npm mysql and inqurier, import both dependencies via require()
  2. Setup connection with mysql with credentials
  3. Test connection with a call back function
  4. View all products available in store via runSearch()
  5. Customer's Order: Prompt customers to choose an item_id corresponding to desired product
  6. Then check inventory: Is the selected item there? If not, console log not enough stock
  7. Check inventory - might need to loop though the stock inventory to matchup with customer's order
  8. Quantity: Prompt customer to specify how many quantity they want to purchase
  9. If stock is sufficient, make purchase successfully. If not, console log insufficient quantity, display catalog again and prompt user to input number again
  10. Customer's Receipt: Finalise purchase order
  11. Deplete stock quantity from store's inventory 
  12. Display purchase summary and total cost
  13. Prompt user to browse again or exit
  14. If browse again: display catalog via runSearch()
  15. If exit: quit program via process.exit()

  1. After installing npm mysql and inqurier, import both dependencies via require()
  2. Setup connection with mysql with credentials
  3. Test connection with a call back function
  4. Inquirer prompt user to select an item from list of menu options: View Products for Sale, View Low Inventory, Add to Inventory, Add New Product
  5. Set up a switch case to select one of menu option code blocks to be executed
  6. If a manager selects View Products for Sale, the app should list every available item: the item IDs, names, prices, and quantities
  7. If a manager selects View Low Inventory, then it should list all items with an inventory count lower than five (5)
  8. If a manager selects Add to Inventory, the app should display a prompt that will let the manager "add more" of any item currently in the store
  9. If a manager selects Add New Product, it should allow the manager to add a completely new product to the store