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.
Prompt / Skill
Copy, adapt, and run this prompt or skill workflow 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
Sidekick Skills & Magic Prompt
Create & Manage AI skills for Sidekick. Discover AI skills from other merchants.
Build unlimited custom Sidekick skills, organize prompts into collections, and discover proven workflows shared by other Shopify merchants.