Previously, Orderry had only one assortment analysis report that provided insights into products. But our users made it clear that analyzing products alone wasn’t enough. That’s why we’re introducing a brand-new Provided Services report, along with an improved version of the former assortment report, now called Sold Products. Both reports are available from the Startup plan.
Let’s take a closer look at what information these reports provide and how you can use them.
How Can Assortment Analysis Reports Help You
First of all, note that the Sold Products and Provided Services reports only use data from sales and from orders in the Ready and Closed status groups. This ensures you’re analyzing actual sales, not potential ones.
Depending on the filters you apply, these reports let you analyze:
Demand and profitability by products, services, and categories – discover insights such as which items deserve special attention and promotion, or where pricing may need to be adjusted.
Employee performance – see who sells the most products and services, who gives the largest discounts, who handles high-value items effectively, and who may need improvement.
Revenue and margin by location – identify which branches are performing best and where you may need to optimize your team and assortment.
You can also export and print both reports.
How the Assortment Analysis Reports Work
As mentioned, you can analyze data from different perspectives depending on the filters you choose. Here’s what you can filter by:
Period – the standard filter for all Orderry reports.
Document type – orders, sales, or both.
Location – view data across all or selected locations.
Category – focus on specific product/service categories or employees.
Employee – analyze results by individual employees or by the products/services they handle.
Group by – choose to group by products/services, employees, or categories depending on what you want to analyze.
Once filters are applied, the report shows:
The name of the item, category, or employee depending on your grouping.
The number of sales per item/category/employee within the selected period.
Price – average per unit of product/service and total.
Discount – the total discount amount given.
Cost – average per unit of product/service and total.
Gross profit – calculated as (Total Price) – (Discount) – (Total Cost).
Markup (%) – the average markup at which products and services were sold during the selected period, calculated as (Gross Profit / Total Cost) × 100, if Total Cost > 0.
Margin (%) – the average margin for the selected period, calculated as (Gross Profit / Total Price) × 100, if Total Price > 0.
For example, you can group the report by services and then narrow it down to a specific employee to see which services they provided most often and how much revenue they generated. Or, if you group the report by employees, you can apply an additional filter by category to find out who works most effectively with a certain type of product or service.
And if needed, you can export the data to use in other reporting.
If you have any questions, suggestions, or feedback about this update, please contact us in the Support Chat.