inventoryOrderJawn_Bamazon

This is a product sales and inventory order management platform of to demonstrate the interoperabiltiy between SQL and node.JS

There are two (2) functional apps for this repository, bamazonCustomer.js and bamazonManager.js

A database, bamazon_db was set-up, and is executable with the bamazon_seeds.sql file

Deployment

Git clone the files to a local directory of your choice. Make sure to run the npm installations!

Built With

• node.js
• MySqlWorkbench - database
• cli-table - table to view data in the terminal; an npm library in the package-lock.json file
• inquirer - inquirer for user prompts and responses on input; an npm library in the package-lock.json file
• mysql - mysql for SQL queries built dynamically on the connection object; an npm library in the package-lock.json file

The following screenshots walk the user through how each app operates:

(1) bamazonCustomer.js

On file-execution in the terminal, the user is prompted with the Sales menu and prompted to make a purchase:

The prompt walks the user through the operations to make purchases.

The user is prompted to enter an item for puchase by its ID number.

If the user make a purchase that depletes inventory of a product, it will remove it from the menu.

Otherwise, it will merely update the remaining stock quantity following the order.

The data validation also checks to see if the user selects a product ID that unavailable/not found in the menu offerings.

(2) bamazonManager.js

On file-execution in the terminal, the user is prompted to choose what action they wish to perform:

The user is walked-through various prompts per the action selected.

(2a) View All Items

(2b) View Low Inventory Items

(2c) Update Item Stock Quantity Inventory

(2d) Add a new Item with Stock Quantity Inventory

Authors

• Ben Presseisen - Initial work - Precise Insights