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