Assortment Plan
- Jaikirat Singh (Unlicensed)
- Ananta Chourey
export_ap_output headers' description-
Column | Description |
store | name of store |
store_code | unique code of store/POS |
channel | channel to which store belongs |
region | Region to which the store belongs |
store_class | Store grade or class assigned to store in store master |
store_cluster | group/ cluster mentioned for store in store master |
attribute_group | attribute group |
master_category | master category to which the ag belongs |
category | Category of the AG |
subcategory | Subcategory of the AG |
gender | Gender of the AG |
brand | Brand of the AG |
period | input period given in OD analysis |
brand_segment | Brand segment of the AG |
mrp_bucket | price bucket under which the AG |
theme | whether the AG is tagged as Core/ Bestseller/ Fashion (NOOS) |
attribute1 | Secondary attribute as per style master |
attribute2 | Secondary attribute as per style master |
attribute3 | Secondary attribute as per style master |
attribute4 | Secondary attribute as per style master |
attribute5 | Secondary attribute as per style master |
style_id | If the ag is NOOS, then style code will be printed, as NOOS AG consists of a single style |
optimum_options | not relevant(0) |
size_sets | sizes present in the AG, derived from ISS |
size_ratio | ratio of all the sizes in the AG based on their rev contri calculated in ISS |
revenue_contribution | period wise rev. contribution at store- AG level, derived from OD |
ap_options | actual options derived using AP stocks/ size set, and normalized using planogram |
ap_stocks | actual quantity per store- AG calculated basis readjustments and normalized using planogram |