Automated Inventory Management Tool

This system is a fully functional inventory and order management tool built entirely in Google Sheets, using Apps Script and Google Workspace integrations. It supports order intake via both Google Forms and a custom popup form, automated stock updates, and partial/full fulfillment logic with status tracking. Orders are split into Pending and Completed, and each transaction is logged in a detailed Inventory Transactions sheet, including stock changes and user activity. A built-in reorder alert system flags low stock items, and a dashboard provides insights like top-selling products, total sales, and stock value. Designed for small businesses looking to automate their inventory without expensive software.