Shopify Gross Sales Analytics

Gross sales in Shopify are the total sales of all products over a period of time. In e-commerce, the number represents a business’s total revenue without deductions, returns, refunds, or allowances.

Gross Sales = Total Units Sold x Original Sale Price

Note: Gross Sales may differ from Gross Revenue. Gross Sales account for customer-generated revenue, while Gross Revenue also includes investment revenue (in case you have such).

What is Gross Sales Metric Used for?

• Measuring Gross Sales over time (e.g., Week over Week or Month over Month) shows the store’s overall health and benchmarks it against competitors.
• Gross sales allow you to measure the total amount of revenue made by your store.

How to add Gross Sales data to your worksheet

If you have already created a Mixtable workbook for your Shopify store, you can quickly add the Gross Sales to an existing worksheet.

• The worksheet needs to be showing product or collection information. E.g., Products - Complete, Product - Basic, Manual Collections, Automated Collections
• Choose an empty column (or insert a new one) and click the Link button from the column header.

• From the Shopify Sync Settings window, choose Analytics

• Then, select the Gross Sales metric

• Select the time range that you want the data to be calculated for

  • For all time - all sales since the creation of the store
  • Fixed date range - show data for a specific period between two dates
  • Dynamic date range - calculate the Gross Sales for a dynamic time period in the past, e.g., last 7 days, last 30 days. If you select this option, the data will be recalculated daily as the date range window moves forward.
  • Calendar year and month - show the Gross Sales for a specific year (e.g., 2023) or a specific month (e.g., August 2024)

PRO TIP - Start with one of our pre-built Analytics templates

Instead of manually loading the Gross Sales data in a worksheet, you can get going faster by starting with one of our Analytics template workbooks. These workbooks come pre-loaded with the types of analytics that our clients tend to need most.

• After installing the Mixtable Analytics app, click the Create a Workbook button.
• In the dialog that appears, select the Monthly Sales or Annual Sales pre-built templates.

• Choose the Gross Sales worksheet. It will automatically load with the following columns:

  • Product Title

  • Handle

  • Gross sales:

    • a column showing Gross Sales for all time
    • a column showing Gross Sales for each of the last 24 calendar months

Note: This workbook has two worksheets - one for Net Sales and one for Gross Sales.

Optional - Gross Sales for a Customer Segment

Mixtable Analytics allows the Gross Sales data to be filtered based on the customer segments you have created in Shopify.

• From the Shopify Sync Settings window, choose Analytics

• Then, select the Gross Sales metric

• Select the time range that you want the data to be calculated for

  • For all time - all sales since the creation of the store
  • Fixed date range - show data for a specific period between two dates
  • Dynamic date range - calculate the Gross Sales for a dynamic time period in the past, e.g., last 7 days, last 30 days. If you select this option, the data will be recalculated daily as the date range window moves forward.
  • Calendar year and month - show the Gross Sales for a specific year (e.g., 2023) or a specific month (e.g., August 2024)

• Now, use the Filter orders based on Customer Segment defined in Shopify Admin section to select the customer segment to be used.

Note: The customer segments shown are the ones you have defined in your Shopify Admin. To add or change your segments please use the Shopify Admin, and Mixtable will reflect your changes automatically.

Optional - Gross Sales by Country

Another option for filtering Gross Sales data is according to the customer’s country. Use this feature to calculate your international store performance.

• From the Shopify Sync Settings window, choose Analytics

• Then, select the Gross Sales metric

• Select the time range that you want the data to be calculated for

  • For all time - all sales since the creation of the store
  • Fixed date range - show data for a specific period between two dates
  • Dynamic date range - calculate the Gross Sales for a dynamic time period in the past, e.g., last 7 days, last 30 days. If you select this option, the data will be recalculated daily as the date range window moves forward.
  • Calendar year and month - show the Gross Sales for a specific year (e.g., 2023) or a specific month (e.g., August 2024)

• Use the Filter orders based on customer’s country to select the country for which to show the Gross Sales.

You are ready!

Well done! Now that you have Gross Sales data in an online spreadsheet for products or collections, you can use any spreadsheet function to analyze the data, such as:

• sorting ascending or descending,
• find-replacing,
• filtering,
• using formulas, etc.

Find out more about the Mixtable suite of products here.