Analytics
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
analytics
shipping
Report Shipping Cost vs Revenue
Compare shipping revenue charged to customers against actual shipping label cost to show whether shipping is a profit center or a loss.
📋 Prompt
Compare shipping revenue collected from customers against actual shipping cost for orders in [LAST 30 DAYS / LAST QUARTER]. What to calculate: Total shipping revenue charged to customers at checkout Total actual shipping label cost paid (from fulfillment/shipping records) Net shipping gain or loss = revenue charged − actual cost Same breakdown split by shipping method offered (standard, express, free-shipping-threshold orders) % of orders that qualified for free shipping, and the shipping cost absorbed by the store for those orders specifically Output format: Summary: total shipping revenue, total shipping cost, net gain/loss Table: shipping method, orders, revenue charged, actual cost, net per method Deliverables: Both outputs A clear statement of whether shipping is currently subsidizing orders (net loss) or contributing margin (net gain), and how much of any net loss is coming specifically from the free-shipping threshold If free shipping is a net cost, the average order value needed to make each free-shipping order breakeven on shipping cost alone
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