In this article:

Finding eCommerce Metrics in Shopify: Profit and Cost Metrics

One big strength of Shopify as a platform is its Analytics pages, where you can see how important marketing and eCommerce metrics change over time. Nowadays, awareness of these metrics is a huge advantage in bringing success to a business. This series, therefore, aims to show you how to access these metrics in Shopify.

For this tutorial, we will learn how to access the main profitability metrics in Shopify: gross profit, cost of goods sold (COGS), and sales. To refresh your knowledge, gross profit is your revenue minus COGS, while COGS is the cost of goods to be sold during a particular period. If you need a full review, we have the following articles you can read first:


If you are ready, you can now start reading!

How to access Gross Profit on Shopify

Clicking on the Analytics option on the left side of the admin panel will lead you to the Overview dashboard. At the same time, a list of options will appear below the Analytics label. Click on the Reports option. Afterward, scroll down to look for the Finances box. 

Shopify Behavior and Finances boxes
All things start small.


Click on Finances summary

Shopify Finances summary
Looks detailed.


The Finances summary will contain a Gross profit box, listing a summary of the relevant data for calculating the Gross profit. Clicking on the Gross profit will bring you to a table listing all the orders.

Gross profit page on Shopify
Calculation displayed, item-by-item.


Here’s the thing: for Shopify to accurately calculate the gross profit, you should include the cost for each item you are selling. It will ignore the sales of items that do not have their cost included. 
Shopify Gross profit box under Finances
The Gross profit box in the Finances summary page summarizes the steps in the calculation of Gross profit. 


To see how much was not included in the calculation, you can go back to Finances summary to check it. The amount of net sales that is not included in the calculation is listed as Net sales without cost recorded. If the value was quite larger than the Net sales with cost recorded, which was used to calculate the Cost of goods sold and the resulting Gross profit, you should update the product information to add the cost of the product. Follow the steps here.

How to access Gross Profit Margin on Shopify

Another relevant metric is the Gross Profit Margin metric. This was discussed in the same article as the Gross Profit metric. You can access it by clicking on the Analytics option in the left panel, and then on the Reports option underneath it. 

Profit margin section under Analytics for Shopify
Profit this month to date. Lots of room for improvement


You can also check the individual contributions of each product by clicking on the Profit by product link. A table will be loaded containing the net sales, the cost, the gross margin, and the gross profit. Shopify will only compute this for the products whose costs were declared, however. 

Gross profit table with heat map for each product on Shopify
The gross profit margin listed, item-by-item. Looks like we need to sell more carrots this time.


When you load the table, the items are listed in descending order, starting from the product with the biggest gross profit margin. This will help you identify which products should be advertised more. 

How to access COGS on Shopify

The Gross profit box also contains the Cost of goods sold (COGS) metric. This is calculated for the sold items with their costs included. Clicking on the Cost of goods sold will load a table containing the list of cost of each item sold. 

Item by item COGS table on Shopify
Like the Gross Profit table, the COGS table is also listed item-by-item.



Overview Dashboard on Shopify under Analytics


How to access sales metrics on Shopify

After, when you click the View report link on the upper-right corner of the box, a new page will display the list of sales data, divided by the specified period. It will display a bar chart of sales over a certain period, and a table of sales data below it. 


The table contains Gross sales and Net sales, which correspond to gross profit and net profit, respectively. 

Making metric-hunting a bit easier...

While the profit and cost metrics are accessible on Shopify, checking every day, week, or month for each of these can be a pain. For those who don't look forward to manually finding numbers over and over again, you can check out our Shopify integration that will pull your conversion funnel data alongside other Shopify and eCommerce platform data! Spend more time on data analysis and less time metric-hunting with Lido.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started