Analytics 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick analytics margin

Report Product-Level Gross Margin

Rank every active product by gross margin dollars and percentage using logged cost data.

📋 Prompt
Run in Sidekick
Build a product-level gross margin report for [LAST 30 DAYS / LAST QUARTER], using the cost-per-item values already saved on each product/variant.

Per-product metrics:

  Units sold
  Revenue (net of discounts and refunds)
  Cost of goods sold (units sold × cost per item)
  Gross margin $ = revenue − COGS
  Gross margin % = gross margin $ ÷ revenue


Rank and group:

  Top 15 products by gross margin $ (the products actually making the store money)
  Bottom 15 products by gross margin % among products with at least [10] units sold
  Any products missing a cost-per-item value — list them separately since their margin can’t be calculated


Output format:

  Table sorted by margin $ descending: product, units sold, revenue, COGS, margin $, margin %
  Separate table for the missing-cost-data products


Deliverables:

  The two tables above
  3 products that look like strong revenue performers but weak margin performers (candidates for a price review)
  A one-line note on how much total revenue is currently un-costed (missing cost-per-item), since that’s a data-quality flag, not just a reporting gap

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