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

  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