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.
Region Warehouse Map: Contains the list of different Warehouses with the assigned IDs
| Column | Description |
|---|---|
| NAME | Name of the warehouse to be used for reporting purposes |
| WAREHOUSE_ID | 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 level style status (FRESH, OLD and RESERVED) along with the reserve percentage
| Column | Description |
|---|---|
| RESERVE_PERCENT | Percentage of inventory that should be reserved for a fresh style |
| RUN_DATE | Product run date for which the entries are populated |
| STATUS | Denotes if a Style is Fresh/Old/Reserve. Styles with status as ‘Reserve’ will be reverted by IRIS to ‘Fresh’ if the style is not visible in GIT, Open orders on the run date or in-store inventory between run date and last updated date of the style Styles with status as ‘Reserve’ will be converted to ‘Old’ if the last updated date against the style is more than 45 days from the run date. This is done so that the reserve quantity is not blocked for longer duration and if there are no replenishments happening in this style because it is a bad seller, it can be sent to other stores |
SKU Fulfillment Qty: Actual Qty fulfilled for the replenishment of every channel from the warehouse.
| Column | Description |
|---|---|
| QUANTITY | Replenishment quantity actually dispatched from the warehouse. It will be compared against the replenishment quantity suggested by IRIS to adjust the reserve pool accordingly. If IRIS suggested replenishment of 3 units in Style 1, Size S to Store 1 from warehouse id 1, but the warehouse disptached only 2 units, then the leftout 1 quantity will be added back to the replenishment pool. |