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
Run in Sidekick
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

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