Analytics ๐Ÿ’Ž Built for Sidekick โšก Sidekick does this for you
shopify sidekick analytics inventory

Report Sell-Through Rate by Product

Calculate what percentage of received inventory has sold for each product to flag over- and under-buying.

๐Ÿ“‹ Prompt
Run in Sidekick
Calculate sell-through rate for every active product over [LAST 90 DAYS].

Definition:

  Sell-through rate % = units sold in the period รท (units sold + units currently in stock) at the start of the period


Breakdown:

  Sell-through rate per product, sorted lowest to highest
  Group by collection to see which collections are moving fastest vs slowest
  Flag products with sell-through under [20]% โ€” likely overstocked
  Flag products with sell-through over [80]% and low remaining stock โ€” likely about to stock out


Output format:

  Table: product, units sold, units on hand, sell-through %, flag (overstocked / healthy / restock soon)
  Collection-level rollup table


Deliverables:

  Both tables
  A short list of the 5 products most urgently needing a markdown or bundle-clearance push (lowest sell-through, highest tied-up inventory value)
  A short list of the 5 products most urgently needing a reorder (highest sell-through, lowest remaining stock)

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