Open To Buy Help Section
- Alaf Azam Khan
- Govind kumar
- Abhist Srivastava
- Surya M
Minimum Display Options:
Minimum options to be displayed at Store + Category level. If the specified % of the defined options is not met by the width suggested in OTB (Buy plan), the category will be exited from the Store.
column | Explanation | Remarks |
|---|---|---|
channel | channel |
|
store_code | store_code |
|
category | category |
|
options | no of options for each Store-Cat |
|
Minimum Order Quantity:
The minimum order quantity benchmark is set at a category level. Any suggested option which fails to meet this benchmark (after aggregating across all stores) will be dropped and its quantity will be readjusted amongst other styles in the same attribute group
Column | Explanation | Remarks |
|---|---|---|
category | Category |
|
quantity | Minimum Order Qty for Each Styles within a category |
|
Category Exit Condition Percentage:
If the no of Options suggested by MS Enterprise™ for a Category in any Store is below the specified % of the Minimum options, that Store+ Category combination will be exited
If the number of suggested options is more than the specified % but less than the Minimum display options, then the no of options will be increased to meet the minimum display options
Column | Explanation | Remarks |
|---|---|---|
category | Category |
|
exit_percentage | Exit % benchmark for each category | If the no of Options suggested by MS Enterprise™ for a Category in any Store is below the specified % of the Minimum options, that Store+ Category combination will be exited |
Returns Percentage:
Maximum allowed returns to the vendor as a % of the Quantity bought for every Store+Category combination at the end of the Season
Column | Explanation | Remarks |
|---|---|---|
channel | channel |
|
store_code | store_code |
|
category | category |
|
returns_percentage | Max allowed returns_percentage for each store-cat |
|
Sell-Through Ratio Override:
Full Price Sell through target for every Store+Category+Sub Category+Price Bucket combination Optional Input- In the absence of this input, the Sell through automatically calculated by MS Enterprise™ will be used to recommend the Buy Quantities
Column | Explanation | Remarks |
|---|---|---|
channel | channel |
|
store_code | store_code |
|
category | category |
|
subcategory | subcategory |
|
price_bucket | price_bucket |
|
target_sell_thru | target sell through for each AGs within a Store-Cat-SubCat-PB |
|
In-Season Planogram Quantity:
Percentage of Planogram to be filled by the new Season Styles at the launch of the Season (Drop 1)
Column | Explanation | Remarks |
|---|---|---|
channel | channel |
|
store_code | store_code |
|
category | category |
|
qty_contri | Drop1 Plano Qty % for each Store-Cat |
|
Depth Range Segments:
Defines how the Styles can be grouped into segments based on buy quantity. Used only for reporting purposes
Column | Explanation | Remarks |
|---|---|---|
segment | Style Group Segment |
|
category | category |
|
min_depth | min_depth benchamrk |
|
max_depth | max_depth benchmark |
|
Micro buy Benchmark:
The minimum depth for a style at the category level below which all styles will be tagged as Micro buy
Column | Explanation | Remarks |
|---|---|---|
category | category |
|
benchmark | Min Depth benchmark |
|