Section 01 · Status board Inventory Control
/
$0Retail value
0At reorder
0Stockout
01 / STATUS

Warehouse board

Live materialised stock column, reconciled against the full movement ledger on every write.

—
Total inventory value at sell price · SUM(current_stock * sell_price)
$0
+0.0% / 30d 0 units on hand $0 at cost
series: ledger replay, 60 days·margin —
SKUs tracked0
Locations0
Categories0
Low / at reorder0
Stockouts0
Movements 30d0
02 / QUERY 1

Low stock alert

Every SKU at or below its reorder point — the purchase-order trigger, ranked by severity.

Q1

Low Stock Alert

WHERE current_stock <= reorder_level

            

            

              

                

                  ProductSKUOn handReorder
                  Position vs reorderStatusSuggested order
                

                
              

              

                
Materialised column proof. current_stock is recomputed as opening_stock + Σ(in) − Σ(out) ± Σ(adjustment) after every write.

                

              

            

          

        

      


      
      

        

          

            

              Q2
              
Inventory Value Report
GROUP BY category

              

                
                
                
              

            

            

              

              

              

                

                

              

            

          

        


        

          

            

              Q4
              
Top Selling Products
type = 'out' · last 30 days · LIMIT 10

              

                
                
                
              

            

            

              

              

              

            

          

        

      


      
      

        

          

            Q3
            
Stock Movement History
JOIN products · timestamp >= DATE_SUB(NOW(), INTERVAL 30 DAY) · ORDER BY timestamp DESC

            

              
              
              all
              in
              out
              adjust
              
            

          

          

            

            

            

              

                

                

                  ▲ units in▼ units out◆ adjustment
                  ·net — units across the window
                

                

                  ProductTypeQtyTimestampReason
                

                
              

              

                
Feed. Newest first — the same result set Q3 returns, bound to the live ledger.

                

              

            

          

        

      


      
      

        

          03 / CRUD
          
Product catalog

          
products table — filter, sort, add, edit, delete, log stock.

          
          
        

        

          

            

              all categories
              
              
              
              
              24 rows
            

            

              SKU
              Product
              CategoryBin
              On hand ↕
              Reorder
              Sell
              Line value ↕
              Status
            

            
          

        

      


      
      

        

          04 / CONSOLE
          
Query lab

          
The four required queries plus your own SQL, executed by the in-page miniSQL engine.

        

        

          

            
Editor
SELECT · JOIN · GROUP BY · HAVING · ORDER BY · LIMIT · CASE · DATE_SUB

              

            

            

              

              
              
⌘/Ctrl + Enter to run·write statements are rejected

            

          

          

            
Result set
—