Shopify Sales by Collection Report

Why Sales by Collection report is important

The summary of product collections in the store shows the breakdown of sales and revenue for items that belong to specific groups – collections.

It is another way to look at sales in a store besides direct sales by product or sales by variant reports.

Shopify out of the box does not provide a summary report by collections.

However, it can be generated with the help of a third-party reporting app, like Mipler Advanced Reports, which provides more than 60 different reports.

The default configuration of this report brings data on general sales of products grouped by collection.

The reports usually include columns such as the number of orders, net quantity, gross sales, discounts, refunds, taxes, and net sales.

Filters can be used to make the data more representative of the store manager's needs. For example, you can see product collections by their name or sort them by the number of orders. Such information can be useful for inventory planning and marketing purposes.

What questions report Sales by Collection can answer

Start from this report if you need to split up the sales in your store through collections.

The data displayed in that report can be used to answer questions such as:

• What number of orders each product collection generated for the specified period of time.
• What are the top-selling and worst-selling product categories in your store.
• What are the key sales indicators (gross, net sales) for each product collection
• Which collections had the highest and lowest average order values?
• Products from what collections are most often requested for refund, i.e. return rate per collection.
• Products from what collections are purchased with the highest number of discounts
• What product categories have the highest sales for customers of a specific region.
• What is the customer lifetime value (CLV) for each product collection.

Note that you can easily expand the list of answers by using additional data columns or filters.

Default Sales by Collection Report

Key sales indicators in a report

Split the sales data by categories using the Advanced Reports app and be informed on key sales metrics. Expand this summary with additional columns to get a detailed view.

For example, you can see the available inventory per each collection, see sales velocity per collection to avoid the out-of-stock situation. Additionally, get info on the date of the last order in each collection.

Track the number of orders, gross and net sales, total quantity within the specified time range. For each product category, this summary output displays such data as:

• Number of orders
• Taxes
• Discounts
• Refunds
• Gross, Net sales

Use these columns to glance at the current financial and fulfillment statuses for each order within the selected dates and compare with other periods.

Reports similar to Sales by Collection

The store data on sales can be tracked from multiple scopes to offer the best data representation.

When the store manager generates this report, the app does not limit them to modify the summary by the date. The store manager can obtain the summary based on other data factors pulled from the store database.

In conjunction with the variant sales, a store manager can often use such summaries as:

• Sales by product. Displays the information on purchases for each product name or SKU.
• Sales by Product Type. Contains basic indicators such as Net Amount, Number of Orders, etc. It will help you find out what type of product sells best.
• Sales by Vendor. Contains basic indicators on sales such as Net Amount, Number of Orders, etc. Use this summary to find out the brand that has the best sales.
• Sales by Vendor > Product > Variant. Similar to the Sales by Vendor report, but more detailed. The report is sorted by vendor, product, and variant.

Key columns for sales by collection

Typically, the table with the data on the collection’s sales consists of such columns as:

• ^Collections Name
• ^Orders Number of orders
• ^{Order Items} Net Quantity
• ^{Order Items} Gross Sales
• ^{Order Items} Discounts
• ^{Refund Items} Returns
• ^{Order Items} Tax
• ^{Order Items} Shipping
• ^{Order Items} Total Sales

A store manager has full control over the summary being generated. They are totally free to exclude any of the existing columns or add more. Simply choose the available columns from the list.

Here is how some of the key columns in the default report are calculated:

• ^{Order Items} Net Quantity - this column is calculated through the total quantities of ordered and refunded items.

  Order Items Net Quantity = Order Items Total Quantity - Refund Items Total Quantity

• ^{Order Items} Gross Sales - the final column of the default report is calculated through the variant’s price and quantity.

  Order Items Gross Sales = Product Variants Price × Order Items Quantity

  In case the tax is included, the Gross Sales formula will look like the following:

  Order Items Gross Sales = Product Variants Price × Order Items Quantity – Order Items Tax Amount

• ^{Order Items} Shipping - displays the shipping cost that is calculated as:

  Order Items Shipping = Order Items Shipping Price ÷ Order Facts Quantity – Order Items Quantity

• ^{Order Items} Total Sales - the total sales data per product collection is calculated as:

  Order Items Shipping = Order Items Net Sales + Order Items Tax + Order Items Shipping Price

Variations of Sales by Collection report

A store manager can get another view on sales besides grouping sales by product collections. Using variations of the default report, they can obtain a clearer insight into the business performance of the online store.

One of the easiest ways to glance at business success is to compare a specific date range to a previous period.

Using filters and sorting options, you can get answers to some other questions regarding sales. Here are some examples of the report variations.

How to see sales by location

Easily see the sales data for each product collection with the data on customers' geographical distribution.

See what provinces, cities, and countries you have the most or least purchases for each product category.

[ORDERS Gross Margin, %] = ([ORDERS Net Sales] - [ORDERS COGS]) ÷ [ORDERS Net Sales] × 100

[ORDER ITEMS Total Cost] = [ORDER ITEMS Quantity] × [INVENTORY ITEMS Cost] 

[ORDERS Total Sales] = [ORDERS Net Sales] + [ORDERS Shipping] + [ORDERS Tax]

[ORDERS Net Sales] = [ORDERS Gross Amount] - [ORDERS Discounts] - [REFUNDS Returns]

[ORDERS Shipping] = [ORDERS Shipping amount] - [ORDER ADJUSTMENTS Total Shipping Amount]

[ORDERS Tax] = [ORDERS Taxes] – [REFUND ITEMS Total Tax Amount]