Inventory Turnover Analysis

Analyze inventory turnover rates by product and collection to identify your most and least capital-efficient items.

View as Markdown

📋 Prompt

Run in Sidekick

Analyze my inventory turnover performance:

Time period: Last [90] days

Calculate for each product/collection:

  Inventory turnover ratio (cost of goods sold / average inventory)
  Days to sell (average days inventory sits before selling)
  Sell-through rate (units sold / units received)
  Gross margin return on inventory (GMROI)


Break down by:

  Top 10 highest turnover products (most efficient)
  Bottom 10 lowest turnover products (least efficient)
  Turnover by collection/category
  Turnover trend over time (improving or declining)


Insights I need:

  Which collections are most capital-efficient?
  Which products should I stock more of?
  Which products should I reduce inventory for?
  What is my overall store turnover rate?
  How does it compare to typical e-commerce benchmarks?


Recommendations:

  Specific actions to improve turnover for bottom performers
  Optimal stock levels for top performers

How to Use

Copy the prompt above
Open Shopify Sidekick in your Shopify admin
Paste the prompt and replace the bracketed placeholders with your details
Review Sidekick's response and apply the suggestions