Reordering: Reorder Store Group Output
- Siddharth Jain (Unlicensed)
- Raj Nadkarni
COLUMN HEADER | EXPLANATION |
period | The input period defined for analysis of historical data |
store_group | Name of the store group which for which we are reordering |
channel | The channel to which we are suggesting reorder, ie. stores belonging to that channel from mentioned store group |
ean | Barcode or European article number |
size | Size of the product/ean |
style | Style to which the ean belongs |
style_description | Brief description of the styles |
master_category | Overall master category to which this style belongs to |
category | Category of the article. A category can only be associated to a single Master category |
subcategory | subcat to which the article belongs |
brand | brand to which the article belongs |
brand_segment | brand segment to which the article belongs |
gender | gender for which the article is made for |
season | season to which the article belongs |
price_bucket | A price bucket is a range or category of prices that products or services are grouped into for pricing and marketing purposes |
target_cover | The No. of days for which would like to maintain qty in this given ean for |
opening_store_inv | Store inventory at the time of starting the algo run |
sales_in_lead_time | Estimated sales in the Given Lead time |
store_group_style_ros | Combined Average ROS of the stores belonging to the given store group for a particular style |
store_group_sku_ros | Combined Average ROS of the stores belonging to the given store group for a particular ean |
iss_contri | The contribution of that size to the ideal size set of the style at store group level. |
ros_flag_at_store_group | defined at which level the ROS for the store group was resolved and calculated. |
reorder_style_theme | Suggestion if an ean should or should not be reordered, and its priority. |
target_sales | Predicted sales for the ean in the given cover days period considering store group ROS |
closing_store_stock | Projected store stock at the end of Lead time |
period_duration | The lead time defined |
store_spread | The Target store spread defined for that channel+style combination |
live_stores | The No. of stores at which the style is currently live at |
closing_date | Date which mark the end of the lead time |
cover_end_date | Date which marks the end of the cover defined |