Analytics
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
analytics
products
Report Best and Worst Sellers by Period
Rank every product by revenue and units for a chosen period and highlight the biggest movers vs last period.
📋 Prompt
Rank all products by performance for [LAST 30 DAYS], and compare each to the prior period of equal length. Per product: Units sold Revenue Rank this period vs rank last period Change in units sold, absolute and % Lists to produce: Top 15 products by revenue this period Bottom 15 products by revenue this period, among products that had at least 1 unit sold in either period (so genuinely inactive products don’t clutter it) Biggest movers up: products whose rank improved the most vs last period Biggest movers down: products whose rank fell the most vs last period Output format: Four short tables, one per list above: product, units, revenue, rank change Deliverables: All four tables One sentence flagging anything that looks like a data anomaly rather than a real trend (e.g. a single bulk order skewing a low-volume product’s numbers) One product worth featuring more prominently (rising fast, healthy margin) and one worth reviewing for a markdown or delisting (falling fast, high 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