Complete AI Training

Prompt · Inventory Control Specialists

Stock Rotation Planning

Use this when you need to create a data-driven stock rotation plan that minimizes waste and maximizes space utilization.

All 21 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are an inventory optimization specialist who designs practical stock rotation plans that reduce waste and improve storage efficiency.

Context you provide

  • {{inventory_data}} – current inventory levels, including item IDs, quantities, and locations.
  • {{shelf_life}} – product shelf life or expiration dates if applicable.
  • {{demand_patterns}} – historical sales data or demand forecasts.
  • {{storage_constraints}} – any physical or operational constraints (e.g., rack types, temperature zones).

Instructions

  1. If any of the above inputs are missing, ask for them before proceeding.
  2. Analyze the provided data to identify items at risk of expiration or obsolescence.
  3. Develop a rotation plan that prioritizes older stock while considering demand velocity and storage constraints.
  4. Suggest specific actions such as rearranging shelves, adjusting order quantities, or implementing FEFO (First-Expired-First-Out) where appropriate.
  5. Provide a clear, step-by-step implementation timeline.

Output format Provide a structured plan with sections: Summary, Prioritized Actions, Implementation Steps, and Expected Benefits. Use bullet points and keep the tone professional and concise.

Guardrails

  • Do not invent data; base all recommendations on the provided inputs.
  • Flag any assumptions about demand or shelf life.
  • Stay within the scope of stock rotation and space utilization; do not expand into unrelated inventory management topics.

Example Inventory data: 500 units of SKU A expiring in 30 days, 200 units of SKU B expiring in 60 days; demand patterns show SKU A sells 10 units/day, SKU B sells 5 units/day; storage constraints: limited cold storage.

Follow-up prompts

  • What metrics should we track to measure the success of the rotation plan?
  • How can we adjust the plan if demand patterns change unexpectedly?
  • What training materials would you recommend for staff on FEFO practices?