Inventory Control System

Track products, suppliers, purchases and sales in one place, with tax calculated on every sale.

CSE212 (B2) Database Systems Lab | University of Asia Pacific

Sign in

Welcome back.

Demo accounts (click to fill)
Overview

A steady pulse on your stock, sales, and the work that moved today.

+ Record a sale
All options

Inventory / Catalog

Products

Every item on your shelves, in one considered place.

Activities and process

Add product

  1. Enter name, SKU, category, price
  2. Set reorder level and optional tax override
  3. Save: system checks SKU is unique
  4. Product appears with stock 0

Update product

  1. Click Edit on the product row
  2. Change the details in the form
  3. Click Update product

Delete product

  1. Search for the product
  2. Click Delete, then Confirm delete (admin only)
  3. Blocked if it has sales or purchases

Search product

  1. Type a name or SKU
  2. Results list shows price and stock
  3. Low stock rows are highlighted

Inventory / Taxonomy

Categories

Categories group products and carry the default tax rate (0 to 100%).

Activities and process

Add category

  1. Enter a unique category name
  2. Enter default tax rate
  3. Save

Change tax rate

  1. Admin clicks Edit on the category row
  2. Enters the new rate
  3. Click Update category: past sales keep their old rate

Delete category

  1. Click Delete on the category row, then Confirm delete (admin only)
  2. Allowed only when it has no products

Operations / Sourcing

Suppliers

The businesses you buy stock from.

Activities and process

Add supplier

  1. Enter name and contact info
  2. Save

Update supplier

  1. Click Edit on the supplier row
  2. Change the details in the form
  3. Click Update supplier

Delete supplier

  1. Click Delete on the supplier row
  2. Click Confirm delete
  3. Blocked if the supplier has purchases

View purchase history

  1. Click History on a supplier row
  2. See each purchase with date and cost

Operations / Inbound

Purchases

Record stock arriving from a supplier. Stock on hand goes up automatically.

Activities and process

Record purchase

  1. Choose supplier
  2. Add products with quantity and unit cost
  3. Save: stock increases and total cost is calculated

Review purchases

  1. Filter by supplier or date
  2. Open a purchase to see its items

Reorder from low stock

  1. Open the low-stock list
  2. Pick a product to reorder
  3. Start a new purchase for it

Operations / Outbound

Sales

A quick, clear record of what left the shelf.

Activities and process

Create sale

  1. Enter customer name (optional)
  2. Add products and quantities
  3. System applies price and effective tax rate
  4. Confirm: stock decreases, totals are saved

Print receipt

  1. Click Receipt on a sale
  2. See subtotal, tax and grand total
  3. Print or hand over

Stock check

  1. A sale larger than available stock is rejected
  2. Nothing is saved; the cashier sees a message

Insights / Tax reports

Reports

Ready-made answers, generated on demand from the database views and queries.

Activities and process

Current stock

  1. Open the current-stock view
  2. Filter by category

Low-stock alerts

  1. Open the low-stock view
  2. Items at or below reorder level are listed

Sales per day

  1. Pick a date range
  2. See orders and revenue per day

Best sellers

  1. Count units sold per product
  2. Top five are shown

Tax collected

  1. Pick a period
  2. Tax is totalled by category

Admin / Security & Access

Users & Roles Control Panel

System administrator control desk. Provision staff accounts, manage cryptographic roles, and control permission boundaries.

Activities and process

Add user

  1. Enter username, full name and password
  2. Choose a role
  3. Click Save user

Change role

  1. Find the user in the table
  2. Pick a role from the Role list
  3. The change saves immediately

Delete user

  1. Click Delete on the user row
  2. Click Confirm delete
  3. Blocked for your own account and for users with records

Log in and out

  1. Enter username and password on the login page
  2. Menu and buttons match your role
  3. Click Log out at the bottom of the sidebar to leave