Spreadsheets
Inventory / Stock Tracker
Keep track of stock levels and know exactly when to reorder.
Updated: January 26, 2026
What does this AI prompt do?
This AI prompt helps UK SMEs by providing a ready-to-use template for keep track of stock levels and know exactly when to reorder.. Simply copy the template below, customize the variables for your business, and paste into any AI tool like ChatGPT or Claude.
AI Prompt Template
Act as a specialist consultant. **Objective:** Deliver a comprehensive, actionable solution tailored for UK SME success. Here is the improved business prompt template, maintaining the exact structure while maximizing clarity, persuasiveness, and expected results: I require a **High-Performance Stock Control Spreadsheet Template** specifically tailored for a **[Shop Type | text]** operation. **Essential Columns to Implement:** SKU, Product Name, Supplier, Cost Price, Sell Price, Quantity on Hand, Reorder Level, Status. **Mandatory Tasks for Immediate Implementation:** 1. Precisely construct the necessary table layout with clear, professional formatting. 2. Integrate an **automated 'Status' column** using a precise 'IF' formula: If 'Quantity on Hand' falls below the defined 'Reorder Level', the cell **must** display the urgent alert "**REORDER**"; otherwise, it should clearly display "**OK**". 3. Provide the **accurate financial formula** required to calculate the **Total Current Stock Value** by multiplying 'Cost Price' by 'Quantity on Hand' for each line item.
How to use this prompt:
- Copy the template above
- Customize the variables in brackets [like this] with your business details
- Paste into ChatGPT, Claude, or your preferred AI tool
- Get professional results in minutes
Why this works:
This prompt uses proven business frameworks and UK-specific requirements. It's designed to give you professional results that comply with local regulations and industry best practices.