Small Business Inventory Tracker
Track stock levels with reorder alerts.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Build an inventory tracker with reorder alerts. Business and items: [BUSINESS_AND_ITEMS]. Spreadsheet app: [SPREADSHEET_APP]. Suppliers and lead times: [SUPPLIERS_AND_LEAD_TIMES]. Count method: [COUNT_METHOD]. Design the workbook and confirm each item in your answer: [ ] Item master: SKU, name, category, unit, supplier, cost, price, minimum stock, reorder quantity, location [ ] Transaction log: date, SKU, type (received, sold, adjusted, returned, damaged), quantity, reference; data validation for SKU and type [ ] Stock on hand computed from the log with SUMIFS (received minus issued plus adjustments), not typed by hand [ ] Reorder flag when stock is at or below the reorder point (average daily use times lead time plus safety stock) [ ] Order list by supplier generated with a filter or query [ ] Stock value by category and total [ ] Slow-mover report: no sales in 90 days [ ] Count sheet and variance report (counted versus system) with a tolerance [ ] Protection: locked formula cells, a backup routine, and a change history [ ] Dashboard: items to reorder, stockouts, value, and top sellers [ ] Weekly routine under 15 minutes Provide the formulas, a sample of ten items with transactions and the expected results, and notes on mistakes to avoid (editing stock directly, mixed units, duplicate SKUs).
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.