Store Targets:
Store level Revenue targets for every month. Used in reporting to compare the targets with actual achievement.
Category Key Sizes:
Specifies the required sizes in the Stock for a Style to be considered “Healthy”.
| Column | Description |
|---|---|
| SIZE_SET_1 | If a Store+ Style has all the sizes mentioned either in size_set_1 or size_set_2 for that category, it will be considered healthy. Used only for reporting purposes |
For Example, if the input is given as S,M,L and M,L, XL for a category, all the store style combinations in that Category having at least S,M,L or M,L,XL will be counted under healthy combinations.
Retail Calendar:
Defines the Retail week number to which days belong.
| Column | Description |
|---|---|
| RETAIL_WEEK | Week numbers to be used for reporting. Year on Year comparison for the same week number will be according to these numbers |
| SEASON | Season to which the week belongs. Has to be one of the seasons present in the Style master |
| EVENT | If the Retail week belongs to any event period (For Eg., Black Friday Sale), it can be mentioned here |
Returns:
- All SKUs should be in SKU master
- All store IDs should be present in Store Master
- Revenue can not exceed (MPP*QTY Sold) and can not be 0 or negative.
- Date should be in ‘yyyy-mm-dd’ format