15 Stock Inventory.md

Stock Inventory

Build a stock control and monitoring (SCM) system for a shop that sells Arduino Microcontrollers and associate electronic components:

Basic

1. The stock control team should be able to add items to stock based on their barcode (EAN) number.
2. If the item exists the stock level should be adjusted rather than adding a new product record.
3. When an item is sold at the till, each time an item is entered, the stock level should drop by one.

Intermediate

1. In addition, the returns department need a way to check returned items back into stock.
2. The auditing team need a way to modify the stock levels recorded based on a stock count.

Advanced

1. In addition the system needs to be able to track overall sales (by value) and sales of each component (by qty) over time.