Shopify Total Sales Analytics

Total Sales measures the broader Shopify order value by combining Net Sales with tax, shipping excluding tax, duties, and additional fees. It is useful when merchandise revenue alone does not describe the full amount associated with the orders in your report.

How Shopify Total Sales is calculated

Total Sales = Net Sales + Tax + Shipping + Duties + Additional fees

Shipping is counted excluding tax, so the tax component is never added twice. Because Total Sales includes money you collect and pass on, it describes what an order was worth rather than what your store earned.

Why Total Sales is worth reporting

Net Sales answers “how much merchandise revenue did we keep.” Total Sales answers a different question: how much money the order was actually worth once tax, shipping, duties, and fees are counted.

That gap matters more than most merchants expect, especially if you ship heavy items, sell internationally, or charge for delivery. A customer segment with modest Net Sales can be carrying a large share of your shipping and duty revenue, and you would never see it from a merchandise number.

Reporting Total Sales beside Net Sales tells you:

• How much of an order’s value comes from the product versus everything added on top
• Which customers, companies, or markets generate the most order value overall
• Whether shipping and duty charges are a meaningful part of your business or a rounding error
• Which figure to quote when someone asks what a customer or account is “worth”

Use Net Sales to rank merchandise performance and Total Sales when the full amount on the order is what matters, such as reconciling against payouts or sizing a wholesale account.

Total Sales, Net Sales, and Gross Sales

Use Gross Sales to understand original demand. Use Net Sales to rank retained merchandise revenue. Use Total Sales when the wider Shopify order amount matters.

Where Total Sales is available

Total Sales is available on supported customer, company, company-location, and store-level analytics. It can also appear in the Pivot Table worksheet metric builder and in configured store-performance reporting where supported.

The metric menu on the selected worksheet is the final guide because Shopify analytics availability differs by target.

Add Total Sales to a Shopify data worksheet

1. Open a supported Shopify data worksheet

2. Click ＋ Shopify data in the header row of an empty column, or choose Column > Add Shopify data… from the menu bar. The field picker opens

3. Click Sales & analytics in the list of sections on the left, or type the metric's name in the search box

   

4. Click Total Sales. The metric's settings open with it already chosen under Which metric?

5. Under Over what time period?, choose All time, Fixed dates, Rolling period, Calendar year, or Calendar month

6. Under Limit which orders count, add any optional filters supported by the metric

7. Click Save Column

Add Net Sales beside Total Sales when you want to see how much tax, shipping, duties, and fees contribute to the wider result.

Compare Total Sales in a Pivot Table worksheet

The Pivot Table worksheet builder lists Total Sales under Sales. It fills in on Market and Customer segment rows. Rows that group products, such as one row per vendor, product type, category, or tag, show N/A for Total Sales.

1. Click the + at the end of the worksheet tabs, or choose Worksheet > Add worksheet…
2. Select Reporting worksheet, then click Continue
3. Choose a ready-made Pivot Table report, such as Market sales mix or Customer segment contribution, or choose Blank pivot table, then click Continue
4. Under Break down by, choose Market or Customer segment
5. Add Total Sales under Metrics
6. Choose the timeframe under Time period
7. Click Create Worksheet

Pair it with Net Sales, Orders Count, Average Order Value, Total Shipping Amount, and Total Tax Amount, which the builder also lists. To add Total Duties and Total Additional Fees, click ＋ Analytics data in the header row of an empty column once the worksheet exists, and choose the metric under Which metric?.

Useful Total Sales reports

Customer reporting

Total Sales helps rank customers by the wider order amount. Keep Order Count and Average Order Value beside it so one unusually large order does not define the customer without context.

Shopify B2B reporting

On Company or Company Location worksheets, Total Sales can help compare wholesale accounts where shipping, duties, or fees represent meaningful differences between customers.

Market and store reporting

Store-level reporting can place Total Sales beside tax, shipping, duties, and fees across recent months. Market reporting can help explain why two regions with similar Net Sales produce different broader order totals.

Build a Total Sales bridge

A useful set of columns is:

• Net Sales
• Total Tax Amount
• Total Shipping Amount
• Total Duties
• Total Additional Fees
• Total Sales

Use the same timeframe and filters for every column. The values then form a readable bridge from merchandise revenue to the broader Shopify order amount.

Small differences can occur when metrics have different target availability or underlying eligibility. Always compare columns created for the same worksheet rows, dates, and filters.

Total Sales is not profit or cash received

Total Sales does not subtract Cost of Goods Sold, payment processing, marketing, operating expenses, or other business costs. It is also not a bank-deposit or Shopify Payments payout metric.

Use Shopify profit and margin analytics for product-cost reporting. Use Payouts and Balance Transactions worksheets when you need Shopify Payments settlement records.

For charge definitions, see Shopify tax, shipping, duties, and fee analytics.