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
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
- 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