Inventory Tracker
Stock and orders in a Google sheet. A delivery updates the stock. It has a CSV import and alerts when stock runs low.
The problem
Stock and orders were two files, and the stock moved only after the parcel had left.
What I built
- Fulfilling an order updates the stock.
- A Shopify and Etsy style CSV import.
- A flag and an email when stock falls under the line.
- A purchase order, with a PDF.
Stack
Google SheetsApps Script
Images
