🤵Sales

Sales reports show your customer order details by criteria like sales over time, by product, by channel, and others.

Sales reports track product values as you sell them and process returns.

A sale is said to have occurred when a customer places an order and completes the checkout with payment. These reports include every line item and shipping charge (if applicable) in order as a separate sale item.

Sales reports include sales and returns from open, archived, canceled, pending, and converted draft orders. They do not include sales and returns from deleted or test orders.

Cancelled Orders

When you cancel an order, it appears as a sale for the day that it was placed and a return for the day that it was cancelled. So your sales numbers are zero for that order overall.

Deleted Orders and Test Orders

Only deleted and test orders placed during Shopify Payments' test mode are excluded from reports.

Sales v/s Payments

Sales reports don't track money moving between you and your customers. When a sale is made, the reports show the value of goods included in the sale, not the amount of money you've received. Depending on how you've set up your payment methods, you might not receive the actual payment until a later date.

Common Sales Report terms

The sales reports use the following common terms:

Terms	Definition
Units per transaction	Equates to Net Quantity / Total Orders.
Average order value	The average value of a staff's sales.
Orders	The number of orders that were placed on a given date.
Gross sales	Equates to product price x quantity (before taxes, shipping, discounts, and returns) for a collection of sales. Canceled, pending, and unpaid orders are included. Test and deleted orders are not included.
Discounts	Equates to line-item discount + order level discount share for a collection of sales. The total dollar value reduction applied to a sale in the form of discounts on specific products or collections, or all products. Discounts that are applied to an all products in an order are proportionally applied to the sales for the order. All discounts are applied before taxes. Discounts are created using discount codes, not the compare at price.
Returns	The value of goods returned by a customer.
Net sales	Equates to gross sales - discounts - returns.
Shipping	Equates to shipping charges - shipping discounts - refunded shipping amounts.
Tax	The total amount of taxes based on the orders.
Total sales	Equates to gross sales - discounts - returns + taxes + shipping charges. Total sales will be a positive number for a sale on the date that an order was placed, and a negative number for a return on the date that an order was returned.

Sales over time

It shows the number of orders and the total sales that you've made over time. You can select a unit of time in the Group by drop-down menu to control how the data is grouped.

Sales by Product

The Sales by Product report shows the breakdown of total sales of your products, excluding shipping.

Shipping isn't included because an order can consist of several products but has a single shipping charge. For reporting purposes, the shipping charge can't be apportioned between the products in the order.

Because shipping amounts are filtered out, the tax that is shown in this report does not include taxes on shipping.

This report uses the following additional terms:

Term	Definition
Product vendor	The vendor of your product, if you purchase it from a third party.
Product type	The type of product you are selling. For example, hats, shirts, or shoes.
Product title	The name for your product.
Net quantity	Equates to number of sold items - number of returned items.

Sometimes the data in the product fields, such as Product type or Product title, is shown as a blank space. This occurs if the data didn't exist at the time of the order.

Similarly, if any of this data is changed between orders, then the report might show multiple rows for the same product because the identifying information is not exactly the same. The reports always show the original values from the time of the order.

Sales by product variant SKU

The Sales by product variant SKU report shows the breakdown of gross sales, but not the shipping cost, of your top-selling products on a more granular level than the Sales by product report.

Shipping isn't included because an order can consist of several products, but has a single shipping charge. For reporting purposes, the shipping charge can't be apportioned between the products in the order.

This report uses the following additional terms:

Term	Definition
Product title	The name for your product.
Variant title	The name of the product variant.
Variant SKU	The identification code of the product variant.
Net quantity	Equates to number of sold items - number of returned items.

Sales by Product Vendor

The Sales by product vendor report shows your vendors, and the products provided by each vendor.

Sales by Discount

The Sales by discount report shows your sales grouped by the name of the discount, such as the automatic discount name or discount code. This report helps you see how often your discount codes are applied and can help you see which discounts are converting into the most sales.

The following terms are used in this report:

Term	Definition
Name	The name entered when the discount was created in the admin.
Discount applied	The way that the discount is applied in the checkout, either automatically or by entering a code.
Discount type	Percentage, fixed amount, free shipping, or buy X get Y.
Discount code	The code that was applied to receive the discount.
Automatic discount title	Name of the discount that was automatically applied.
Orders	The number of orders to which the discount was applied.
Script discounts	The value of product discounts that are the result of a script that is run by the Script Editor app. This column is shown only if you use Shopify Plus. Script discount amounts are reported for an order only if a discount code was also used on the order.
Shipping	The shipping amount, not including shipping discounts.
Shipping script discounts	The value of shipping discounts that are the result of a script that is run by the Script Editor app. This column is shown only if you use Shopify Plus. Shipping script discount amounts are reported for an order only if a discount code was also used on the order.
Shipping discounts	The value of the shipping discount.

The discounts, not including script discounts, are based on the discount codes that you create on the Create discount code page.

The sales amounts in this report include the total order values, not just the discounted items in an order.

For example, a customer purchases a T-shirt for $20 and a hat for $10 in a single order. The customer uses a discount code that takes $5 off the price of the T-shirt only. Gross sales for that order is reported as $30 and net sales is reported as $25.

Sales by Billing Location

The Sales by billing location report shows you the country or region of the billing address for an order.

Sales by Checkout Currency

The Sales by checkout currency report shows you the breakdown of your sales by customer currency used at the checkout.

The Total sales column reports the value of the sales in your local currency.

For example, Sarah's local currency is Canadian dollars, but she accepts payments in Australian dollars and US dollars as well. In her Sales by checkout currency report, Sarah sees Canadian, Australian, and US dollars listed in the Checkout currency column, followed by the number of orders made in those currencies, and the value of those orders in Canadian dollars.

Sales by Channel

You can use the Sales by channel report to see the amount of sales for your various sales channels.

In this report, the Sales channel name shows the name of the channel or app that the customer used to place their order, such as Online Store or Buy Button. For sales that originated as draft orders, the report shows Draft Orders.

Sales by Customer Name

The Sales by customer name report shows you the breakdown of orders by customer over a period of time.