← All templates
Analyze Shopify + Stripe + Ads + COGS sheet → Dashboard

Profit by SKU after all costs

Real net margin per SKU. Revenue minus COGS, ad spend, fees, shipping.

The exact prompt
"Show net margin by SKU for the last 30 days. Include COGS, ad spend, platform fees, and shipping. Flag anything below 15%." Open in Tablize →

What you get back

A SKU-level margin table with sortable columns and red highlights for anything under 15% margin.

Profit-by-SKU is the number every DTC operator wants and few have because the data lives in 5 systems. The agent joins Shopify revenue with COGS from your sheet, ad spend from Meta/Google, fees from Stripe, and shipping from your label provider — and gives you the actual net margin per SKU. Anything below your threshold lights up red.

Use this when: you suspect your “best-selling” SKU is actually losing money once you include true cost.

Spec

Job
Analyze
Data needed
Shopify + Stripe + Ads + COGS sheet
Output kind
Dashboard
Best for
Operator
Tags
margin · profit · ecommerce · dashboard

Run this on your own data.

Drop in your CSV or connect your database. Get the answer in under 60 seconds.

Try this template free