Sales by Product Tag Report

Get a breakdown on item sales sorted by product tags

Table of Contents

Why sales by product tag report is important

shopify sales by product tag

This summary shows the product sales data grouped by the product tags. Such a document can be considered an exceptionally powerful instrument for sales administration tasks of store supervisors.

They can utilize it to comprehend better deals, changes, and patterns that happened during a specific time range.

When generating such a document, a reporting tool shows the breakdown of key monetary measurements for items tags currently used in a store.

This factual information can be examined straight by the provided numbers or can be changed into strong diagrams for simple spotting of possible sales patterns.

The usefulness of this reporting apparatus allows you to see the movement of your store's key financial markers by contrasting current data with previous time spans.

Utilizing this report's default setup, a senior store supervisor can get information on the financial statistics of deals grouped by product tags. The data is presented in segments such as the number of orders, net quantity, gross, net, and total sales.

With the assistance of built-in filtering capabilities, the information shown on the screen can be made more representative of the requirements of a specific task. For instance, a senior supervisor can see item variation, item name, or SKUs in addition to the item tag. Such data can be helpful for stock preparation and advertising purposes.

What questions can be answered when looking at sales by product tag

This type of summary outline pulls the information on deals items grouped in a helpful rundown configuration based on product tags. This can be a beginning stage to get an overview of the level of orders carried out in the store.

The summary can be utilized as a piece of in-store standard business practice for further developing product decisions and monitoring the sales trends. The information gives a store supervisor a convenient tool to notice significant patterns in orders.

The data displayed in this summary can be used to answer such questions as:

shopify sales by product tag
  • what is the number of orders for each product tag within the specified time period
  • what is the quantity of items sold of each product tag within the given time range
  • how to see the sales data on exact products, product variants and SKUs for each product tag
  • what are the key sales indicators (gross, net sales) for each product tag
  • how many refunds each product tag has
  • what product tags do customers prefer to purchase using discount codes
  • what discount codes and their marketing campaigns bring the most sales for each product tag
  • what is the average discount value for every product tag sold in a store

Expand this list of answers you may get on your sales by using additional data columns and data filters.

Key sales indicators in a report

Utilize the provided information on deals given by the Advanced Reports application to be educated on key deals measurements. Make it more illustrative with different sections to get a customized close view. For instance, expand the report with the data segments for item variations and SKU.

shopify sales by product tag

Track the number of orders and things purchased, gross and net deals inside the picked time span. Get a sales overview output for product types by having such data as:

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

Utilize these data segments to look at the current financial and inventory situations for each product tag inside the chosen range of dates.

Reports similar to Sales by Product Tag

If you look at the deals information differently, you can see multiple trends in deals and stock patterns. The rundown by product tags can be more useful when a store supervisor modifies time spans and contrasts information between several time periods.

This instrument permits creating a sales by product tag report with a bigger number of configured options than basically changing time spans for data analysis. Generate the summary of sales based on other factors available in the store database.

shopify sales by product tag

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

  • Sales by Order Tags. See the financial summary for groups of products in your store. Get sales data based on orders grouped by the tags you attached.
  • Sales by Customer Tag. Tracking customers by tags lets you know where they came from into your store, what group they belong to, what types of purchases customers with specific tags make, etc.

A store manager can also use less similar reports to get an additional view on sales. This can be done with such summaries as:

  • Sales by Variant. See both the variants that are selling the best and those that are not selling at all. Keep your inventory according to the variant sales.
  • Sales by Collection. Get a detailed breakdown on sales split by product collection. It is another way to look at sales in a store beside the direct sales by product or sales by variant reports.
  • 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 product tag

The default table with the data on sales by product tag consists of such columns as:

shopify sales by product tag
  • PRODUCTS Tage
  • ORDERS Number of orders
  • ORDER ITEMS Net Quantity
  • ORDER ITEMS Gross Sales
  • ORDER ITEMS Discounts
  • REFUND ITEMS Returns
  • ORDER ITEMS Net Sales
  • ORDER ITEMS Tax
  • ORDERS Shipping
  • ORDER ITEMS Total Sales

The chief administrator can reject any of the currently included data segments from the report and add a few extra ones for more clarity of the report. Pick accessible data sections from the rundown list.

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

  • ORDER ITEMS Gross Sales. The final column of the default report is calculated through price and quantity.
  • [ORDER ITEMS Gross Sales] = [PRODUCT VARIANTS Price] × [ORDER ITEMS Quantity]

    If taxes are included, then the formula for Gross Sales transforms to:

    [ORDER ITEMS Gross Sales] = [PRODUCT VARIANTS Price] × [ORDER ITEMS Quantity] – [ORDER ITEMS Tax]

  • ORDER ITEMS Net Sales. The net sales column of the default report is calculated through gross sales, discounts, and refunds.
  • [ORDER ITEMS Net Sales] = [ORDER ITEMS Gross Sales] - [ORDERS Discounts] – [REFUNDS Returns]

  • ORDERS Shipping. The shipping fees are obtained from the total shipping price and amount.
  • [ORDERS Shipping] = [ORDERS Shipping amount] - [ORDER ADJUSTMENTS Total Shipping Amount]

  • ORDER ITEMS Total Sales. Get the sum of total sales calculated as:
  • [ORDERS Total Sales] = [ORDERS Net Sales] + [ORDERS Shipping] + [ORDERS Tax]

Variations of Sales by Product Tag report

You can get one more view on deals adjacent to the sales by product tag report. By utilizing variations of the default report, a store master can acquire a clearer understanding on the shop's business status.

One of the least demanding methods for getting another look at the store's business achievements is contrasting a particular date range with a past period.

Utilizing filtering channels and sorting choices, executive store managers can find solutions to some other inquiries regarding sales that they may have. Here are a few instances of the report variations.

How to see sales by location

shopify sales by product type

You can undoubtedly see the deals information grouped by product tag alongside the data on the topographical location of shoppers.

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

How to see customer’s lifetime value

It is well known that existing customers cost less than attracting new ones for a store. Depending on the purchases each customer makes he sets his individual value for a store.

You can easily see the customer lifetime value with the CUSTOMERS CLV data column. Use it to monitor for signs of shoppers' attrition in your store.

How to see gross margin in percent

Gross margin is one of the parameters for the business performance, which shows how much financial funds the store retains. The higher this indicator is, the more capital is available to pay for other costs.

See the gross margin in percent by activating a corresponding column.

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

The result is rounded to two numbers after the comma sign. If the calculation result is negative, the report shows zero value in a table.

How to see the total cost of ordered items

The total cost of ordered items in the order is calculated as:

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

How to see what type of customer made the order

A store can have both new and recurring customers, the latter being preferable. Merchants can easily see what types of customers buy in their stores within the ORDERS Customer Type column.

In case the date of customer’s first order is equal to the order processing date, then the customer is considered a first-time buyer. Otherwise, they are assigned to a Returning type. If the report cannot detect the customer ID, it will display the Unknown value.

How to get total sales for orders

Get the sum of total sales calculated as:

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

The ORDERS Net Sales are obtained as:

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

The ORDERS Shipping is obtained as:

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

The ORDERS Shipping is obtained as:

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

Get rid of boring, tedious tasks.

Get full access to platform within a 7-day free trial.

Book a Demo
© 2023 Mipler. All rights reserved.