Release 30

Summary

Additional columns in Sell Through Reports
New Sell Through report at Attribute level
New Input files in BI module
- Style attribute input for Attribute Sell Through Report
- Separate Store Stock input for BI Module
- Separate Warehouse Stock input for BI Module
Top Seller report at Company level

Following reports have been augmented with additional columns

Sell Through & DOH Excluding Warehouse
Store Style Level Sell Through (Downloadable report)
- Image URL
- Revenue
- MRP Sales
- MRP SOH : ( Sum(Style MRP * Store Stock) )
Store Category Level Sell Through (Downloadable report)
- Revenue
- MRP Sales
- MRP SOH
Partner Category Level Sell Through (Downloadable report)
- Revenue
- Stores Exposed
- MRP Sales
- MRP SOH
Sell Through & DOH Including Warehouse
Style Level Sell Through with Warehouse
- Image URL
- Revenue
- Stores Exposed
- MRP Sales
- MRP SOH
Brand Category Level Sell Through with Warehouse
- Revenue
- Stores Exposed
- MRP Sales
- MRP SOH

New Sell Through report has been added in the BI module. It can be viewed both in UI and can be downloaded. It can be accessed as follows

Merchandising Drop Down in the Navbar > BI Dashboard > Reports > Sell Through & DOH (via report drop down menu) > Attribute Level (via Subreport Menu).
User has to select the attribute level from the dropdown filter to generate the report. The downloadable report consumes the filters as well.
The report provides following details at Partner, Brand, Category, Gender and selected Attribute level.
Storestock
Sales
Sell Through
Number of Styles
Store Mix : ( (StoreStock of the corresponding level + Sales of the corresponding level) / (Total Store Stock + Total Sales during selected period) )
Sales Mix (Sales for the given level / Total Sales during selected period)

UI Snippet:

Download report snippet:

Following input files have been added to BI Module. The file can be uploaded via the Inputs section in BI Dashboard section of Merchandising.

Style Attributes : Style attribute will be consumed by the Sell Through For Attributes report explained above. It has following headers

Store Stock : The store stock file is now separated for BI. Earlier, the BI module used to consume store stock files uploaded in the Distribution section. This file data will be used to generate Sell Through & DOH reports.

Warehouse Stock : The warehouse stock file has also been separated from BI. Now BI will consume the new upload instead of Distribution warehouse stock. This file data also will be used to generate Sell Through & DOH reports (including warehouse).

Previously, top sellers were computed at just two levels, Partner + Brand + Category level (Partner Category level Top Sellers) and Partner + Brand level (Partner level).
In addition to these two reports, two new reports have been added in the Top Seller Module that displays the top-selling styles at a Brand + Category level (Company level Category-wise Top Sellers) and Brand level (Company level Overall Top Sellers). This can help in analyzing styles at a company level rather than just at partner level.