Prompt lesson · 21 prompts
SKU Rationalization prompts for Inventory Managers
21 ready-to-use prompts from our AI for Inventory Managers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze Inventory and Sales Data
Use this when you need to identify slow-moving or obsolete inventory items to optimize stock levels and reduce carrying costs.
Role You are an inventory analyst with expertise in sales and stock data. Your goal is to help me identify slow-moving or obsolete SKUs and provide actionable recommendations for inventory optimization.
Context you provide
- {{sales_data}}: Sales data for the relevant period (e.g., last 6 months, past year).
- {{inventory_data}}: Current inventory levels for the SKUs.
- {{category}}: (Optional) Specific product category to focus on.
- {{time_period}}: The time frame for analysis (e.g., last 6 months, past year).
Instructions
- If any required data is missing, ask for it before proceeding.
- Analyze the sales and inventory data to calculate turnover rates for each SKU.
- Identify SKUs with low turnover or declining sales trends that may be at risk of becoming obsolete.
- For each identified SKU, provide a brief explanation of why it might be underperforming (e.g., seasonality, changing demand).
- Recommend inventory reduction strategies, such as discounting, bundling, or discontinuing, and prioritize them by potential impact.
Output format Provide a report with a table listing SKUs, turnover rates, sales trends, and risk level. Follow with a section of recommendations, each with a rationale and expected outcome. Use clear, concise language.
Guardrails
- Do not invent specific numbers; base analysis on the data provided or clearly state assumptions.
- Flag any data gaps that could affect the analysis.
- Stay focused on inventory optimization; avoid unrelated operational advice.
Example
- {{sales_data}}: "Monthly sales report for SKUs from Jan to Jun 2024"
- {{inventory_data}}: "Current stock levels as of Jul 2024"
- {{category}}: "Electronics"
- {{time_period}}: "Last 6 months"
Open this prompt Analysis · Intermediate
Categorize SKUs by Demand and Profitability
Use this when you need to classify your inventory SKUs into meaningful categories for better inventory optimization.
Role You are an inventory optimization specialist. Your goal is to categorize SKUs based on demand, profitability, and seasonality to help prioritize inventory decisions.
Context you provide
- {{list of SKUs or product categories}}: Names or identifiers of items to be categorized.
- {{demand data}}: E.g., monthly sales volumes, units sold per period.
- {{profit margin data}}: E.g., unit cost, selling price, margin percentage.
- {{seasonality patterns}}: If known, e.g., which items are seasonal or non-seasonal.
Instructions
- Ask for missing inputs.
- Define clear categories for each dimension (e.g., A/B/C for demand, high/low margin, seasonal/non-seasonal).
- Provide a method to combine these into a composite category (e.g., “High-demand, High-margin, Seasonal”).
- Explain how to use these categories for inventory actions (e.g., reorder points, safety stock levels, clearance strategies).
Output format A table or matrix showing the categories, recommended actions for each, and key insights. Include a short explanation of the logic. Tone: clear, actionable, with examples. Length: 300–400 words.
Guardrails
- Do not use actual SKU data without anonymization.
- Suggest general principles rather than fixed thresholds (e.g., “top 20% of demand” instead of a hard number).
- Keep categorization logic simple and explainable to non-experts.
Example SKUs: 1000 product SKUs; Demand data: last 12 months; Profit margin: average 20%; Seasonality: known for holiday items.
Open this prompt Analysis · Intermediate
Categorize SKUs by Performance
Use this when you need to categorize SKUs by sales performance, profitability, and other metrics to inform inventory decisions.
Open this prompt Analysis · Intermediate
SKU Consolidation Analysis
Use this when you need to identify opportunities to consolidate similar SKUs to reduce inventory complexity and improve efficiency.
Open this prompt Analysis · Intermediate
SKU Consolidation Analysis
Use this when you need to identify SKUs that can be consolidated to reduce inventory complexity and improve efficiency.
Open this prompt Analysis · Intermediate
Identify SKUs for Discontinuation
Use this when you need to analyze sales data, profitability, and customer feedback to identify which SKUs should be discontinued.
Open this prompt Analysis · Intermediate
Tracking SKU Performance
Use this when you need to analyze sales data, compare SKUs, and generate performance reports.
Open this prompt Analysis · Intermediate
SKU Inventory Management Optimization
Use this when you need to analyze SKU-level data, forecast demand, categorize products, and recommend inventory strategies to reduce stockouts or overstock.
Open this prompt Analysis · Intermediate
Analyze SKU Profitability
Use this when you need to identify low-performing SKUs for potential rationalization by calculating profitability metrics and ranking them.
Open this prompt Analysis · Intermediate
SKU Profitability Analysis
Use this when you need to evaluate the profitability of individual SKUs and make data-driven inventory decisions.
Open this prompt Analysis · Intermediate
Forecast SKU Demand with Historical Data
Use this when you need to analyze historical sales data and generate demand forecasts for specific SKUs.
Open this prompt Analysis · Advanced
SKU Demand Forecasting
Use this when you need to forecast demand for specific SKUs based on historical data, seasonal patterns, and external factors.
Open this prompt Analysis · Intermediate
SKU Optimization Analysis
Use this when you need to identify underperforming SKUs and optimize inventory assortment based on demand and market trends.
Open this prompt Analysis · Intermediate
SKU Portfolio Analysis and Optimization
Use this when you need to evaluate your SKU portfolio to identify underperformers, prioritize resources, and make data-driven decisions.
Open this prompt Analysis · Advanced
Analyze SKU Performance Metrics
Use this when you need to evaluate how different SKUs are performing across various dimensions to inform inventory and marketing decisions.
Open this prompt Analysis · Intermediate
SKU Discontinuation Impact Analysis
Use this when you need to evaluate the effects of removing specific SKUs from your inventory on sales and operations.
Open this prompt Analysis · Intermediate
SKU Inventory Optimization
Use this when you need to adjust inventory levels for multiple SKUs based on demand patterns and lead times to minimize stockouts and overstock.
Open this prompt Analysis · Intermediate
SKU Rationalization Strategy Development
Use this when you need to analyze your inventory data and develop a data-driven strategy to optimize your SKU portfolio based on sales performance, demand, and lifecycle.
Open this prompt Planning · Intermediate
Assess SKU Rationalization Impact
Use this when you need to evaluate the potential effects of reducing SKU variety on sales, costs, and customer satisfaction.
Open this prompt Analysis · Intermediate
Communicate SKU Rationalization Decisions
Use this when you need to create communication materials for internal or external stakeholders about SKU rationalization decisions.
Open this prompt Communication · Intermediate
Create SKU Rationalization Plan
Use this when you need a detailed implementation plan for phasing out low-performing SKUs, including timeline, responsibilities, risk mitigation, and communication.
Open this prompt Planning · Intermediate