Get a breakdown on item sales sorted by product tags
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.
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:
Expand this list of answers you may get on your sales by using additional data columns and data filters.
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.
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:
Utilize these data segments to look at the current financial and inventory situations for each product tag inside the chosen range of dates.
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.
In conjunction with the variant sales, a store manager can often use such summaries as:
A store manager can also use less similar reports to get an additional view on sales. This can be done with such summaries as:
The default table with the data on sales by product tag consists of such columns as:
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] = [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] = [ORDER ITEMS Gross Sales] - [ORDERS Discounts] – [REFUNDS Returns]
[ORDERS Shipping] = [ORDERS Shipping amount] - [ORDER ADJUSTMENTS Total Shipping Amount]
[ORDERS Total Sales] = [ORDERS Net Sales] + [ORDERS Shipping] + [ORDERS Tax]
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.
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.
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.
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.
The total cost of ordered items in the order is calculated as:
[ORDER ITEMS Total Cost] = [ORDER ITEMS Quantity] × [INVENTORY ITEMS Cost]
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.
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 full access to platform within a 7-day free trial.