inventory tracking with forms + tables + workflows

sharing our inventory management setup because i think its cool and maybe useful for other small ecommerce folks we sell handmade candles (about 200 SKUs). our setup: stock tracking table: product name, SKU, current_stock, reorder_point, supplier, cost order form: staff fills out when shipping an order. auto-decrements stock in the table restock alert workflow: runs daily, checks for products below reorder point, emails our procurement person with a list incoming stock form: when new stock arrives, scanned in and table gets updated weekly inventory report: scheduled workflow that summarizes stock levels, low stock items, and top sellers before this we were using a google sheet that was always out of date because nobody remembered to update it after shipping orders. now the stock updates happen automatically when the shipping form is filled out the reorder alerts alone saved us from 3 stockout situations in the first month