| Configuration for batch-dayshare |
| Name |
PossibleValues |
Description |
| type |
4 |
Allowed values {1,2,3,4}. Indicates how to calculate daily shares. 1 - Selects between SKUs (product_locator) own indexes and indexes from data aggregated via top_down binding. 2 - All SKUs get equal shares. 3 - All SKUs get indexes computed from data aggregated over category specified in dayshare_configuration.explicit-kategory. 4 - All above mentioned will be calculated and best values selected. |
| sale-days |
1,2,3,4,5,6,7 |
Allowed values <1.7> separated by commas. Specifies the days of the week (1 = Monday, 7 = Sunday) for which the daily product_locator indices will be filled evenly at dayshare_configuration.type = 2 and / or when even indexes are assigned for better compatibility. |
| part-size |
2000 |
Allowed values (0, ∞), usually 200 or 2000. Specifies in how big parts the work for .NET threads will be divided. A good guide when choosing this number is the size of the top_down groups / categories configured in the dayshare_configuration.explicit-category to avoid too big or too small chunks that may result in slowing the system down. |
| compute-days |
0,1,2,3,4,5,6 |
Allowed values <0, 6> separated by a comma. Specifies the days of the week (0 = Monday, 6 = Sunday) for which the batch will not be incrementally optimized. During incremental optimization, the new product_locators will be assigned values according to the selected dayshare. The allowed. |
| explicit-category |
AUTO |
Allowed values is a comma-separated list of categories in the format cX_id, or the value AUTO. Combinations of the specified levels will be used to determine the affiliation of the product_locator to the categories, if the AUTO value is entered, all available will be used. |
| min-months |
4 |
Allowed values (0, ∞). Specifies the minimum length of data in whole months with non-zero sales at which the series will be considered valid for the calculation of monthly indices. |
| min-weeks |
8 |
Allowed values (0, ∞). Specifies the minimum length of data in whole weeks with non-zero sales at which the series will be considered valid for the calculation of weekly indices. |
| min-improvement |
0.025 |
Allowed values <0, 1). Specifies the minimum rate of improvement of indexes for product_locator when moving to a higher level (even> category> top_down> product_locator. |
| min-sale-percentage |
0.7 |
Allowed values <0, 1> Specifies the minimum ratio of sales and non-sales days in the last month (30 days) since the last non-zero movement, at which the product_locator / top_down / category starts to calculate its own index, up to this ratio the indexes will be assigned evenly. |
| max-days-without-sale |
30 |
Allowed Values (0, ∞) Specifies the maximum day length of the product_locator / top_down / category without sales in which the own indexes will be calculated, after this time indexes will be assigned evenly. |
| history-limit |
2 |
Allowed Values <1, ∞). Specifies in years the maximum length of the product_locator / top_down / category history (according to the dayshare_configuration.type setting). For example, if set to 2 and PwDate is 20.4.2015, the history 1.4.2013 - 1.4.2015 will be used. |
| christmas-analysis-enabled |
0 |
Allowed values {0,1}. The variable enables Christmas analysis. If set to 0, Christmas analysis will not start. |
| easter-analysis-enabled |
0 |
Allowed values {0,1}. The variable enables Easter analysis. If set to 0, Easter analysis will not start. |
| day-smoothing-enabled |
1 |
Range of values {0, 1}. If set to 1, it allows the smoothing of the resulting daily indexes 25/50/25%. |
| day-index-zeroing-threshold |
0 |
Range of values <0, ∞). Specifies an index value below which the index will be reset before smoothing. |
| day-smoothing-protection |
5 |
Allowed values: <1, 7>, separated by commas. Specifies the days of the week (1 = Monday, 7 = Sunday) for which the value cannot be reduced by smoothing. |
| max-third-difference-constraint |
0.2 |
Allowed values <0, ∞). If set to 0, disables constraint for third of the month values, constraints maximal difference between thirds of the month to the specified value otherwise. |
| Configuration for batch-db_cleanup |
| Name |
PossibleValues |
Description |
| db-cleanup-enabled |
0 |
Indicates whether db-cleanup is enabled. |
| relevant-forecast-history-months-count |
6 |
Indicates how many months of the forecast history from the current month should be retained in the db. Value = 0 means that it should be stored indefinitely. |
| relevant-move-history-months-count |
36 |
Indicates how long (in months) should the move/transaction history be retained in the db. Value = 0 means that only the records of the current month are retained. |
| relevant-price-history-months-count |
6 |
Indicates how many months of price history tables from the current month should remain in the db. Value = 0 means that all price_history_* tables except from the current month are deleted. |
| relevant-smi-history-months-count |
6 |
Indicates how many months of SMI tables (slow moving inventory) can remain in db after the current month. Value = 0 means to delete all smi_month_ * and smi_default_data_ * tables except from the current month. |
| archive |
0 |
1 = before deleting old data, this old data is archived to the archive database, which is defined in pwm as db_name_archive. |
| relevant-promo-history-months-count |
36 |
Indicates how many months of history promotions from the current month should remain in the db. |
| cleanup-and-archive-period-for-move |
full-month |
Move cleanup period: full-month = if we want to keep eg 1 month of data, the whole last month will be saved plus what we have in the current month; full-year = if we want to keep eg 36 months of data, the whole last 3 years plus the current year are kept. |
| relevant-promotool-history-months-count |
60 |
It indicates how many months the promotion from Promotool has to remain in db from the current month. Value = 0 means that all actions (and their data) except the current month will be deleted. Follows pt_header.delivery_date_to, ie. if the action extends to the period we want to keep, whole action is retained. |
| cleanup-and-archive-period-for-promotool |
full-year |
The period of promotion deletion from Promotool: full-month = if we want to keep eg 1 month of data, the whole last month will be saved plus what we have in the current month; full-year = if we want to keep, for example, 36 months of data, the entire last 3 years are retained plus the current year. |
| cleanup-and-archive-date-column-for-intelligent-orders |
full-year |
"History cleanup period for exports to SODI: full-month = if you want to keep, for example, 1 month of data, the entire previous month will be retained along with the current month's data; full-year = if you want to keep, for example, 36 months of data, the last 3 full years will be retained along with the current year." |
| cleanup-and-archive-period-for-promo |
full-year |
Cleanup period for promotions from promo_action: full-month = if you want to keep, for example, 1 month of data, the entire previous month will be retained along with the current and future months; full-year = if you want to keep, for example, 36 months of data, the last 3 full years will be retained along with the current and future years. |
| cleanup-and-archive-date-column-for-promo |
promo_date_from |
The date column from the promo_action table used for backup operations. |
| clean-forecasting-method-parameters-plid |
0 |
Allow deletion of data from the forecasting_method_parameters_plid table for PLIDs that no longer exist. Enable by setting value = 1. Warning: enabling this may increase recalculation time. |
| relevant-intelligent-orders-history-months-count |
24 |
Specifies how many months of export history to SODI, counting from the current month, should remain in the database |
| cleanup-and-archive-date-column-for-sodi |
full-year |
Cleanup period for export history to SODI: full-month = if you want to keep, for example, 1 month of data, the entire previous month will be retained along with the current month's data; full-year = if you want to keep, for example, 36 months of data, the last 3 full years will be retained along with the current year. |
| relevant-sodi-history-months-count |
24 |
Specifies how many months of export history to SODI, starting from the current month, should remain in the database. |
| Configuration for batch-fast_adapt |
| Name |
PossibleValues |
Description |
| enabled |
1 |
Range of values {0, 1}. Value 1 enables the calculation of the Forecast Fast adapt. |
| promo-days-tolerance |
8 |
Range of values <0, ∞). How many maximum number of promotion days can be in the history in order to fast adapt evaluation (evaluation on PLID level). |
| zero-group-trim |
1 |
Value range: {0, 1}. If set to 1, it allows trimming (grouping) of days with sales = 0 at the beginning of the observed period (days-to-history). |
| regression-grouping |
7 |
Range of values <1, ∞). Number of days on which the data and regressions will be grouped in the fast adapt. |
| history-days |
56 |
Range of values <1, ∞). Number of days of sale that will enter the fast adapt (rounded up to regression-grouping multiples). |
| forecast-days |
28 |
Range of values <1, ∞). Number of days on which the regression forecast will be compared with the original forecast (rounded up to regression-grouping multiples). |
| change-ratio-up |
0.5 |
Range of values <1, ∞). Percentage of the regression forecast that we will take as a new forecast when applying the fast adapt up. |
| change-ratio-down |
0.5 |
Range of values <1, ∞). Percentage of the regression forecast that we will take as a new forecast when applying the fast adapter down. |
| down-evaluate-limit |
80 |
Allowed values <0, ∞). Specifies in percent the minimum ratio between the PW forecast and the regression forecast, if PW predicts higher forecast, the fast-adapt will respond by lowering the forecast. |
| up-evaluate-limit |
120 |
Allowed values <0, ∞). Specifies in percent the maximum ratio between the PW forecast and the regression forecast, if PW predicts lower forecast, the fast-adapt will respond by increasing the forecast. |
| lower-safetystock-enabled |
0 |
Range of values {0,1}. Enable safetystock reduction according to change from fast-adapt. |
| zero-group-tolerance |
3 |
Allowed values (0, ∞). If in the monitored period (days_to_history) there is a larger number of day groups (grouping) with sales = 0 than this setting, fast-adapt will be disabled. |
| increase-safetystock-enabled |
0 |
Range of values {0,1}. Enable increase of safety stock according to the change from fast-adapt. |
| aggregation-type |
0 |
Range of values {0, 1, 2}. Type of fast-adapt forecast aggregation. 0 = Not aggregated, each PLID is calculated individually. 1 = Aggregates according to the top_down_relation_accumulated table. 2 = Aggregates according to table fast_adapt_relation. |
| aggregation-lowering-type |
2 |
Range of values {0, 1, 2}. Type of forecast decreasing when fast-adapt-aggregation-type> 0. 0 = All for root. 1 = Evenly. 2 = Proportionally according to the current forecast. |
| aggregation-increase-type |
0 |
Range of values {0, 1, 2}. Forecast increasing type when fast-adapt-aggregation-type> 0. 0 = All for root. 1 = Evenly. 2 = Proportional to the current forecast. |
| ignore-cleaned-up-plids |
1 |
Allowed values {0, 1}. If set to 1, the fast-adapt will ignore the months in which it was set by the user to clear the forecast. |
| days-with-supply-limit |
20 |
Range of values <0, 100>. In percentages, the maximum number of days which can be in the stockout in order to fast-adapt evaluation (on PLID level). |
| change-ratio-super-FA |
1 |
Range of values <0, ∞). Percentage from the regression forecast that we will take as a new forecast when applying the fast-adapt for new PLIDs. |
| moving-average-enabled |
1 |
Range of values {0, 1}. If set to 1, sales smoothing is enabled in fast-adapt using moving average. |
| adaptive-slope-enabled |
0 |
Field of values {0, 1}. If set to 1, enable the evaluation of the trend change within the fast adapter from ascending to descending and will prefer a shorter part of the data (descending). |
| normalization-zero-level |
1e-6 |
Value range: <0, ∞). Specifies the threshold of the index used for normalization based on daily distribution (day-share, season-indices, Easter, and Christmas), below which the input sales will be set to zero instead of being divided. |
| minimum-smoothing-enabled |
1 |
Range of values {0, 1}. If set to 1, add half the difference between the lowest sale and the second lowest sale to the lowest sale. |
| normalization-index-minimum |
0.33 |
Range of values (0, ∞). Specifies the minimum value of index for normalization according to the daily distribution (classically day-share or christmas / easter). For example, a value of 0.33 means that the sale will be increased by a maximum of three times. |
| output-index-maximum |
43587 |
Range of values (0, ∞). Specifies the maximum amount of the index for adjusting the output regression according to the daily distribution (classically day-share, or christmax / easter) and the seasonal index. For example, a value of 2.5 means that the regression will be increased by a maximum of 2.5x. |
| zero-group-first-sale-limit |
0 |
Value range: <0, ∞). If set to a value > 0, it specifies the number of days from PwDate after the first sale (product_locator_first) during which the zero-group-tolerance rule will be applied. If this period is exceeded, the rule will be ignored and Fast Adap will be calculated even if the group exceeds the limit. |
| Configuration for batch-forecast |
| Name |
PossibleValues |
Description |
| max-history-length |
NULL |
Maximum length of history in months. It can be NULL. The parameter is used in batch-history-for-forecast. !ATTENTION! additional restrictions for the length of history used in .net BatchForecast can be set in forecast_composite_configuration. More restrictive setting will be used! |
| batch-history-for-forecast-part-size |
2000 |
Number of PLIDs in one thread in OLD calculation of batch-history-forecast. DO NOT use in the future. |
| middleout-explicit-category |
c4_id |
Middleout categories - c_id category lists separated by semicolons. Example: c3_id; c3_id, c4_id; c3_id, c4_id, c5_id |
| middleout-enabled |
1 |
Range of values {0, 1}. Enable middleout forecast. |
| batch-forecast-part-size |
200 |
Number of items (top-down trees) per thread in .NET forecast. |
| top-down-distribution-type |
1 |
Range of values {0, 1, 2, 3}.The method of distribution of the accumulated top-down forecast on the PLIDs. 0 = FloorRoundAtChildren (rounding downwards), 1 = SmartRoundAtChildren (smart rounding, default), 2 = RoundAtChildren (ordinary rounding) 3 = DoNotRoundAtChildren (without rounding), 4 = ZeroAtChildren (set to zero) |
| irrelevant-history-cutoff-enabled |
1 |
Range of values {0, 1}. Enabling irrelevant history cut-off. |
| seasonality-shifting-enabled |
1 |
Range of values {0, 1}. Enable Moving seasonality in .NET forecast - used to capture the earlier onset of seasonality. |
| topdown-enabled |
1 |
Range of values {0, 1}. Enable top-down. |
| memorize-forecast-continuous-enabled |
1 |
Range of values {0, 1}. Enable memorization of forecast_continuous_errors_accumulated table in .NET forecast. |
| stockout-increase-forecast-in-history |
1 |
Range of values {0,1}. If set to 1, lost sales are uploaded as a forecast input (stockout analysis must be allowed). |
| sellout-forecast-cutoff |
1 |
Allowed values {0, 1}. If set to 1, the forecast of sales items will be reduced at the level of available stock. |
| topdown-history-length-for-ratio |
12 |
Length of the history from which the ratio is calculated for TD purposes. Eg for retail it is good to calculate the ratio from the shorter history.. |
| batch-day-variability-part-size |
2000 |
Number of calculation units (product-locators) in one thread in .NET calculation of daily variability. (Usually hundreds or thousands.) |
| freeze-day |
0 |
Range of values <1, 31>. The day of the month in which the forecast is freezed. |
| show-in-detail-screen |
0 |
Allowed values {0, 1}. If set to 1, the graph of the best forecast will be displayed on the detail tab. |
| accept-ofc |
0 |
Range of values {0, 1}. If set to 1, OFC will be added to the history for forecasting. |
| middleout-history-length-for-ratio |
12 |
Length of history in months, from which the distribution between members of middleout groups will be calculated. (Usually between 3 and 24.) |
| middleout-ratio-smooth-coefficient |
5 |
Allowed values <0, 1>. The value of the sales multiple of the last and next month of history, if exceeded, will be smoothed in the calculation of the decay ratio (only from below) more at https://wiki.logio.cz/bin/view/planning-wizard/pw-tech-doc/Ratio-computation |
| middleout-ratio-slope-difference-coefficient |
0.05 |
Limit value of the regression slope difference between full and half history, if it is exceeded, only a half of the available history will be used to calculate the middleout. |
| middleout-ratio-part-size |
5000 |
Number of middle-out groups which will be calculated in one .NET thread. (Usually thousands or tens of thousands.) |
| top-down-ratio-smooth-coefficient |
5 |
Allowed values <0, 1>. The value of the sales multiple of the last and next month of history, if exceeded, will be smoothed in the calculation of the decay ratio (only from below) more at https://wiki.logio.cz/bin/view/planning-wizard/pw-tech-doc/Ratio-computation |
| top-down-ratio-slope-difference-coefficient |
0.05 |
Limit value of the regression slope difference between full and half history, if it is exceeded, only a half of the available history will be used to the calculation of the middleout.. |
| top-down-ratio-part-size |
5000 |
Number of the top-down trees that will be calculated in one .NET thread. |
| middleout-default-type |
5 |
Range of values {1, 2, 3, 4, 5, 6}. Default middleout behavior for all root top-down groups not listed in the table middleout_product_locator_settings. Range of values from the dial middleout_type, more at https://wiki.logio.cz/bin/view/planning-wizard/pw-tech-doc/Nov%C3%BD_middleout |
| batch-forecast-day-week-part-size |
2000 |
Number of PLID per computation thread for calculation of the day / week forecast in batch-forecast.php. |
| forecast-day-length |
0 |
Number of days for calculation of daily forecast. |
| forecast-week-length |
0 |
Number of days for calculation of the weekly forecast. |
| top-down-distribution-type-for-zero |
0 |
Range of values {0,1}. Specifies how to distribute proportional sales for zeroed top-down elements. 0 = distribution between non-zero, 1 = all for top-down root. |
| middleout-new-product-history |
PLID |
Range of values: value PLID or number of months in history. The number of months in history that the product must go through in order to not to be considered as new product. Def. the PLID value takes information from the table product_locator.sellout_new_product_type_id. |
| number-of-months-to-view |
18 |
Range of value (0, ∞). How many full forecast months should be displayed. |
| number-of-months-to-forecast |
24 |
Range of value (0, ∞) For how many whole months sales are to be forecasted. |
| simple-forecasting-method-history-limit |
0 |
After |
| top-down-ratio-seasonal-index-effect |
1 |
Allowed values <0, 1>. Used to determine the weight of the seasonal index from the season_indices table to balance sales when calculating the ratio in the group. A value of 1 means the full effect of seasonal indices, 0 disables their loading. In the interval (0, 1) the effect is reduced relatively (0.2 means reducing by 20 %). |
| middleout-ratio-seasonal-index-effect |
1 |
Allowed values <0, 1> are. Used to determine the weight of the seasonal index from the season_indices table to balance sales when calculating the ratio in the group. A value of 1 means the full effect of seasonal indices, 0 disables their loading. |
| zero-non-seasonal-forecast |
0 |
Range of values {0, 1}. If set to 1, forecast for highly off-season months is deleted. |
| zero-non-seasonal-forecast-for-new-products |
0 |
Range of values {0, 1}. If set to 1, for new products in strongly seasonal categories is used the seasonal index of the category and is reset the off-season forecast. |
| middleout-method-count |
5 |
Range of values <0, ∞>. If set to> 0, setting limits the number of stored middleout methods for one middleout_description_id (combination of selected categories) to the X best. |
| rpc-forecast-methods-enabled |
0 |
Value range: {0, 1}. Enables RPC forecasting methods. |
| gen-opt-initial-convergence-window |
5 |
Value range: <1, ∞). Window in number of attempts used to evaluate optimization interruption. |
| gen-opt-initial-convergence-percent |
0.5 |
Value range: (0, ∞). Minimum improvement in % over the initial convergence window required to continue the genetic optimization |
| gen-opt-tuning-enabled |
1 |
Value range: {0, 1}. If set to 1, it enables subsequent genetic optimization of stored forecasting method parameters during each following forecast. |
| gen-opt-tuning-min |
10 |
Value range: <1, ∞). Minimum number of genetic optimization iterations for an already optimized forecasting method. |
| gen-opt-tuning-max |
10 |
Value range: <1, ∞). Maximum number of genetic optimization iterations for an already optimized forecasting method. |
| gen-opt-tuning-convergence-enabled |
0 |
Value range: {0, 1}. If set to 1, it allows interruption of the optimization after tuning-min iterations if the fitness function value has not improved by at least tuning-convergence-percent within the tuning-convergence-window. |
| gen-opt-tuning-convergence-window |
5 |
Value range: <1, ∞). Window in number of attempts used to evaluate whether optimization should be interrupted |
| gen-opt-tuning-convergence-percent |
0.5 |
Value range: (0, ∞). Minimum improvement in % over the tuning-convergence-window required to continue genetic optimization. |
| gen-opt-initial-min |
50 |
Value range: <1, ∞). Minimum number of genetic optimization iterations for a new forecasting method. |
| gen-opt-initial-max |
50 |
Value range: <1, ∞). Maximum number of genetic optimization iterations for a new forecasting method. |
| gen-opt-initial-convergence-enabled |
0 |
Value range: {0, 1}. If set to 1, it allows interruption of the optimization after initial-min iterations if the fitness function value has not improved by at least initial-convergence-percent within the initial-convergence-window. |
| batch-forecast-day-part-size |
2000 |
Number of PLIDs per thread for calculating daily/weekly forecasts in batch-forecast.php. |
| top-down-default-zero |
1 |
Default top-down setting for zero (0 - not set, 1 - set by zero). |
| top-down-ratio-computation-type |
ADAPTIVE |
Value range: {ADAPTIVE, SIMPLE}. ADAPTIVE evaluates all configurations regarding smoothing and history trimming, while SIMPLE uses the entire available configured history without smoothing. |
| middleout-ratio-computation-type |
ADAPTIVE |
Value range: {ADAPTIVE, SIMPLE}. ADAPTIVE evaluates all configurations related to smoothing and history trimming, while SIMPLE uses the entire configured available history without smoothing. |
| gen-opt-enabled |
1 |
Value range: {0, 1}. If set to 1, it enables genetic optimization of forecasting method parameters. |
| accept-sale-internal |
1 |
Value range {0, 1}. If set to 1, it adds sale_internal to the sales in the forecast. |
| Configuration for batch-order |
| Name |
PossibleValues |
Description |
| stockout-lost-amount-rate |
1 |
If the stock is below zero level, then if the setting is 1 => everything must be ordered (the whole amount below zero level). If x (x> = 0) => I will order x * what I am below zero level. |
| order-accept-ofc-delivery-date |
0 |
Range of values {0, 1}. It the setting is set to 1, orders and other calculations accept the expected delivery date of the order (otherwise the order date will be used). |
| working-days-group-order |
1 |
Range of values {0, 1, 2}. Setting of the working week for ordering - 1 => Mon-Fri, 2 => Mon-Sat, 0 => Mon-Sun. Applies only to a product with fixed period. |
| working-days-group-delivery |
1 |
Range of values {0, 1, 2}. Setting the working week for ordering - 1 => Mon-Fri, 2 => Mon-Sat, 0 => Mon-Sun. Applies only to a fixed period product. |
| new-product-ordering |
0 |
New products ordering (if they have disp = 0, fm = 0 and there is no proposal for them). 0 - obj is created for quantity 0, 1 - for quantity MOQ (pp.minimal_quantity), 2 - for quantity SET (package, pp.minimal_quantity_set). If the warehouse_product.new_product_order_amount is set, new_product_ordering_supply is preferred and this setting is ignored. |
| compute-order-amount-lasts-days |
0 |
Range of values {0, 1}. If the setting is set to value 1, then AMOUNT_LASTS_DAYS calculation is enabled in order_suggested. It means the number of days for which the quantity proposed in the order is spent. |
| enable-leadtime-first-shift-redistribution |
0 |
In abstract-order-method in loadProviders shifts leadtime_first, 0 = off, 1 = on, 2 = according to the accept_for_lt_first_shift flag in future_move (1 = accept, 0 = ignore) |
| enable-leadtime-first-shift-provider |
1 |
see enable-leadtime-first-shift-redistribution |
| enable-leadtime-first-shift-production |
0 |
see settings enable-leadtime-first-shift-redistribution + property ltFirstDisableClientCondForFM |
| special-preorder-moq-zero-only |
0 |
Range of values {0, 1}. When to apply the MOQ to the promotion pre-purchase. 0 = always, 1 = only if we do not suggest anything. |
| special-preorder-use-expiration |
1 |
Range of values {0, 1}. Should we consider the expiration date in case of pre-purchasing? 0 = no, 1 = yes. |
| max-stockout-index |
720 |
Range of values {0, 1}. How long in advance will we deal with stockouts? The value is the number of days from today when the last stockout we are resolving can occur. 0 = off. Affects the number of proposed orders. |
| order-limit-include-special-preorders |
1 |
Range of values {0, 1}. If the setting is set to value 0, then when adding orders at the order limits, promotions will not be added to the orders for today, ie order_suggested.special_preorder = 1. |
| back-redistribution-rounding-when-no-needed-supply |
0 |
Range of values {0, 1}. If redistribution rounding is allowed (done in Access Rights) and at the same time a complete stock redistribution is proposed, if set to 0 here, quantity will not be rounded. |
| intelligent-rounding-amount-max-days-to-round-set |
15 |
Maximum days of supply after delivery of the quantity rounded per package. If the maximum number is exceeded, quantity will not be rounded on given package (rounded on another or not rounded at all). See use-intelligent-orders-rounding access-right. |
| order-sporadic-accept-fastest-provider |
0 |
Range of values {0, 1}. If it is set tovalue 1, then the sporadic products are always ordered from the fastest supplier. It could be combinated with setting promo_safetystock.ignore-sporadic-redistribution. |
| lower-safetystock-for-first-period-ratio |
0.9 |
How much percent should the safetystock be reduced in the first period. |
| order-explanation-history-days-to-keep |
0 |
How many days ago should order-explanation data be available. 0 = nothing is saved. The maximum limit is given by the setting in batch-order-history. |
| order-explanation-history-outlook |
30 |
How many days from the date structure should be stored in db. |
| shorten-period-if-less-than-percent |
0 |
Range of values <0, 1>. If it is > 0, then it determines up to what percentage between 2 ordering days we prefer to order earlier. Details: https://wiki.logio.cz/bin/view/planning-wizard/pw-tech-doc/Objedn%C3%A1vky |
| respect-provider-leadtime-for-delivery |
0 |
Allowed values {0, 1}. If it is set to value 1, then when calculating delivery days the set leadtime of the supplier will be respected - eg 0> 1 with a leadtime of 7 days will mean delivery until Tuesday of the next week, not on the second day. |
| leadtime-compute-settings |
0,2 |
Allowed values {0, 1, 2, 3}. Setting how to calculate leadtime. Values are separated by commas. 0 = via product_locator_id and supplier, 1 = via user settings in the leadtime_group_relation table, 2 = via product_id and supplier, 3 = via supplier. |
| min-purchase-count-for-leadtime |
1 |
Setting of the minimum number of purchases. |
| intelligent-rounding-amount-max-days-to-round-moq |
30 |
Allowed values {0, 1}. Maximum stock endurance after delivery of the rounded quantity to moq in days. If the maximum endurance is exceeded, it is not rounded to the moq (it is rounded off the package or not rounded at all). See right use-intelligent-orders-roundingmoq. |
| intelligent-rounding-force-round-to-moq |
0 |
Allowed values {0, 1}. 1 = Force rounding on moq toregardless of the inventory life after delivery of moq. Used in the evaluation of profitability, the use-intelligent-orders-right must be turned on. |
| intelligent-rounding-force-round-to-min-set-from-provider |
0 |
Allowed values {0, 1}. 1 = Force rounding to the smallest package regardless of the endurance of the stock after delivery of the package for PLIDs loaded by the supplier. Used for profitability evaluation, the use-intelligent-orders-right must be turned on. |
| intelligent-rounding-force-round-to-min-set-from-other-source |
0 |
Allowed values {0, 1}. 1 = Force rounding to the smallest package regardless of the endurance of the stock after delivery of the package for PLIDs loaded with redistribution or production. Used for profitability evaluation, the use-intelligent-orders-rounding right must be enabled. |
| supplier-and-order-administration-v2 |
1 |
Allowed values {0, 1}. Enable (1) or disable (0) the use of the periodic orders module: https://wiki.logio.cz/bin/view/planning-wizard/pw-tech-doc/Admin-periodical-ordering |
| intelligent-rounding-enabled-from-udm |
0 |
Allowed values {0, 1}. 1 = Profitability evaluation rounding is turned on from udm. Do not set with a differential, udm will overwrite it. Independent of udm, you can enable by the use-intelligent-orders-rounding right. |
| intelligent-rounding-use-moq-as-set |
0 |
Takeas a multiple and round to MOQ similar to packaging. Used only for profitability evaluation, the use-intelligent-orders-rounding right must be enabled. |
| alternative-supplier-gui |
0 |
Allowed values {0, 1}. 1 = enable, 0 = disable. Setting of the possibility of displaying alternative suppliers in the orders GUI. More information in the wiki -> Display of alternative suppliers https://wiki.logio.cz/bin/view/planning-wizard/pw-tech-doc/Zobrazen%C3%AD_alternativn%C3%ADch_dodavatel%C5%AF |
| allow-nonpreferred-providers |
0 |
Allowed values {0/1}. 1 = Enables support for the use of non-preferred suppliers under favorable conditions. See getBestProviderForStockout in order-method-normal. |
| ignore-leadtime-first-greater-than |
0 |
Range of values: [0..∞), the value is in percent. Specifies the threshold from which leadtime_first is no longer extended until the first future move is delivered. Percentages express a multiple (leadtime + std) by which the leadtime can be extended as much as possible. More on the wiki: h |
| back-redistribution-gui-limitation |
potential |
How much quantity can be added to the reverse distribution cart. Options (default potential): potential = most overstock from the source PLID, available-supply = most available stock from the source PLID, none = no limitation, it is possible to give any quantity. |
| back-redistribution-gui-show |
potential |
Setting of the display of source PLID in the table of potential back redistributions. Options (default potential): potential = only PLIDs that have an overstock are displayed, available-supply = PLIDs that have an available inventory are displayed, all = all are displayed. |
| periodical-ordering-only-working-days |
0 |
Allowed values {0/1}. 1 = Set the order days to working days only. |
| back-redistribution-basket |
0 |
Allowed values {0/1}. 1 = Turns on the functionality of "reverse redistribution basket". |
| disabled-suppliers-at-the-bottom-gui |
0 |
Allowed values {0/1}. 1: Suppliers with the setting enabled = 0 are displayed in the list below under active suppliers. It is a view in showhide of product detail - information about suppliers. |
| back-redistribution-potential-suggest-target |
0 |
Allowed values {0/1}. 1 = The report of Overstock identification shows suitable warehouse for redistribution. |
| back-redistribution-potential-suggest-on-level |
0 |
Allowed values {0/1}. 1 = The report of Overstock identification is looking for a suitable warehouse for redistribution only in the same warehouse category. |
| cancel-order-amount-real-to-amount-ratio |
0 |
The ratio of amount real and amount at which we cancel the order. If the amount real <ratio * amount, we cancel the order. |
| cancel-order-amount-real-to-ss-ratio |
0 |
The ratio of the amount real and safety stock at which we cancel the order. If amount real <ratio * ss, we cancel the order. |
| ordering-strategy |
SS-P |
Allowed values {SS-P, BS-BSMAX, MAX-MAX}. SS-P = After safety stock and stock intersection amount on period is ordered, BS-MAX = After blocked stock (stock + future move) and base stock intersection amount on base stock max is ordered, MAX = ? |
| return-first-found-order-index-for-delivery-index |
0 |
Allowed values {0/1}. 0 = Returns the last possible order index for the specified delivery index. 1 = Returns the first possible order index for the specified delivery index. |
| disable-providers-with-zero-leadtime |
0 |
Interval <0,1>. Default is 1. If set to 0, no action is taken. If set to 1, it sets the value enabled = 0 in the product_provider table where leadtime = 0.. |
| order-limit-include-promo-orders |
1 |
If set to 0, promotional orders (order_suggested.promo_action_id IS NOT NULL) will not be shifted within the Order Limits functionality. |
| order-limit-skip-groups-with-special-preorders |
0 |
If set to 1, groups (client_order_limit) within the Order Limits functionality that contain a special preorder for a promo (order_suggested.special_preorder) on the current day are considered to automatically meet the limit (i.e., the limit is not checked for them). |
| promo-use-normal-method |
1 |
If set to 1, the order method NORMAL will be enforced for all items in the promotion |
| order-limit-skip-groups-with-promo-orders |
0 |
If set to 1, groups (client_order_limit) within the Order Limits functionality that contain a promo order (order_suggested.promo_action_id IS NOT NULL) for the current day are considered to automatically meet the limit (i.e., the limit is not checked for them). |
| order-limit-group-future-orders |
0 |
The Order Limits functionality normally works by shifting orders for future days to the current day in order to meet today's limit. However, this means that the limit is not met for the future days. By enabling this configuration, orders will instead be shifted in a way that ensures limits are met for future days as well.
WARNING: If this configuration is enabled, the value of client_order_limit.period_to_cover will always be treated as 1.
For more details, see the chapter 'Issue of Order Limits for Future Days' |
| disable-providers-with-high-price |
0 |
Interval <0,1>. Default is 0. If set to 0, no action is taken. If set to 1, it sets the value enabled = 0 in the product_provider and product_locator tables where the purchase price is higher than the selling price. |
| default-leadtime-when-zero-leadtime |
0 |
Default is 0. If set to 0, no action is taken. Otherwise, this value is used as the lead time (LT) to be assigned to the supplier if the resulting LT is 0. |
| wacc-price-round-to-dec-if-lesser-than |
30 |
Default is 30. WACC value above which the WACC price is rounded to whole numbers. |
| stockout-provider-price-weight |
2 |
"Value ≥ 1. Specifies how many times the lead time (LT) must decrease relative to the price increase. With a value of 1, the percentage increase in price must match the percentage decrease in LT. With the default value of 2, a 10% price increase must be offset by at least a 20% reduction in LT |
| promo-days-before-end-to-lower |
0 |
<0, ∞). 0: disabled. Number of days before the end of the promotion during which the promotional safety stock should start decreasing linearly to zero. |
| basestock-order-on-min |
0 |
0 – stock must be less than the minimum to trigger an order; 1 – stock must be less than or equal to the minimum to trigger an order |
| zero-safetystock-when-zero-forecast |
1 |
Allowed values: {0/1}. If $enableForceZeroForecast is enabled and the forecast is zeroed out, then based on this configuration, the safety stock (SS) will also be zeroed. See abstract-order-method::loadDataInner. |
| increase-reserve-by-order-instantly |
0 |
Specifies whether the stock should be increased by the order quantity on the day of receipt. This setting can also be configured individually for specific PLIDs in order_configuration_product_locator. |
| increase-reserve-by-future-move-instantly |
0 |
Specifies whether the stock should be increased by the amount of the future move on the day of receipt. This setting can also be configured individually for specific PLIDs in order_configuration_product_locator. |
| decrease-reserve-by-forecast-instantly |
0 |
Specifies whether the stock should be reduced by the forecast/OFC at the beginning of the day. This setting can also be configured individually for specific PLIDs in order_configuration_product_locator. |
| max-days-to-next-redistribution-suggested |
999 |
Distribution of new product will be suggested in quantity defined in SIDI.warehouse_product, if there is no suggested distribution based on forecast in the future period (leadtime + this parameter). Default value is 999, meaning there must be no suggested order at all to create new product distribution suggestion |
| expiration-compute-bottom-up |
0 |
If order is limited by expiration: 1 - rounding up is performed on previous order amount, 0 - rounding down is performed on amount computed by expiration limiter algorithm |
| partial-expiration-future-move |
0 |
Allowed values {0/1}. Allows processing of partial expiration of future moves. Upon delivery, the expiration date is calculated and handled as batch/lot expiration. The expiration date is calculated according to the delivery date + expiration_days_for_orders. |
| partial-expiration-available-supply |
0 |
Allowed values {0/1}. Allows processing of partial expiration of available supply. The expiration date is calculated by pwdate + expiration_days_for_orders. When enabled, records for batch/layer partial expiration are ignored. |
| new-product-next-order-min-days-after-first-possible-delivery |
999 |
Order for new product will be suggested in quantity defined in SIDI.warehouse_product, if there is no suggested order based on forecast in the future period (leadtime + this parameter). Default value is 999, meaning there must be no suggested order at all to create new product order. |
| partial-expiration-available-supply-future-move-sale-out-days |
1 |
partial-expiration-available-supply-future-move-sale-out-days |
| period-ss-recompute-type |
1 |
Determines how to set period_ss (1) = LT (2) = period (3) = MIN(LT, period) (4) = SUM(LT, period) (5) = MAX(LT, period). If the period_ss is set in the Periodical ordering settings or in the SIDI, this setting is ignored for the given item. |
| Configuration for batch-outliers |
| Name |
PossibleValues |
Description |
| enabled |
1 |
Range of values {0, 1}. Turns outliers evaluation on (1) and off (0). |
| sensitivity |
3 |
Range of values {1, 3, 5}. Outlier detection sensitivity. 1 - smallest, indicates only very strong extremes in the off-season. 5 - the largest, also indicates small sales, even in the season. |
| aggregate-per-day |
1 |
Aggregation of movements by days for movements from the same clients. It can cause even small movements being labeled as extreme, as they have been aggregated and judged along with larger movements. 0 - do not aggregate, 1 - aggregate. |
| outlier-group-definition |
1 |
Range of values {0, 1, 2}. Determines the formation of aggregation groups on which the extremes are analyzed. 0 - by products, 1 - by PLIDs, 2 - by filled in table product_locator_group. |
| history-cutoff-enabled |
1 |
Range of values {0, 1}. If set to 1, it allows truncation of irrelevant history in Outliers. Truncated movements will never be marked by automatic detection as extremes! |
| overdetection-enabled |
1 |
Range of values {0, 1}. If set to 1, it captures the trimming of groups in which too much movement would be cleaned (according to the sensitivity max: 1 - 10%, 3 - 20%, 5 - 30%), or according to the overdetection-percentage-override setting. |
| min-moves |
10 |
Range of values {3, ∞}. Specifies the minimum number of movements after which the full Outliers algorithm will be used. Until then, a simplified version will be used, outliers in the group do not count at all for 3 moves! |
| overdetection-percentage-override |
0 |
Range of values <0, 1>. The percentage value if the setting is> 0 will be used when comparing the ignore-overdetected-enabled mechanism instead of the classic 0.1, 0.2, 0.3. |
| threshold-force-ratio |
3 |
Range of values (1, ∞). If the movement will be X times greater than the used threshold, it will be cleaned despite the insufficient error component in the month. |
| maximal-error-to-outlier-ratio |
0.4 |
Range of values (0, 1>. A setting that determines how many% of outliers can cut to a quantity that was not originally marked as an error in order to crop the detected motion. Formula (error caused = current error - amount of motion) if abs (caused by error |
| use-old-stl-decomposition |
0 |
Range of values {0, 1} If set to 1, the original STL decomposition is used in the outliers without linking to global seasonality |
| include-outlier-ids |
NONE |
Range of values {ALL, NONE, comma-separated values}. Affects which movements marked as outliers will be sent to .net. ALL - all moves, NONE - only outlier = 0, or enumeration of allowed values from the field outlier. |
| regression-months-before |
3 |
Value range: <0, ∞). Maximum number of months before the promotion from which the average sold quantity within the promotion will be calculated for the purpose of decomposition balancing. The surrounding period will be divided into three parts, and the smallest one meeting the sale-threshold condition will be used |
| regression-months-after |
3 |
Value range: <0, ∞). Maximum number of months after the promotion from which the average quantity sold during the promotion will be calculated for the purpose of decomposition balancing. The surrounding period will be divided into three parts, and the smallest one meeting the sale-threshold condition will be used |
| regression-sale-threshold |
0.6 |
Value range: <0, 1>. Minimum ratio of days with sales to the total number of days required to select a shorter period for calculating the quantity from surrounding values, based on the months-before and months-after settings. |
| Configuration for batch-promo_baseline |
| Name |
PossibleValues |
Description |
| relevant-promo-distance |
1095 |
Maximum relevant (daily) distance between historical promotions and the target promotion in promo-prediction. Historical promotions that are too far away are penalized according to the penalty-out-of-distance parameter. |
| relevant-seasonal-distance |
90 |
Maximum relevant seasonal distance between historical promotions and target promotion in promo-prediction. Historical off-season promotions are penalized according to the penalty-out-of-season parameter. |
| relevant-discount-difference |
20 |
The maximum relevant distance between the discounts of historical promotions and the discount of the target promotion in the promo-prediction. Historical promotions with too different a discount are penalized according to the penalty-large-discount-difference parameter. |
| relevant-length-ratio |
43556 |
Maximum relevant distance between the lengths of historical promotions and the length of the target promotion in the promo-prediction. Historical promotions with too different length are penalized by penalty-large-length-ratio. |
| penalty-out-of-distance |
0.2 |
Penalty on historical promotions that are too far away from the target promotion in the promo-prediction. |
| penalty-out-of-season |
0.5 |
Penalty on a historical promotion that is out-of-season relative to the target promotion in the promo-prediction. |
| penalty-large-discount-difference |
1.0 |
Penalty of the historical promotion of which the discount is too different from the discount of the target promotion in the promo-prediction. |
| penalty-large-length-ratio |
1.0 |
Penalty on a historical promotion whose length is too different from the length of the target promotion in the promo-prediction. |
| relevant-close-nonpromo-distance |
60 |
Maximum relevant (daily) distance between training non-promotional intervals and the target interval when calculating the promo baseline. Intervals that are not promotional or are too far away are penalized according to the penalty-close-nonpromo parameter. |
| penalty-close-nonpromo |
0.1 |
Penalty for training intervals that are either promotional or too far from the target interval. |
| minimal-percentual-discount-for-nonpromo-sale |
0 |
IMPORTANT! Minimum discount (percentage) for non-promotional sales. On some projects where most sales are promotional, non-promotional sales are often just a symptom of a missing promotion. In this case, we also assign a minimum discount to non-promotional sales, which then ensures that these non-promotional sales do not unnecessarily increase the baseline. The higher this minimum discount, the less the non-promotional sales will increase the baseline, and the lower the baseline will come out. |
| minimal-percentual-discount-for-promo-sale |
0 |
IMPORTANT! The minimum discount (in percentage) for promotional sales. On some projects where most sales are promotional, it is sometimes convenient to consider a minimum discount for promotional sales, because promotions with too low a discount are often not sufficiently discounted. The higher this discount, the more sales we are able to explain as a consequence of the discount, and the lower the baseline comes out. |
| maximal-percentual-increase-per-discount-point |
5 |
IMPORTANT! The maximum percentage increase in increment (relative to the baseline) per 1 percent discount. This parameter de-facto upper bounds the amount of promo-increment (relative to the baseline) that we can explain as a consequence of the discount. The higher the value of this parameter, the more sales we are able to explain as a consequence of the discount, and the lower the baseline comes out. |
| promo-action-padding-days-left |
0 |
The number of days we want to shift the left edge of the baseline promotion. |
| promo-action-padding-days-right |
0 |
The number of days we want to shift the right edge of the baseline promotion. |
| merge-predecessors-successors-enabled |
0 |
Allowed values {0, 1}. If it is set to 1, SKUs will be inserted into the merge_sales_relation table under promo-analysis-v2 according to the predecessor's successor session. These sessions are then used to accumulate sales within the .net batch. |
| merge-top-down-relation-enabled |
0 |
Allowed values {0, 1}. If set to 1, all SKUs in the top-down relation will be inserted into the merge_sales_relation table in promo-analysis-v2 (including top-down relations gained from predecessors and successors if enabled). These sessions are then used to accumulate sales within the .net batch. |
| promo-analyse-max-promo-action-length |
122 |
Maximum length of a promotion in days, which can be considered in the promo analysis. |
| promo-analyse-reimport-promo-sales-table-days |
0,1,2,3,4,5,6 |
Allowed values {0, 1, 2, 3, 4, 5, 6}. Indices of the days when the whole promo_sales table is to be filled again. On other days it will be filled incrementally. The separator is a comma, 0 - Sunday, 6 - Saturday. |
| promo-analyse-save-real-amount |
2 |
The way to save calculated values into result columns (increment, baseline, total) of promo_action table (default = 2). 0 -> overwrite nothing, 1 -> overwrite total, overwrite baseline, calculate increment as total - increment, 2 -> overwrite all |
| minimal-percentual-increase-per-discount-point |
0 |
Value range: <0, ∞). Likely important as well! Minimum percentage increase in increment (relative to baseline) per 1 percent of discount. |
| minimal-percentual-baseline-factor |
0 |
<0, 100>. Ultra super important!! All days of any promotion will be guaranteed at least this percentage of the baseline compared to the total sales. |
| maximal-percentual-baseline-factor |
100 |
<0, 100>. Ultra super important!! All days of any promotion will be guaranteed at most this percentage of the baseline compared to the total sales. |
| Configuration for batch-promo |
| Name |
PossibleValues |
Description |
| promo-analyse-enabled |
1 |
Range of values {0,1}. If it is set to 1, promo analysis will be calculated. |
| promo-prediction-enabled |
1 |
Range of values {0,1}. If it is set to 1, promo prediction will be calculated. |
| promo-prediction-save-to-forecast |
1 |
Range of values {0,1}. If it is set to 1, the results from promo-prediction will be saved to forecast. |
| post-promo-effect-enabled |
0 |
Range of values {0, 1}. If it is set to 1, post-promo effect will be calculated. |
| post-promo-effect-compute-length |
0 |
Range of values {0, 1}. If it is set to 1, the lenght of the post-promotion effect will be calculated. If it is set to 0, the value `post-promo-effect-default-length` is used as the lenght of the post-promotion effect. |
| post-promo-effect-default-length |
14 |
The default length of the post-promotion effect in days. |
| post-promo-effect-max-length |
14 |
The length of the maximum post-promotion effect in days. Indicates the number of days since the end of the event during which post-promo candidates are sought. If `post-promo-effect-compute-length` is off,` post-promo-effect-default-length` will be set regardless of this setting. |
| report-promo-detail |
0 |
Range of values {0,1}. If it is set to 1, promo detail report is shown. Designed for promo-analysis-v1. |
| report-promo-evaluation-on-detail |
1 |
Range of values {0,1}. If it is set to 1, promo evaluation in detail report is shown. Designed for promo-analysis-v2. |
| report-promo-evaluation |
1 |
Range of values {0,1}. If it is set to 1, promo evaluation report is displayed in quick reports. |
| promo-prediction-overlapping |
1 |
Range of values {1, 2, 3}. How to calculate overlapping promotions in promo-prediction (default = 1). 1 = The effects of the overlapping parts are added together, 2 = We take the maximum effect in the overlapping parts, 3 = We shorten the right edge of all overlapping promotions. |
| copy-promo-from-past-to-future |
0 |
Increase forecast by promotions from the past (0 = off, 1 and more: fd.outlook, from which it will increase amount_promo based on the past. Overwrites only increment according to the increment of the sale_month table of the given month last year) |
| fast-adapt-enabled |
1 |
Range of values {0,1}. Enable (1)/ disable (0) calculation of promo-fast-adapt. |
| fast-adapt-promo-days-running |
3 |
How many days must the promotion be running to take effect in the adaptation. |
| fast-adapt-minimal-difference-ratio |
0.1 |
Range of values <0, 1>. How many percentages must historical daily sales and proposed daily sales differ in order for the value to be overwritten. |
| promo-prediction-running |
1 |
Range of values <1, 2>. The decay type of the currently running promotion during promo-prediction (default = 1). 1 = The whole promotion will be broken down according to the split into the whole period, 2 = The rest of the promotion, which has not yet been sold, will fall apart, from today to the end of the promotion. |
| promo-prediction-share-split-type |
4 |
1: FIRST DAY: RUN-the rest of theuntil the current day. NERUN-whole promo on the first day, FA-IGN 2: UNIFORM: evenly throughout the promotion. FA-AKC, RUN-AKC 3: USER: according to promo_user_split. RUN-IGN, FA-AKC. 4: AUTO: dayshare based on min., RUN-IGN, FA-AKC |
| promo-prediction-dayshare-type |
0 |
Range of values {0, 1, 2}. Setting whether the dayshare breaks out of INCREMENT or TOTAL. 0: by split-type (FIRST DAY: TOTAL, other INCREMENT), 1: INCREMENT, 2: TOTAL. The default is 0. If TOTAL breaks down, it is also possible to add minus amounts. |
| promo-fast-adapt-use-share-indices |
1 |
Range of values {0, 1}. If set to 1, it allows the use of disintegration indices for days when evaluating the sold quantity during an ongoing promotion. If set to 0, only the number of running days takes into the evaluation. |
| promo-prediction-use-month-indices |
1 |
Range of values {0, 1}. If it set to 1, allows the use of indexes from forecast_history_month_share when calculating the share of days in the promotion effect. If it set to 0, it will use an even proportional distribution. |
| post-promo-save-to-history |
1 |
Range of values {0, 1}. If it is set to 1, calculation and subsequent storage of historical antipostpromo in the tables sale, sale_month, [sale_week, forecast_history] is enabled (0 = disabled). |
| promo-report-important-date |
auto_promo |
Specifies which dates to display in the promotion report. Values range: {promo, delivery, auto, auto_promo, auto_delivery}. If auto, auto_promo, or auto_delivery is set, the batch can reset this value to auto_promo or auto_delivery (depending on which dates are more similar to tocompute). Values promo and delivery are not overwritten. |
| promo-compute-target-v2-log-enabled |
0 |
The value range is {0, 1}. If it is set to 1, it enable logging of the computeTargetPromoActionPredictionV2 method (0 = disable). |
| batch-promo-baseline-v2-part-size |
2000 |
Number of computational units (product-locators) in one thread in .NET compute of baseline v2. |
| batch-promo-history-share-part-size |
2000 |
Number of computational units (product-locators) in one thread in .NET compute of promo-history-share. |
| batch-promo-training-promoactions-part-size |
200 |
Number of computational units ( product-locators) in one thread in the calculation of training promotions.. |
| batch-promo-prediction-share-part-size |
200 |
Number of calculation units (product-locators) in one thread in .NET calculation of promo-prediction-share. |
| batch-promo-prediction-part-size |
200 |
Number of calculation units (product-locators) in one thread in calculation of promo-prediction. |
| promo-prediction-share-retail-provider-enabled |
0 |
The value range {0, 1}. If it is set to 1, calculation of promo-predictions (mainly promo-prediction-share) in the case of a retail supplier is enabled (0 = disabled). |
| promo-prediction-relation-enabled |
0 |
The value range {0, 1}. If it is set to 1, the calculation of promo-prediction using promo-prediction-relation is enabled (0 = disabled). |
| fast-adapt-distribution-enabled |
1 |
The value range {0, 1}. If it is set to 1, It allows redistribution of running amount based on promo-prediction-relation. Enable this parameter if you want the promo-fast-adapt to respond based on the total quantity sold in the promotion. |
| promo-prediction-share-relation-enabled |
1 |
Range of values {0, 1}. Calculation of promo-prediction share using promo-prediction-relation. If it is turned off, a promo-prediction-share is calculated for every PLID separately. If it is enabled, it is calculated only for parent product-locators (PLIDs). |
| promo-prediction-training-weight-sum-threshold |
2.0 |
Threshold of the sum of the training promotion weights in the prediction to limit their number. If the sum of the weights of the best training promotions exceeds this limit, and at the same time the minimum number of training promotions is exceeded, further promotions are ignorated. |
| promo-prediction-min-training-promoactions |
40 |
The minimum number of training promotions required for prediction. If the real number is smaller, nothing is predicted. |
| promo-matrix-data-enabled |
0 |
Range of values {0, 1}. If it is set to 1, precalculate the promo matrix for the future actions and save the result in the promo_matrix_data table. If it set to 0, precalculation is not realized. |
| batch-promo-prediction-tuning-part-size |
100 |
Number of calculation units (tuning groups) in one computation thread in the calculation of promo-prediction-tuning. |
| promo-prediction-tuning-enabled |
0 |
Range of values {0, 1}. Default = 0. If it is set to 1, tuning of promo-prediction parameters is enabled (0 = disabled).. |
| promo-prediction-tuning-validation-length |
90 |
Length of the validation section of the history in days, from which we select validation historical promotions designed for parameter tuning. |
| promo-prediction-tuning-compute-days |
0 |
Range of values {0, 1, 2, 3, 4, 5, 6}. Indices of days when tuning parameters in the promo-prediction should be calculated. The divider is a comma, 0 - Sunday, 6 - Saturday. |
| promo-prediction-tuning-validation-max |
10 |
Maximum number of validation promotions per product locator. |
| promo-analyse-accept-promo-from-move-date-from |
|
The date from which the promo_action_id from the moves will be accepted. Before this date, the promo_action_id will be found automatically. An empty value or a value that is not a date means that the promo_action_id from the moves is not accepted at all (default). |
| promo-prediction-increase-training-action-by-stockout |
1 |
Range of values {0,1}. If it is set to 1, then the lost amount during the training promoaction will be added to its real sale and this sum will be used for prediction. |
| promo-prediction-share-training-copy-enabled |
1 |
Range of values {0, 1}. Default = 1. If it set to 1, then only promo-prediction-share training promotions are copied from promo-prediction. Otherwise, training promotions are calculated separately for promo-prediction and separately for promo-prediction-share. |
| promo-prediction-type |
2 |
Promo prediction type. Range of values {1, 2}. 1 = total amount prediction, 2 = promo increment prediction. |
| promo-prediction-result-backup-enabled |
1 |
Range of values {0, 1}. If it is set to 1, then promo-prediction results are backed up to tthe backup tables. 0 = back up is not realized. |
| promo-prediction-result-backup-days |
14 |
Number of days (in the past) for which we want to back up the results of the promo-prediction to the backup tables. Range of values {0, 1, 2, 3, ...}. |
| promo-prediction-result-backup-months |
12 |
Number of months (in the past) for which we want to back up the results of the promo-prediction to the backup tables. Range of values {0, 1, 2, 3, ...}. |
| promo-analyse-save-full-amount-enabled |
0 |
Range of values {0, 1}. 1 = Enable storing the total sold amount (total baseline) during the promotion in the promo_plid table. If the parameter is not enabled, the sold amounts are redistributed among the overlapping promotions according to the promo_action_id in the promo_sales table. |
| promo-action-group-by |
|
Range of values {"", product_id, c1_id ... }. List of columns according to which we want to group PLIDs. Allowed columns are: product_id, all c_id. Empty string means do not group, i.e., each PLID is in its own group of size 1. |
| promo-product-minimal-sale-days |
60 |
Number of days from the first sale after which the PLID can be identified as promo_product. |
| promo-product-evaluate-months |
0 |
Number of months in which pl.promo_product will be detected. If 0 is specified, the entire history will be used. |
| promo-prediction-bias-correction-enabled |
0 |
Range of values {0, 1}. If it is set to 1, enables the use of bias correction in prediction. 0 (default) = off, 1 = on. if it is set on, also promo-prediction-bias-correction-group-by setting must be set. |
| promo-prediction-bias-correction-group-by |
c1_id |
Range of values {c1_id, c2_id ...}. List of IDs from the locator (separate commas, without spaces), according to which the bias coefficient is aggregated. ! It is necessary to set this value when enabling bias correction! |
| compute-training-promo-actions-enabled |
1 |
Range of values {0, 1}. Enables recalculation of training actions (default 1 = enabled). Practically never turn off, it turns off unnecessary calculations during verification. |
| compute-promo-prediction-share-enabled |
1 |
Range of values {0, 1}. Enables calculation of the prediction share (default 1, on). Practically never turn off, it turns off unnecessary calculations during verification. |
| promo-prediction-2d-output-filter-enabled |
1 |
Enables a "2d" filter of training actions by the output with respect to action length and discount. Assumption is that shorter actions and actions with smaller discount are less effective, therefore higher values are filtered more aggressively then in actions with bigger discounts. Weights are set in the promo_configuration_parameters table. |
| promo-prediction-trimming-bottom-min |
0 |
Minimum number of training samples to be excluded from the calculation of statistics (median, deviation) from the bottom of the population. |
| promo-prediction-trimming-bottom-max |
0 |
Maximum number of training samples to be excluded from the calculation of statistics ( median, deviation) from bottom of the population. |
| promo-prediction-trimming-bottom-percentile |
0 |
Lower percentile of training samples which are excluded from the calculation of statistics (median, deviation). Number of deleted promotions is limited to min <percentile <max. |
| promo-prediction-trimming-top-min |
0 |
Minimum number of training samples to be excluded from the calculation of statistics (median, deviation) from the top of the population. |
| promo-prediction-trimming-top-max |
0 |
Maximum number of training samples to be excluded from the calculation of statistics ( median, deviation) from the top of the population. |
| promo-prediction-trimming-top-percentile |
0 |
Upper percentile of training samples to be excluded from the calculation of statistics (median, deviation). The number of removed promoactions is min <percentile <max. |
| promo-matrix-discount-count |
19 |
Number of different discounts in the promomatic. Default 19. |
| promo-matrix-length-count |
31 |
Number of different lengths in the promomatic. Default 31. |
| promo-prediction-max-amount-history-length |
0 |
Number of historical months from which the max amount will be calculated. If set to 0, the entire history is taken from the forecast_history. Default 0. |
| fast-adapt-max-increase-ratio |
0 |
Value range: <0, ∞). If greater than 0, it limits the maximum effect of the promotion factor to the specified multiple of the original total forecast |
| fast-adapt-running-index-min |
0 |
Value range: <0, ∞). If fast-adapt-distribution-enabled is enabled, the promotion must have a higher cumulative index sum of past days in order to calculate promotional fast adapt. |
| promo-prediction-share-disallow-stock-outs |
0 |
Value range: {0, 1}. If set to 1, promotions with detected lost sales will be excluded from training the promo prediction share |
| promo-prediction-version |
2 |
Promo prediction version. Possible values: 2, 3 |
| promo-history-share-min-index-value |
0.1 |
Value range: (0, 1]. Minimum value of the daily index below which the actual sales are zeroed. If enabled, they will be replaced by the average adjusted sales during the promotion. |
| promo-history-share-average-zero-index |
0 |
Value range: {0, 1}. If enabled, all indices below the value specified in promo-history-share-min-index-value will be replaced by the average adjusted sales during the promotion. |
| batch-promo-prediction-day-part-size |
2000 |
Value range: (0, ∞). Number of PLIDs per thread for calculating the daily forecast in batch-promo-prediction.php. |
| Configuration for batch-pt |
| Name |
PossibleValues |
Description |
| split-header-enabled |
0 |
Range of values {0, 1}. If it is set to 1, then display of the breakdown of the total promo volume in the promotion header is enabled. 0 = disabled. |
| split-row-enabled |
0 |
Range of values {0, 1}. If it is set to 1, then display of the breakdown of the total promo volume in the promotion line is enabled. 0 = disabled. |
| split-period |
0 |
Range of values {0, 1, 2}. Period for the breakdown of the total volume of the promoaction, options: 0 = transitional week, 1 = week, 2 = month. |
| promo-discount-rounding |
2 |
On how many decimal places the resulting promo total discount will be rounded. |
| promo-price-rounding |
2 |
On how many decimal places the resulting promo price will be rounded. |
| promo-discount-switch-condition-enabled |
0 |
Range of values {0, 1}. Displays all discount conditions specified in the discount_condition_type table in the case of a value of 0, otherwise it displays one field for the discount, which is the default value and the rest will be displayed on the + icon, when a selectobox is displayed with the option to add another. |
| promo-discount-multi-condition-discount-enabled |
0 |
Range of values {0, 1}. Enables (1) or disables (0) multi-discount settings for individual products. |
| split-auto-enabled |
0 |
Range of values {0, 1}. Display of automatic split according to the selected scenario if it is set to 1. 0 = nothing is displayed. |
| promo-detail-bonus-enabled |
0 |
Range of values {0, 1}. Enables (1) or disables (0) the display of bonus prices on product details |
| price-nonpromo-discount-enabled |
0 |
Range of values {0, 1}. Enables (1) or disables (0) the calculation of product price discounts. |
| price-nonpromo-bonus-enabled |
0 |
Range of values {0, 1}. Enables (1) or disables (0) the calculation of bonus discounts on product level. |
| promo-discount-multi-condition-bonus-enabled |
0 |
Range of values {0, 1}. Enables (1) or disables (0) multi-bonus settings for individual products. |
| display-concurrent-promotions-enabled |
0 |
Range of values {0, 1}. If it is set to 1, it display competing promotions in the tooltip in the table of products. |
| workflow-v2-enabled |
0 |
Range of values {0, 1}. Enables (1) or disables (0) the workflow system of states version 2. |
| amount-prediction-button-enabled |
0 |
Range of values {0, 1}. If it is set to 1, display of the button for volume calculating in the detail of promotion row is enabled. 0 = disabled. |
| row-list-checkboxes-enabled |
0 |
Range of values {0, 1}. If it is set to 1, then the checkboxes column in the promotion row is displayed. 0 = the checkboxes column is hidden. |
| evaluation-v2-enabled |
1 |
Range of values {0, 1}. Enables (1) or disables (0) evaluation version 2 |
| evaluation-v2-showhide-header |
0 |
Range of values {0, 1}. Enables (1) or disables (0) the display of the evaluation header in the showhide. |
| evaluation-v2-showhide-row |
0 |
Range of values {0, 1}. Enables (1) or disables (0) the display of the evaluation row in the showhide. |
| row-promo-actions-enabled |
0 |
Range of values {0, 1}. 1 = Displays a list of promotions in the product detail (pormoaction row) that are created for the given product. 0 = list of promotion is not displayed. |
| promo-prediction-debug-enabled |
0 |
Range of values {0, 1}. Enables (1) or disables (0) debugging reports in promo-prediction. |
| graph-show-promo-actions |
0 |
Range of values {0, 1}. 1 = Displays a list of promotions in the tooltip in a graph that is on the detail of the promotion row. |
| bulk-actions-enabled |
0 |
Range of values {0, 1}. Enables (1) or disables (0) bulk actions in promotion. |
| load-value-after-auto-save |
0 |
1: For values that are saved via autoSave via ajax, the value is reloaded from the database immediately after saving and displayed on the form. So if we save the text in the numeric db column, the text will not be left in the form, but exactly what will be displayed will be displayed. |
| promotool-promo-copy-enabled |
0 |
Range of values {0, 1}. Enables (1) or disabled (0) promotion copying. |
| amount-user-change-logging |
0 |
Range of values {0, 1}. If it is set to 1 then the date of amount change (amount_promo, amount_base) is saved - only if it was changed by the user in the form. It is stored in amount_promo_user_change and amount_base_user_change. If the value 0 is set then the amount changes by the user is not logged. |
| report-forecast-and-history-enabled |
0 |
Range of values {0, 1}. 1 = Display forecast and history report. 0 = forecast and history report is not displayed. |
| price-nonpromo-bonus-save-as-percent |
0 |
Calculated nonpromo bonus discount in CPromotoolPrice module is saved in percentage or in absolute value? |
| amount-report-button-enabled |
0 |
Range of values {0, 1}. If it is set to 1 then the button for the report of the incorrectly calculated volume in the detail of the promotion line is displayed . If it is set to 0, button is not displayed. |
| amount-progressive |
0 |
Range of values {0, 1}. Turns on (1) continuous drawing of the promotion. Ie. that the real amount for amount_promo is used during the promotion if it is greater than the amount predicted by the user. The original user-predicted amount is stored in user_amount_promo. |
| list-price-aggregation-function |
min |
If several different list prices are selected, how is the right one chosen. Possible values: min, max, avg, sum |
| list-price-date-selection |
date-from-only |
Range of values {date-from-only, date-to-only, date-from-date-to }.date-from-only: select the list price, which is valid on the day of the start of the promotion; date-to-only: similarly, only on the day of the end of the promotion; date-from-date-to: all list price prices that affect the promotion are selected, and the aggregation is used for this. |
| report-evaluation-enabled |
0 |
Range of values {0, 1}. If the value 1 is set, then the evaluation report is displayed. |
| client-filter-use-pt-header-client |
0 |
Range of values {0, 1}. 1 = Enables the filling of the pt_header_client table. |
| product-filter-enabled |
0 |
Range of values {0, 1}. 1 = Turns on the product filter. |
| product-filter-use-clients-products-checkbox |
1 |
Range of values {0, 1}. If it is set the value 1, then in the product filter it displays a checkbox for filtering only those products for which SKUs for the selected customer exist. |
| price-listprice-enabled |
0 |
Range of values {0, 1}. If it is set to 1 then the use of the list_price table when changing SKUs or data in PT (ie also when creating a new row) is enabled. |
| product-list-enabled |
0 |
Range of values {0, 1}. If it is set to 1 then the product list at the promotion is displayed. |
| add-blank-product-locator-enabled |
0 |
Range of values {0, 1}. 1 = If a product should be added to the PT for a customer for which there is no PLID, the Add Blank PLID (SKU) functionality will be used. |
| customer-code-enabled |
0 |
Range of values {0, 1}. If it is set to value 1, then customer code for promoaction is displayed. |
| promo-tm-enabled |
0 |
Range of values {0, 1}. 1 = Allow assignment of TM action to TA. |
| admin-tm-enabled |
0 |
Range of values {0, 1}. 1 = Administration of TM action is allowed. |
| delivery-date-erasable |
1 |
Range of values {0, 1}. 1 = Allows to delete already entered delivery date in promo form. |
| promo-owner-enabled |
0 |
Range of values {0, 1}. 1= Display of owner settings for promoaction. |
| promo-ignore-for-training-enabled |
0 |
Range of values {0, 1}.1 = Display of checkbox with permission of promoignore from learning. |
| row-promo-actions-graph-enabled |
0 |
Range of values {0, 1}. 1 = Displays graph of promo action in product detail (promoaction row), which are created for the product. |
| batch-promo-change-enabled |
0 |
Range of values {0, 1}. 1 = Enables the promotool-batch-promo-change module, which performs automatic promo changes in a batch. |
| promo-coverage-enabled |
0 |
Range of values {0, 1}. 1 = Turns on the possibility to set coverage in the promo form. |
| promo-export-enabled |
0 |
Range of values {0, 1}. 1 = Turns on the possibility to export TA from the form. |
| promo-file-upload-enabled |
0 |
Range of values {0, 1}. 1 = Turns on the possibility to upload files to TA. |
| row-unique-product |
0 |
Range of values {0, 1}. 1 = Each product can be inserted into the promotion only once. |
| promo-row-delivery-date-enabled |
0 |
Range of values {0, 1}. 1 = Turns on the possibility of changing the delivery date for the TA row. |
| price-nonpromo-label-type |
shortcut |
Range of values {shortcut / name / both}. What will be displayed in the tooltip for nonpromo discounts. |
| product-group-enabled |
0 |
Range of values {0, 1}. 1 = Turns on the display of entries for product group. |
| revision-history-show-history-branch-only |
0 |
1: Historical revisions are listed from the current pt_header_id and then back to history according to previosu_id. 0: All revisions active 0 or 1 are. |
| promotool-approval-limits-table |
0 |
Range of values {0, 1}. 1 = Displays the promotool-approval module table, which shows the approval limits and whether they are met or not. |
| promo-discount-auto-recompute-no-negative |
1 |
Range of values {0, 1}. 1 = If ptr_promo is fixed, discount_promo will never be calculated negative. |
| promotool-report-dpa-enabled |
0 |
Range of values {0, 1}. 1 = Enable dpa report display. |
| promotool-dashboard-enabled |
0 |
Enables recalculations of the Promotool dashboard. |
| promo-amount-rounding |
2 |
Number of decimal places to round the final volume to. |
| commercial-costs-split-method |
1 |
Determines the selected split method for commercial costs. Default is 1: evenly distributes the amount based on the number of products. Option 2: distributes the amount proportionally based on the quantity of each product. |
| pidi-import-default-category-type |
2 |
Promotion import settings. The level at which promotions should be imported. |
| pidi-import-enabled |
0 |
Enable the import bridge for Promotool actions. |
| pidi-import-date-to-computation |
|
Set the date for which promotions should be imported from PIDI |
| page-promotion-dashboard-enable |
0 |
Turns on the promotions dashboard page |
| promotool-approval-limits-allow-for-products |
0 |
Enable limits directly for products. |
| promotool-approval-limits-categories |
|
Categories for limits. |
| promotool-approval-limits-direction-loading-limit |
FROM_TOP |
Limit setting direction |
| Configuration for batch-safetystock |
| Name |
PossibleValues |
Description |
| whatif-enabled |
1 |
Range of values {0, 1}. 1 = Toggle whether to calculate data for the whatif-safetystock report and whether to display the report. Valid only in combination with daily variability v2. No additional data needs to be calculated for v1 and the report is always displayed. |
| skip-computation-for-zero-safetystock |
0 |
Range of values {0, 1}. 1 = It completely skips the calculation for PLIDs that have zero_safetystock = 1 and at the same time have only a reflexive relationship in the safetystock_relation. |
| sale-deviation |
1 |
Range of values {0, 1}. 1 = Allows error forecast. |
| safetystock-day-smoothing |
1 |
Range of values {0, 1}. If set to 1, enables smoothing of the difference of the safetystock during the transition between months (manipulated for a total of 20 days - 10 of the current and 10 of the next month). If a daily breakdown (dayshare) is used, overloaded values or promotion SafetyStock are received, this quantity will not be smoothed! |
| rounding-threshold |
0.2 |
Range of values (0, 1). Limit value for rounding safetystock_order, if the next decimal places after safetystock_prerequisites.decimal_places (product_locator.rounding) <= this value, it will be rounded down to decimal_places, otherwise it will be rounded up to decimal_places. Example: key value 0.2, decimal_places 2 - input 0.001 will be rounded to 0, input 0.002 will be rounded to 0.01 |
| purchase-deviation |
0 |
Range of values {0, 1}. 1 = Allows deviation of the purchase amount. |
| part-size |
500 |
Number of calculation units (product-locators) in one computation thread in .NET safetystock calculation. |
| minimal-period-ss |
0 |
Range of values <0, 1>. Minimum period value in months that will be taken when setting lower-safetystock-mode to PERIOD_SS. |
| min-forecast-error |
10 |
Minimum percentage forecast error. 100 = 100%. |
| lower-safetystock-percent |
200 |
Range of values <0, ∞). If it is set to more than 0, safetysotck will be limited to the lower-safetystock-percent percent of the lower-safetystock-mode indicator. |
| lower-safetystock-mode |
MONTH |
Range of values {MONTH, SS_PERIOD}. If it is set to SS_PERIOD, the period will be taken into account when calculating the safetystock limiter (a period of 15 days means that only half of the monthly forecast is taken as the basis for the limiter) before calculating the final value using lower-safetystock-percent, if set to MONTH, the whole monthly forecast will be used. |
| lower-safetystock-before |
2 |
Allowed value: integer. Number of months in the history from which data will be taken for the safetystock limit according to the forecast (can be set to negative, but not more than lower-safetystock-after: value -1 says that it will start 1 month AFTER THE CURRENT OUTLOOK and will be taken until lower-safetystock-after). |
| lower-safetystock-after |
2 |
Allowed value: integer. The number of months into the future from which data will be taken for the safetystock limit according to the forecast (can be set to negative, not more than lower-safetystock-before: the value -1 says that it will be taken from lower-safetystock-before and will end 1 month BEFORE THE CURRENT OUTLOOK). |
| leadtime-deviation |
1 |
Range of values {0, 1}. 1 = Enable leadtime deviation. |
| ignore-sporadic-redistribution |
0 |
Range of values {0, 1}. If it is set to 1, updates safetystock_relation.is_relevant to 0 for all redistributed and sporadic products and thus excludes them from the session. |
| ignore-sporadic-production |
0 |
Range of values {0, 1}. If it is set to 1, updates safetystock_relation.is_relevant to 0 for all manufacturing and sporadic products and thus excludes them from the session. |
| ignore-outliers |
0 |
Default 0. Number if extremes to be ignored when calculating the daily variability (usually 0 or 1). |
| day-variability-season-yes-boundary |
43586 |
Range of values (day -var iability-season-no-boundary, 12>. If the absolute difference between the highest and lowest seasonal index for a product is greater than this value, it will be taken as a seasonal item for use in daily variability. |
| day-variability-season-no-boundary |
0.5 |
Range of values <0, day-variability-season-yes-boundary). If the absolute difference between the highest and lowest seasonal index for a product is less than this value, it will be taken as a non-seasonal item for use in daily variability. |
| day-variability-max-leadtime |
21 |
Maximum lead time lenght in days for daily variability. |
| day-variability-decrease-from-leadtime |
7 |
The minimum lead time lenght in days from which the daily variability begins to be linearly reduced. |
| day-variability-close-months |
3 |
Range of values (0, ∞). Number of months in history to be considered as current daily variability "(obtained from the immediate vicinity)". |
| day-sale-deviation |
1 |
Range of values {0, 1}. 1 = Allow daily variability. |
| actual-day-variability-weight |
0.6 |
Range of values (0, 1). Specifies the ratio between the current (PwDate-3 months) and historical daily variability (3-month floating window) that will be used when calculating the SS (1 = 100% current, 0% historical) |
| ignore-dont-order |
0 |
Whether to exclude PLIDs from the relation that are not being sold (dont_order = 1) |
| ignore-sellout |
1 |
Whether to exclude PLIDs from the relation that are clearance items (sellout_new_product_type_id = 2) |
| day-variability-history-years |
1 |
Range of values (0, ∞). Number of years of history to be used for calculating the daily distribution error. |
| day-variability-maximal-leadtime |
31 |
Range of values <0, ∞). If greater than 0, defines the maximum lead time of an item for which the daily distribution error is calculated. |
| day-variability-positive-residual-ratio |
1 |
Range of values (-∞, ∞). Defines the multiplier of daily error in situations where the expected sales were higher than the actual sales. |
| day-variability-negative-residual-ratio |
1 |
Range of values (-∞, ∞). Defines the multiplier of daily error in situations where the expected sales were lower than the actual sales. |
| day-variability-normalization-zero-level |
1e-6 |
Range of values (-∞, ∞). Specifies the minimum value of daily decomposition for which normalization is allowed; if the decomposition is lower than this value, the day will be zeroed out. |
| day-variability-compute-what-if |
0 |
Range of values {0, 1}. Enables the calculation of underlying data for the "what-if" analysis of daily decomposition error. |
| batch-safetystock-day-part-size |
2000 |
Range of values (0, ∞). Number of PLIDs per thread for calculating daily safety stock in batch-safetystock.php |
| promo-prediction-overlapping |
|
Method of calculating safety stock for overlapping promotions during ordering (default = empty string). The meaning of the settings is the same as in promo-prediction-overlapping. Default empty string = use the setting from promo_configuration.promo-prediction-overlapping |
| promo-safetystock-up-limiter |
0 |
Value range <0; ∞). For 0, the feature is disabled; otherwise, it represents the maximum percentage value of the safety cap against the calculated promotion effect, which will be applied if necessary. |
| promo-safetystock-down-limiter |
0 |
Value range <0; ∞). If set to 0, the feature is disabled; otherwise, it defines the minimum percentage safety threshold against the calculated promotion effect, to which it will be increased if necessary. |
| Configuration for batch-stockout |
| Name |
PossibleValues |
Description |
| enabled |
1 |
Range of values {1, 0}. Enables start of stockout analysis. |
| part-size |
5000 |
Range of values <1, ∞). Specifies the number of PLIDs that will be calculated in one computation thread. |
| max-length |
60 |
Range of values <0, ∞>. If the stockout is longer than this value, the stockout will be automatically deleted- |
| baseline-loss-ratio |
0.9 |
Range (-∞, ∞). Determines how many % of the estimated amount will be calculated as lost sales for regular sales. |
| promo-loss-ratio |
0.9 |
Range of values (-∞, ∞). Determines how many % of the estimated amount will be calculated as lost sales for the promotional Sales. |
| redistribution-loss-ratio |
0.9 |
Range of values (-∞, ∞). Determines how many % of the estimated amount will be calculated as lost sales for redistribution. |
| months-before |
3 |
Range of values <0, ∞). Maximum number of months (v2 counts for this setting * 30 number of days) before the detected stockout, from which the amount will be calculated. The area will be divided into 3 parts in the calculation and the smallest possible satisfying the sale-treshold condition will be used. |
| months-after |
3 |
Range of values <0, ∞). Maximum number of months (v2 counts for this setting * 30 number of days) after the detected stockout from which the elapsed amount will be calculated. The area will be divided into 3 parts in the calculation and the smallest possible condition satisfying the sale-treshold condition will be used. |
| month-weight |
0.5 |
Range of values <0, 1>. Weight of the estimated value of the lost amount calculated from the surrounding values according to the days-before and days-after settings. |
| year-weight |
0.5 |
Range of values <0, 1>. Weight of the estimated value of the lost amount calculated from the stockout period of the previous and next year. |
| sale-threshold |
0.6 |
Range of values <0, 1>. Minimum ratio of days with sales to the total number of days to select a shorter period for the calculation of the lost amount from the surrounding values according to the days-before and days-after settings |
| analyse-report-enabled |
1 |
Range of values {0, 1}. 1 = Enables the stockout evaluation report. |
| ignore-sporadic |
1 |
Field of values {0, 1}. When it is set to 1, it does not calculate stockouts on sporadic items. |
| disable-stockout-masking |
0 |
Domain of values {0, 1}. If set to 1, it disables the masking of periods with stock levels below the corresponding threshold when calculating the average daily lost sales quantity. |
| normalization-zero-level |
1e-6 |
Domain of values <0, ∞). Specifies the threshold index for normalization based on daily distribution (day-share, season-indices, Easter, and Christmas), below which the input sales will be zeroed instead of divided. |
| normalization-index-minimum |
0.1 |
Domain of values <0, ∞). Specifies the minimum index value for normalization based on daily distribution (day-share, season-indices, Easter, and Christmas) by which the input sales can be divided. |
| output-index-maximum |
10 |
Domain of values <0, ∞). Specifies the maximum index value for normalization based on daily distribution (day-share, season-indices, Easter, and Christmas) by which the resulting lost sales can be multiplied. |
| should_compute_stockout_level_by_avg_day_sale |
0 |
Range of values { true, false }. Determines whether the stockout level is recalculated based on average sales in the past or not. |
| stockout_level_avg_day_sale_history_length |
30 |
Range of values { 1, ∞ }. The number of days in the past from which the average daily sales are taken to recalculate the stockout level. |
| stockout_level_avg_day_sale_index |
1 |
Range of values <0, ∞). An index that multiplies average daily sales. |
| Configuration for batch-promo_history |
| Name |
PossibleValues |
Description |
| enabled |
1 |
Range of values {0, 1}. If it is set to 1, allows batch-promo-detection, batch-promo-and-move-pairing, and batch-promo-analyze-v2 to be replaced by a new calculation. |
| part-size |
750 |
Range of values (0, ∞). Number of groups to be calculated in one thread. |
| move-type-sale |
1 |
Range of values: comma-separated list of numbers. Specifies which move_type_id will be loaded from the move table as sales moves. |
| move-type-purchase |
2, 4 |
Scope of values: comma-separated list of numbers. Specifies which move_type_id will be loaded from the move table as purchase movements. |
| promo-amounts-compute-purchased |
0 |
Range of values {0, 1}. If it is set to 1, it allows the calculation of the purchased quantity for the historical promotions. |
| promo-prices-compute-nonpromo-purchase |
0 |
Range of values {0, 1}. If it is set to 1, it allows the calculation of the non-promotional purchase price. |
| promo-prices-compute-promo-purchase |
0 |
Range of values {0, 1}. If it is set to 1, it allows the calculation of the promotional purchase price. |
| promo-prices-compute-nonpromo-sale |
0 |
Range of values {0, 1}. If it is set to 1, it allows the calculation of the non-promotional sales price. |
| promo-prices-compute-promo-sale |
0 |
Range of values {0, 1}. If it is set to 1, it allows the calculation of the promotional sale price. |
| promo-prices-compute-discount |
0 |
Range of values {0, 1}. If it is set to 1, it allows the calculation of the discount from the promotional and non-promotional price. |
| promo-prices-compute-only-null |
0 |
Range of values {0, 1}. If it set to 1, it allows the calculation of the price only if it is empty. |
| promo-prices-default-discount |
0 |
Range of values <0, 1>. The value of the discount that will be assigned to the promotion if it cannot be calculated. |
| pairing-type |
DATE |
Range of values {NONE, DATE, PRICE}. Specifies the type of motion pairing for promotions NONE = pairing is off; DATE = pairs according to the date of movement, priority at overlap - earlier starting - shorter - lowest ID; PRICE = same as DATE, but in addition the price rounded according to the pairing-rounding-precision setting must be matched. |
| pairing-clear-imported |
0 |
Range of values {0, 1}. If it is set to 1, it deletes the promo_action_id imported from the customer on the loaded movements. WARNING! If the pairing-type is NONE it automatically sets to DATE and creates a warning! |
| pairing-rounding-precision |
1 |
Range of values <0, ∞). Number of decimal places to be checked if the pairing-type is set to PRICE. |
| promo-only-plid-enabled |
1 |
Range of values {0, 1}. When it is set to 1, it allows the detection of PLIDs that are only sold as part of the promotion. |
| promo-only-plid-pre-neighborhood-days |
7 |
Range of values <0, ∞). The number of days before the promotion that will count towards the promoaction period for the detection of promo only PLIDs. |
| promo-only-plid-post-neighborhood-days |
7 |
Range of values <0, ∞). The number of days after the promotion that will count towards the promoaction period for the detection of promo only PLIDs. |
| promo-only-plid-set-zero-forecast-and-ss |
1 |
Range of values {0, 1}. If it is set to 1, detected promo only PLIDs, zero_forecast and zero_safetystock will be automatically set to 1. |
| baseline-pre-neighborhood-days |
0 |
Range of values <0, ∞). The number of days before the promotion that will count towards the promoaction period to calculate the baseline. |
| baseline-post-neighborhood-days |
0 |
Range of values <0, ∞). The number of days after the promotion that will count towards the promoaction period to calculate the baseline. |
| baseline-merge-predecessors |
0 |
Range of values {0, 1}. If it is set to 1, the baseline calculation will be "learned" from predecessor and successor data. |
| baseline-merge-top-down |
0 |
Range of values {0, 1}. If it is set to 1, the baseline calculation will be "learned" from the top-down session data. |
| baseline-max-promo-length |
122 |
Range of values <0, ∞). The maximum length of the action that can enter the baseline calculation. |
| promo-only-plid-minimal-sale-days |
60 |
Domain of values <0, ∞). Minimum number of days since the first sale required to identify a PLID as promo only. |
| pairing-price-tolerance |
0 |
Domain of values <0; 1>. Specifies the maximum allowed relative difference between the movement sales price and the promotion price when pairing-type = PRICE_TOLERANCE. |
| pairing-clear-missing |
0 |
Domain of values {0, 1}. If set to 1, it allows the removal of non-existent promo_action_id entries from the move table. |
| pairing-only-defined-promo-moves |
0 |
Domain of values {0, 1}. If set to 1, pairing is enabled only for moves that have unknown promotion specified (-1). |
| Configuration for batch-promo_configurat |
| Name |
PossibleValues |
Description |
| relevant-promo-distance |
1825 |
Maximum relevant (daily) distance between historical promotions and the target promotion in the promo-prediction. Too far-reaching historical promotions are penalized according to the penalty-out-of-distance parameter. The relevant-promo-distance parameter specifies the width of the Gaussian penalty curve. The wider is this curve, the greater deviation is tolerated. |
| relevant-seasonal-distance |
120 |
Maximum relevant season distance between historical promotions and the target promotion in the promo-prediction. Historical off-season promotions are penalized according to the penalty-out-of-season parameter. The relevant-seasonal-distance parameter specifies the width of the Gaussian penalty curve. The wider is this curve, the greater deviation is tolerated. |
| relevant-discount-distance |
0.3 |
The maximum relevant distance between the discounts of historical promotions and the discount of the target promotion in the promo-prediction. Too diferent historical promotion discounts are penalized according to the penalty-out-of-discount parameter. The relevant-discount-distance parameter specifies the width of the Gaussian penalty curve. The wider is this curve, the greater deviation is tolerated. |
| relevant-length-ratio |
43955 |
The maximum relevant ratio between the lengths of historical promotions and the length of the target promotion in promo-prediction. Historical promotions with too different lengths are penalized according to the penalty-out-of-length parameter. The relevant-length-distance parameter specifies the width of the Gaussian penalty curve. The wider is this curve, the greater deviation is tolerated. |
| penalty-out-of-distance |
0.2 |
Range of values the interval <0, 1>, with a penalty in the worst (limit) case. Penalty of the historical promotion, which is located too far in relation to the target promotion in the promo-prediction. The smaller is this penalty, the stronger is the penalty of the resulting weight. |
| penalty-out-of-season |
0.2 |
Range of values the interval <0, 1>, with a penalty in the worst (limit) case. Penalty of the historical promotion, which is located out of season due to the target promotion in the promo-prediction. The smaller is this penalty, the stronger ia the penalty of the resulting weight. |
| penalty-out-of-discount |
0.1 |
Range of values the interval <0, 1>, with a penalty in the worst (limit) case. Penalty of the historical promotion, the discount of which is too different from the discount of the target promotion in the promo-prediction. The smaller this penalty, the stronger the penalty of the resulting weight. |
| penalty-out-of-length |
0.1 |
Range of values the interval <0, 1>, with a penalty in the worst (limit) case. Penalty of the historical promotion, the length of which is too different from the length of the target promotion in the promo-prediction. The smaller is this penalty, the stronger is the penalty of the resulting weight. |
| penalty-next-level |
0.8 |
Range of values the interval <0, 1>, with a penalty for each higher level. Penalty the weight of the historical promotion for each higher level in the hierarchy of categories in the promo-prediction. The smaller is this penalty, the stronger is the penalty of the resulting weight. |
| penalty-promo-type |
0.1 |
Range of values the interval <0, 1>, being penalized only if the promo_type_id of the training promotion differs from the promo_type_id of the target promotion.Penalty the weight of the historical promotion for a different promotion_type_id in the promotion. The smaller is this penalty, the stronger is the penalty of the resulting weight. |
| penalty-attribute |
0.5 |
Range of values the interval <0, 1>, being penalized only if the attribute of the training promotion differs from the attribute of the target promotion. Penalty the weight of the historical promotion for each different attribute (leaflet, secondary_placement, etc.) during the promotion. The smaller is this penalty, the stronger is the penalty of the resulting weight. |
| secondary-discount-weight |
0 |
Range of values the interval <0, 1>. Default weight for the secondary discount of the promotion. Used if secondary_discount_weight = NULL is in the target promotion. |
| promo-cannibalization-min-ratio |
0.25 |
Minimum allowed factor of sales reduction due to cannibalization. |
| promo-cannibalization-combine-coefficient |
0.65 |
Coefficient in the interval <0.5, 1.0>., which determines the strength of the cannibalizing effect of several simultaneously acting promotions. |
| penalty-product |
0.8 |
Range of values the interval <0, 1>, being penalized only if the product_id of the training promotion differs from the product_id of the target promotion. Penalize the weight of the historical promotion for a different product_id in the promotion. The smaller is this penalty, the stronger is the penalty of the resulting weight. |
| secondary-length-weight |
0 |
Range of values the interval <0, 1>. Default weight for the secondary length of the promotion. Used if secondary_length_weight = NULL in the target promotion. |
| filter-heavy-weight-threshold |
0.5 |
Percentage threshold that determines the minimum weight of high-weight training promotions. The threshold is always related to the toughest training promotion. |
| filter-heavy-weight-count-min |
1 |
The minimum number of high-weight training promotions that must remain in the training sample after the extremes have been filtered out. |
| filter-heavy-weight-count-threshold |
0.5 |
The minimum percentage of high-weight training promotions that must remain in the training sample after the extremes have been filtered out. The threshold refers to the total number of high-weight training promotions. |
| filter-quantile-up |
43953 |
Quantile for filtering high extremes in promo-prediction. The higher is this quantile, the higher extremes are allowed, ie. the weaker filter. |
| filter-quantile-down |
2 |
Quantile for filtering low extremes in promo-prediction. The higher is this quantile, the lower extremes are allowed, ie. the weaker filter. |
| filter-enabled |
1 |
Range of values {0, 1}. Enable (=1) extreme filtering in promo-prediction. |
| filter-zeros-enabled |
1 |
Range of values {0, 1}. Enable (=1) filtering of zero-effect training promotions in the promo-prediction. |
| filter-heavy-weight-enabled |
1 |
Range of values {0, 1}. Allowing (=1) the inclusion of high-mass training promotions in filtering extremes in the promotion. |
| percentile-model-enabled |
0 |
Range of values {0, 1}. Permission (=1) to use the 50% percentile prefix instead of the origin length of the promotion. |
| filter-target-promoaction-enabled |
1 |
Range of values {0, 1}. Enable (=1) filtering of the target promotion from a set of training promotions. |
| filter-future-promoaction-enabled |
0 |
Range of values {0, 1}. Enable (=1) filtering of training promotions that are older than the target promotion. |
| filter-quantile-up-2d |
1.5,2.5,2.5,3.5 |
Quantile values for 2d high extremum filter (depending on head / length), values are for head / length normalized to the interval 0-1 in points: [0,0], [0,1], [1,0], [ 1.1]. The other values are calculated by bilinear interpolation. |
| filter-quantile-down-2d |
3.5,2.5,2.5,1.5 |
Quantile values for 2d low extremum filter (depending on head / length), values are for head / length normalized to the interval 0-1 in points: [0,0], [0,1], [1,0], [ 1.1]. The other values are calculated by bilinear interpolation. |
| penalty-holiday |
0.8 |
Domain of values <0; 1>. Penalty weight for differing values of the "holiday" attribute. |