Analytics
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
analytics
variants
Report Variant-Level Performance
Break sales down to the size/color/style variant level to find which specific variants sell and which sit dead.
📋 Prompt
For product [PRODUCT NAME] (or all products in collection [COLLECTION NAME]), break down sales by variant for [LAST 90 DAYS]. Per variant (e.g. each size/color combination): Units sold Revenue % of the parent product’s total units sold Current units on hand Sell-through rate (units sold ÷ units sold + on hand) Ranking within each product: Best-selling variant and worst-selling variant Any variant with 0 sales in the period despite having stock available the whole time Any variant that’s sold out but still shows meaningful demand (was selling well before running out) Output format: Table grouped by parent product: variant, units sold, revenue, % of product total, on hand, sell-through % Deliverables: The table A list of consistently dead variants (0 or near-0 sales despite availability) worth discontinuing at next reorder to simplify the catalog A list of variants that sold out and are worth prioritizing in the next purchase order, given their pre-stockout sell rate
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