Exclusion List: Specifies the Store+Style combinations which should not be allocated/replenished. Store name can be left blank if a Style needs to be excluded from all the Stores.
Warehouse Master: Contains the list of different Warehouses with the assigned IDs
| Column | Description |
|---|---|
| WAREHOUSE | ID assigned to each warehouse. The same needs to be used in Warehouse Stock and Store Category warehouse mapping |
| ONLINE_FULFILLMENT_FLAG | Indicates whether the warehouse’s inventory is used for Online channels as well For all the warehouses where this value is 1, the qty required for Online based on ROS will be excluded from the available Stock of every SKU |
Inclusion List: Specifies the Store+Style combinations which should be given the first preference as a Brand call before sending in other combinations
Warehouse Store Category Map: Defines the list of relevant warehouses from which Stock can be sent to every Store+ Category combination and the priority
| Column | Description |
|---|---|
| WAREHOUSES | For every Store and Category combination, this column specifies the relevant warehouses from which Stock can be distributed. Each warehouse id needs to be separated by # in case of multiple warehouses |
Style Freshness Status: Defines the Channel+ Style level Percentage of Warehouse Stock to be saved for future replenishments
| Column | Description |
|---|---|
| RESERVE_PERCENTAGE | Percentage of Warehouse inventory that should be reserved for a fresh style |
Max Allowed SKU depth: Defines the Maximum allowed quantity in Pivotal and Non-pivotal SKUs for every Store+ Category+ Sub Category combinations
Style Level Merchandise Tagging: This input is used to override the existing season of a style for a given channel. Relevant in the cases where the Brand wants to allocate only a subset of the styles for a particular Channel
Story Style List: List of Stories/collections with the corresponding list of styles for every story/collection
Store Category Min Options: Minimum number of options required in each category for every store within a story/collection. The distribution will happen only if there are enough healthy options in both store and warehouse together in a particular category + story/collection
Store Category combination priority: The combination of categories that are allowed to be dispatched to a store in a story/theme/collection in case all the categories of the story/collection are not available. The priority defined here does not play any role in the order in which the combinations are dispatched