📥 Import external forecasts or budgets at an aggregated level

The Data import wizard detects when your file does not include every field in your forecast granularity and lets you confirm an aggregated import.
​

Use this option when each row in your file represents a group of forecast elements rather than one individual element.

For example, your forecasts may be defined by Part number × Location, while your file identifies a Location but does not include a Part number. The imported value must then be distributed among the part numbers at that location.

SKU Science distributes an aggregated value among the matching elements according to their shares of the current consensus forecast for the relevant period.
​

For example, suppose you import a value of 1 000 for a location. If Part 1 accounts for 60% of the forecast period at that location and Part 2 accounts for 40%, SKU Science allocates:

Aggregated imports are available for external forecasts and budgets in the Data upload wizard. This behavior does not apply to demand or orders imports.
​

If a product with “Baseline to 0” enabled is included in an imported aggregated forecast, it inherits a share of that forecast. Its adjustment line automatically shows 0.

If you have questions about your import, contact us through the messenger in the bottom-right corner of the screen.