Sales
You can use sales reports to see information about your customers' orders based on criteria such as sales over time, by product, or by channel.
Sales reports track the value of products moving between you and your customers as you make sales and process returns.
A sale is made when a customer places an order. The reports include every line item and shipping charge (if applicable) in order as a separate sale item.
The sales reports include sales and returns from open, archived, cancelled, and pending orders, as well as draft orders that have been converted into orders. It does 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
The only orders not included in sales reports are deleted orders and test orders that were placed while Shopify Payments was in test mode.
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 |
|
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, but does not include 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.
Last updated