Online Shoes Store Database

Final Project PHP + MySQL Application

System Overview

This database driven website tracks an online shoes shopping store. The system stores customer information, shoe items, vendors, warehouses, stock levels, shopping carts, orders, order items, and payment transactions. Users can create, read, update, and delete records for the major entities. The application also includes reports that show useful business information, such as inventory by warehouse, customer order history, sales by item, monthly sales, and payment transaction totals.

Main Sections

Customers

Manage customers records.

Open

Vendors

Manage vendors records.

Open

Warehouses

Manage warehouses records.

Open

Items

Manage items records.

Open

Stock

Manage stock records.

Open

Shopping Carts

Manage shopping carts records.

Open

Orders

Manage orders records.

Open

Order Items

Manage order items records.

Open

Transactions

Manage transactions records.

Open

Reports

View database reports generated from SQL queries.

Open Reports