Weekly Sales Depletion
- Jaikirat Singh (Unlicensed)
- Saroj Nayak (Unlicensed)
Column Name | Explanation |
|---|---|
start_day | Start date of the week |
end_day | End date of the Week |
channel | Channel to which the store belongs as per the store master |
store_code | store_code provided in the store master |
store | store name corresponding to the store_code |
style | style_code from style master |
season | season corresponding to the style_code provided in style master |
brand | brand corresponding to the style_code provided in style master |
master_category | master_category corresponding to the style_code provided in style master |
category | category corresponding to the style_code provided in style master |
subcategory | Subcategory corresponding to the style_code provided in style master |
gender | Gender corresponding to the style_code provided in style master |
price_bucket | Price Bucket corresponding to the style_code provided in style master |
attribute 1 | Attribute 1 corresponding to the style_code provided in style master |
attribute 2 | Attribute 2 corresponding to the style_code provided in style master |
ros | rolled up rate of sales of Store+Style Combination |
opening_inventory | Inventory of Story+Style on the opening inventory of starting day of the week mentioned in the first column. |
closing_inventory | Inventory of Story+Style on the Closing inventory of end date of the week mentioned in the 2nd column. |
warehouse_dispatch | Dispatch from Warehouse to the store during the week. |
remaining_warehouse_stock | Remaining WH Stock at the end of each week. |
warehouse_inwards | Inwards at the SKU Level to the Warehouse happened during the week mentioned in the start and end date which can be used for the dispatch of current week. Values are taken from the Store Inwards Input file. |
store_inwards | Inwards at the Store+SKU Level happened during the week mentioned in the start and end date. Values are taken from the Store Inwards Input file. |
sales | Sales at a store+sku level happened during the week mentioned in the start and end date. |
pre_depletion_health | Health of the style at the start of week mentioned in the first column of the output |
post_depletion_health | Health of the style at the end of week mentioned in the 2nd column of the output |
online_reservation_required |
|
online_reservation_achieved |
|