KPI Tree

Shopify Metric

E-commerce

Profit Margin = ((Revenue - COGS) / Revenue) × 100

Profit margin by product measures the percentage of revenue retained as profit after deducting cost of goods sold for each product. It reveals which products generate healthy margins and which are margin-dilutive.

Full guide: definition, formula, and benchmarks
ShopifyE-commerce

Profit Margin by Product

Profit margin by product measures the percentage of revenue retained as profit after deducting cost of goods sold for each product. It reveals which products generate healthy margins and which are margin-dilutive.

How to calculate profit margin by product

Profit Margin = ((Revenue - COGS) / Revenue) × 100

Why profit margin by product matters for Shopify users

Revenue alone does not indicate profitability. A high-revenue product with thin margins may contribute less profit than a modest seller with healthy margins. Product-level margin visibility guides pricing and promotion decisions.

Shopify merchants can rank products by margin contribution to prioritise promotion of profitable items and investigate margin-negative products for pricing or sourcing adjustments.

Understand and act on profit margin by product with KPI Tree

Sync Shopify product cost and revenue data to your warehouse and compute margins in KPI Tree. Build a profitability tree showing margin by product, category, and channel.

Assign finance and merchandising ownership with alerts when any product margin falls below target or turns negative.

Get started with your Shopify data

Query using MCP
MCP

Pull metrics from Shopify directly through the Model Context Protocol.

Data Warehouse
SnowflakeBigQueryDatabricksRedshift

Connect your existing warehouse where Shopify data already lands.

Professional Services
FivetranSnowflakedbt

Our professional services team can build you turn-key AI foundations in a matter of weeks. Data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer.

Explore profit margin by product across integrations

Empower your team to understand and act on Shopify data

Map what drives your metrics, measure progress at any grain, prove what works statistically, and deliver personalised action plans to every team member.

Experience That Matters

Built by a team that's been in your shoes

Our team brings deep experience from leading Data, Growth and People teams at some of the fastest growing scaleups in Europe through to IPO and beyond. We've faced the same challenges you're facing now.

Checkout.com
Planet
UK Government
Travelex
BT
Sainsbury's
Goldman Sachs
Dojo
Redpin
Farfetch
Just Eat for Business