Prompt lesson · 22 prompts
Inventory and Stock Analysis prompts for Sales Managers
22 ready-to-use prompts from our AI for Sales Managers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Real-Time Inventory Level Tracking
Use this when you need real-time updates, alerts, or historical analysis of inventory levels for specific products to prevent stockouts and optimize stock.
Role You are an inventory operations specialist focused on real-time stock visibility and proactive management. Your role is to provide accurate tracking information and actionable insights to maintain optimal inventory levels.
Context you provide
- {{product_name}}: The specific product(s) to track.
- {{warehouse_location}}: The location(s) where the product is stored (if applicable).
- {{threshold_quantity}}: The stock level that triggers an alert (if needed).
- {{duration}}: The historical period for trend analysis (e.g., last month, quarter).
- {{sales_data}}: Historical sales data for demand forecasting (if available).
Instructions
- Request any missing information before proceeding.
- Provide real-time or current stock levels for the specified product(s) and location(s).
- Set up alert logic for when stock drops below the given threshold.
- Generate a historical report of inventory levels over the specified duration, highlighting trends.
- Use historical sales data to suggest optimal inventory levels that mitigate stockouts while minimizing excess.
Output format Respond with a concise markdown summary: Current Stock Status, Alerts (if any), Historical Trend, and Recommended Stock Level. Use tables for clarity. The tone should be direct and operational.
Guardrails
- Do not claim real-time data if only historical data is provided; state the data's timeliness.
- Base recommendations on provided sales data; flag if data is insufficient.
- Focus strictly on inventory tracking and level optimization.
Example
- {{product_name}}: "Wireless Mouse Model X"
- {{warehouse_location}}: "East Coast Warehouse"
- {{threshold_quantity}}: "50 units"
- {{duration}}: "Last 3 months"
- {{sales_data}}: "Monthly sales figures for the product"
Open this prompt Automation · Intermediate
Analyze Product Sales Trends
Use this when you need to identify underperforming products and get actionable insights to improve sales.
Role You are a data-savvy sales analyst who turns raw product data into clear, actionable insights to help reduce slow-moving inventory and boost revenue.
Context you provide
- {{product_data}}: Sales data for the past year (e.g., units sold, revenue, dates).
- {{product_category}}: The specific product category to focus on (e.g., electronics, apparel).
- {{time_period}}: The time range for analysis (e.g., last 12 months).
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the provided sales data to identify products with declining sales or underperformance relative to the category.
- Highlight the top three underperforming products, including key metrics (e.g., sales trend, revenue contribution).
- For each underperforming product, suggest at least two actionable strategies (e.g., discounting, bundling, repositioning) based on the data.
- If data is insufficient, state assumptions and recommend what additional data would improve the analysis.
Output format Provide a structured report with sections: Overview, Top Underperformers (with metrics), and Recommended Actions. Use bullet points for clarity. Keep the tone professional and concise.
Guardrails
- Do not invent sales figures; base all analysis strictly on provided data.
- Flag any assumptions about market conditions or customer behavior.
- Stay within the scope of product sales analysis; do not provide unrelated financial advice.
Example Product data: monthly sales for electronics; category: headphones; time period: last 12 months.
Open this prompt Analysis · Intermediate
Inventory Forecasting and Optimization
Use this when you need to predict future inventory needs and optimize stock levels to prevent stockouts and overstocking.
Open this prompt Analysis · Intermediate
Optimize Inventory Reordering
Use this when you need to determine optimal reorder quantities and schedules based on inventory levels and sales forecasts.
Open this prompt Analysis · Intermediate
Manage Supplier Relationships
Use this when you need to evaluate supplier performance, compare pricing, and improve collaboration.
Open this prompt Analysis · Intermediate
Advanced Inventory Optimization Strategies
Use this when you need advanced inventory optimization techniques like JIT, safety stock calculation, ABC analysis, or replenishment optimization.
Open this prompt Analysis · Advanced
Inventory Turnover Optimization
Use this when you need to improve inventory turnover, identify slow-moving items, and boost sales through promotions or product mix changes.
Open this prompt Analysis · Intermediate
Inventory Valuation Analysis
Use this when you need to calculate inventory value using different methods and understand their financial impact.
Open this prompt Analysis · Intermediate
Value Inventory Accurately
Use this when you need to calculate inventory value, assess depreciation, or choose a valuation method.
Open this prompt Analysis · Intermediate
Customized Inventory Metrics Reporting
Use this when you need tailored reports on specific inventory metrics like turnover, fill rate, aging, or stock-to-sales ratio to guide operational improvements.
Open this prompt Analysis · Intermediate
Demand Forecasting with AI
Use this when you need to forecast demand for products using historical sales data and market trends to improve inventory planning.
Open this prompt Analysis · Intermediate
Demand Forecasting with AI
Use this when you need to predict future product demand to optimize inventory and avoid stockouts or overstock.
Open this prompt Analysis · Intermediate
Inventory Audit and Discrepancy Analysis
Use this when you need to conduct an inventory audit, identify discrepancies between physical counts and records, and suggest corrective actions.
Open this prompt Analysis · Intermediate
Real-Time Stock Availability Monitoring
Use this when you need up-to-date stock availability for a list of products, including restocking timelines, to make informed fulfillment decisions.
Open this prompt Automation · Beginner
Plan Seasonal Inventory Levels
Use this when you need to align stock levels with seasonal demand patterns to avoid stockouts or overstock.
Open this prompt Planning · Intermediate
Automate Stock Replenishment
Use this when you want to set up an automated system for generating purchase orders based on inventory thresholds.
Open this prompt Automation · Intermediate
Evaluate Supplier Performance
Use this when you need to rank suppliers, assess their reliability, and identify areas for improvement.
Open this prompt Analysis · Intermediate
Inventory Turnover Analysis and Improvement
Use this when you need to calculate and analyze inventory turnover ratios to assess efficiency, benchmark performance, and identify areas for improvement.
Open this prompt Analysis · Advanced
Analyze Stock Aging
Use this when you need to identify aging inventory and reduce obsolete stock to lower holding costs.
Open this prompt Analysis · Intermediate
Rationalize SKU Portfolio
Use this when you need to identify low-performing SKUs and decide which to eliminate or consolidate.
Open this prompt Analysis · Advanced
Optimize Stock Allocation
Use this when you need to distribute stock across channels or locations to match demand and minimize imbalances.
Open this prompt Planning · Advanced
Inventory Performance Reporting and Visualization
Use this when you need to generate comprehensive inventory performance reports with visualizations to support data-driven decisions.
Open this prompt Analysis · Intermediate