Exclusion List:
Specifies the store + style combinations that should not be allocated/replenished. Store name can be left blank if a Style needs to be excluded from all the Stores or a channel name can be mentioned against the style to exclude it from all stores belonging to that channel. This list needs to be changed every time there is a change in the season. This list needs to be given at the parent-style level. If either a parent/child style is present in the exclusion list, the entire family of styles will be part of the exclusion.
| Column | Description |
|---|---|
| STORE_CODE | Store's code in store master |
| CHANNEL | Store's channel in store master |
| STYLE_CODE | Style's code in style master |
Store List:
Activate or deactivate stores to be considered for a particular run.
| Column | Description |
|---|---|
| CHANNEL | Store's channel in store master |
| STORE_CODE | Store's code in store master |
| IST_GROUP | IST group name to which this store belongs. The IST will only be suggested between other stores within this IST group |
| DIST_ENABLED | Indicates if the store is enabled for IST or not. 1 is enabled and 0 is disabled |
| INWARD_FLAG | Indicates if stock can be inwarded to this store or not. 1 is enabled and 0 is disabled |
| OUTWARD_FLAG | Indicates if stock can be outwarded from this store or not. 1 is enabled and 0 is disabled |
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:
The store + style combinations inputs relevant should be given preference over any other style to fill the gap at a store.
In case there are multiple styles for a single store in this list, the system decides the priority using its algorithm. This list needs to be given at the parent-style level. If either a parent/child style is present in the inclusion list, the entire family of styles will be part of the inclusion.
| Column | Description |
|---|---|
| STORE_CODE | Store's code in store master |
| CHANNEL | Store's channel in store master |
| STYLE_CODE | Style's code in style master |
Warehouse Planogram:
Warehouse capacity - the total quantity that the warehouse can hold at a given point of time at a category level. The same can be set as target cover days of inventory in the replenishment cycle days column
| Column | Description |
|---|---|
| Warehouse | Auto-Fill in Template Warehouse codes updated in the warehouse master |
| Category | Auto-Fill in Template as per the enabled categories |
| Quantity | Warehouse capacity at Category level |
| Replenishment Days | Target days |
Warehouse Store Category Mapping:
Defines the relevant warehouses from which stock can be sent along with the priority of these warehouses. Input is defined at a Store+ Category combination.
| Column | Description |
|---|---|
| Channel | Auto Fill-in Template (As per the enabled store list) |
| store_code | Auto Fill-in Template (As per the enabled store list) |
| category | Auto Fill-in Template (As per the enabled category list) |
| 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 |
JIT Style Depth Override: