🤵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
Shipping
The shipping amount, not including shipping discounts.
Shipping script discounts
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