Task IntentInventory

Inventory Turnover Analysis

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

What This Sidekick Query Does

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

Prompts

Copy, adapt, and run this directly in Shopify 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

Expected Output

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

Tips to Improve Results

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