Retail sales reports

You can use the retail sales reports to see information about your customers' point of sale orders based on criteria such as product, SKU, or staff.

The reports show only sales that were made at a POS location. Other sales are excluded from the reports.

When you open a retail sales report, the data is up to date, give or take about 1 minute. You can reopen or refresh the report to show newer data.

View your retail sales reports

For information about the terms that are used in the retail sales reports, see Sales reports.

Steps:

  1. In the Retail sales section, click Show all.

  2. Click the retail sales report that you want to see.

Detailed retail sales reports

If your store is on the Shopify plan or higher, then you have access to the following retail sales reports:

Retail sales by product

The Retail 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.

Retail sales by product report

The sales reports use several common terms. This report uses the following additional terms:

Additional terms for the retail sales by product report
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 dash (—). 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.

Retail sales by product variant SKU

The Retail 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 Retail sales by product report:

Retail sales by product variant SKU 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.

The sales reports use several common terms. This report uses the following additional terms:

Additional terms for retail sales by product variant SKU report
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.

Retail sales by product vendor

The Retail sales by product vendor report shows your vendors, and the products provided by each vendor, grouped by point of sale location:

Retail sales by product vendor report

The sales reports use several common terms. This report uses the following additional terms:

Additional terms for the retail sales by product vendor report
Product vendor The name of the vendor providing a product. Click the name of a vendor to see the list of products that the vendor supplies.
Net quantity Equates to number of sold items - number of returned items.

Retail sales by product type

The Retail sales by product type report shows your retail sales by product type, grouped by point of sale location:

Retail sales by product type

Retail sales by Point of Sale location

The Retail sales by Point of Sale location report shows the total sales for each point of sale location:

Retail sales by Point of Sale location report

The sales reports use several common terms. This report uses the following additional terms:

Additional terms for the retail sales by product type report
Product type The type of product you are selling. For example, hats, shirts, or shoes.
Net quantity Equates to number of sold items - number of returned items.
POS location name The name of the point of sale location where the sale was made.

Retail sales by staff at register

The Retail sales by staff report shows you the sales made by each staff member:

Retail sales by staff report

The sales reports use several common terms. This report uses the following additional terms:

Additional terms for the retail sales by staff at register report
Staff name The name of the staff member who processed the sale.
POS location name The name of the point of sale location where the sale was made.
Percent of sales with staff help The percentage of sales that had at least one staff member assigned to line items.

Retail sales by staff at register (daily)

The Retail sales by staff (daily) report shows you the daily sales made by each staff member:

Retail sales by staff (daily) report

The sales reports use several common terms. This report uses the following additional terms:

Additional terms for the retail sales by staff at register daily report
Day The day that the orders were placed.
Staff name The name of the staff member who processed the sale.
POS location name The name of the point of sale location where the sale was made.
Percent of sales with staff help The percentage of sales that had at least one staff member assigned to line items.

Retail sales by staff who helped with sale

The Retail sales by staff who helped with sale report shows your sales by staff members who were attributed to line items at checkout:

Retail sales by staff who helped with sale

The sales reports use several common terms. This report uses the following additional terms:

Definition of retail sales by staff who helped with sale terms
Staff who helped with sale The name of the staff member who had a line item assigned to them.
POS location name The name of the point of sale location where the sale was made.

Ready to start selling with Shopify?

Try it free