Please Note: This article pertains to Retail Analytics dashboard functionality in the Latest Version of Treez.
The Product Sales and Inventory Report is designed to help retailers see product lines that are moving the fastest, examine a snapshot of their inventory within a flexible date range, and get direct access to the data in table format.
This report is suitable for managers wanting to take a more holistic view of their inventory, throughout time, at the store-level, brand-level, product-level, and product-type-level. The tabular data behind these visuals also enable users to obtain the data and perform any ad hoc analysis on their own.
Custom date picker for your inventory data
Historical SKU performance
PERIOD over PERIOD comparison on brand level and product level
Flat table that can be filtered
Downloadable
Product Sales and Inventory Report Overview
When filtering on Show all Days, the dashboard will show how many units your organization had in stock on all days, including the days without any sales.
When filtering on Days with Sales, the dashboard will update to show the units in stock for the selected products during days you sold these products.
Log into the Latest Version of Treez and navigate to Dashboard > RA> Products & Inventory > Product Sales & Inventory Reports Dashboard
Use the control panel to zone in onto specific brand, type, subtype, product name and see its sales and inventory flat table.
The Day View filter allows you to see a snapshot of your units in stock on any given day.
Product Sales & Inventory by Sales by Day Overview
This section summarizes key inventory and sales performance metrics:
Units Sold: total product units sold.
Sellable Velocity: quantity of units sold in the number of days the units were in a sellable location (aka not in the vault, or quarantine, etc.) during the selected period of time.
Gross Sales: The total value of all sales before discounts and returns.
Discounts: Total value of discounts applied during the sales period.
Returns: Total gross receipt values of returned products.
Net Sales: Gross sales minus returns and discounts.
COGS: Cost of goods sold.
Totals By Store provides an aggregated view of sales and inventory data for each location. Utilize filters to analyze sales performance by product, brand, or category, allowing you to identify top-selling items at specific stores.
Totals by Brand offers a view of sales and inventory data by brand.
Totals by Product offers a view of sales and inventory data by product name.
Totals By Product Type offers a view of sales and inventory data by category.
Protip 💡
Use the 'View By' toggles to see filters for Brands across all stores or across each store individually. Select the Column Headers to sort the columns.
Totals By Day presents an aggregated view of sales and inventory data for each location within the selected date range from the Product Sales and Inventory Report Overview filters. Use the Date Granularity filter to adjust the data view by day, week, month, or quarter based on your needs.
For detailed metric definitions, visit the Retail Analytics Glossary.