Low Stock Alerts
Top Selling Products - Last 30 Days
Inventory Value by Category
Recent Stock Movement History - Last 30 Days
Product Inventory
Log Stock Movement
Stock Movement History - Last 30 Days
Simulated SQL Analytics
The application stores data in two in-memory tables: products and stock_movements.
Each required SQL query below is documented as SQL and implemented in JavaScript as a simulated query engine.
Export CSV Reports
Query 1 - Low Stock Alert
SQL
Result
Query 2 - Inventory Value Report
SQL
Result
Visualization
Query 3 - Stock Movement History
SQL
Result
Query 4 - Top Selling Products
SQL
Result
Visualization