Supermetrics includes two fields that make it simple to add a Shopify store’s profitability data to your reporting.
Combine these fields to start analyzing profits:
Cost of goods sold
The total cost of all the units sold
Gross profit
The total profit, calculated by subtracting the cost of goods sold from net sales
Example setup
Let’s say a Shopify store records these sales in the past 7 days:
2 pairs of sunglasses with a unit cost of $25 and a sales price of $30
1 shirt with a unit cost of $100 and a sales price of $120
3 hats with a unit cost of $50 and a sales price of $60
To find out the profitability for that month, you'd create a Supermetrics query covering the past 7 days, and select Cost of goods sold and Net sales as your metrics.
In this case, the Cost of goods sold metric would return a value of $300, while Net sales would return $360.
By creating a cell or report that subtracts these two values from each other, you’ll be able to include a profitability value that will automatically update each time you run your query. For the example store’s month, that field would contain a value of $60.