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