The Sales by Retailer and Silhouette Report provides insight into sales volume by retailer and style silhouette. It includes key metrics such as SKU count, units, sales volume, and percentage calculations. This report is useful for appointments with specific retailers or for analyzing top-selling groups by silhouette.
How to Run the Sales by Retailer and Silhouette Report
- To access the Classic Order Reports, please log into your JOOR account and hover over Reports.
- Then, click on Classic Order Reports.
- On the ORDER REPORTS page, click on the Sales by Retailer and Silhouette option.
- To access the report, click Run Report.
- The resulting report will include a summary of the report in the top right corner, showing a sum of total sales per currency as well as a breakdown of sales for each silhouette and the percent of total. The report will display the retailer information, SKU and unit counts, % total calculations and total sales. The report scrolls left to right to include as many useful columns as possible.
- To refine your report further, please utilize the Additional Filters (Silhouette Name) and/or click on the Filter button below each column name. To sort results by information in a specific column, please click on the arrows to the right of the column name.
Exporting the Report
- To export the report to Excel, click on the "Export" button.
- When exported, the report will appear as a workbook with three tabs: Report Summary, Data Summary, and Worksheet.
Report Summary
This tab will display the filters that have been set for the report, along with the same summary section for the report as is available on the web.
Data Summary
This sheet will aggregate the total sales volume by retailer and silhouette. The gold-highlighted rows will include the total number of SKUs and units ordered, as well as the total sales volume for each account.
Worksheet
This is the raw data from the report. As you will see, this tab provides a detailed breakdown of the report information by Style Number. This tab can be used to create additional reports and pivot tables as needed.