Skip to main content

Forecast Administration

The Forecast Admin section provides tools for configuring how forecasts are generated, managing bulk data, and controlling forecast versions. These settings significantly impact forecast quality.
Forecast Administration is restricted to Admin users.

Accessing Forecast Admin

Navigate to Demand ForecastAdmin (or through the settings menu).

Admin Tabs

The Forecast Admin page has multiple tabs:
TabPurpose
SettingsModel selection and configuration
UploadBulk forecast data imports
VersioningManage forecast versions

Model Selection

Available Models

Tether may offer multiple forecast models:
ModelDescriptionBest For
Moving AverageAverage of recent periodsStable demand
Exponential SmoothingWeighted recent dataTrending products
Seasonal DecompositionCaptures seasonalitySeasonal products
Machine LearningAI-based predictionsComplex patterns
ConsensusCombination of modelsGeneral use

Selecting a Model

1

Go to Settings Tab

Open the Settings tab in Forecast Admin
2

View Current Model

See which model is currently selected
3

Select New Model

Choose a different model from the options
4

Configure Parameters

Adjust model-specific settings (if available)
5

Save

Apply the new model selection

Model Parameters

Some models have configurable parameters: Moving Average:
  • Number of periods to average
  • Weighting (equal or weighted)
Exponential Smoothing:
  • Smoothing factor (alpha)
  • Trend factor (beta)
  • Seasonal factor (gamma)
Machine Learning:
  • Feature selection
  • Training period
  • Update frequency

Forecast Settings

General Settings

SettingDescription
Forecast HorizonHow far ahead to forecast
Update FrequencyHow often forecasts regenerate
GranularityDaily, weekly, or monthly
Default ChannelChannel for new SKUs

Threshold Settings

Configure alerts and indicators:
SettingDescription
Accuracy ThresholdAlert if accuracy drops below
Change ThresholdHighlight changes above X%
Confidence IntervalDisplay range (e.g., 95%)

Bulk Upload

Upload Tab

The Upload tab allows importing forecast data in bulk.

Upload Process

1

Download Template

Click Download Template to get the correct format
2

Prepare Data

Fill in the template with forecast values:
  • SKU code (required)
  • Channel (required)
  • Period (required)
  • Forecast quantity (required)
3

Upload File

Click Upload and select your file
4

Preview

Review the preview of changes:
  • New forecasts to be added
  • Existing forecasts to be updated
  • Errors to resolve
5

Confirm

Click Apply to import the forecasts

Template Format

ColumnRequiredDescription
sku_codeYesSKU identifier
channel_id or channel_nameYesSales channel
period_dateYesDate in YYYY-MM-DD or YYYY-MM
quantityYesForecast quantity
notesNoOptional notes

Upload Validation

The system validates:
  • SKU codes exist
  • Channels exist
  • Dates are in valid range
  • Quantities are numeric and positive
Invalid rows are rejected. Fix errors and re-upload, or proceed with valid rows only.

Upload History

View past uploads:
  • Upload date and time
  • User who uploaded
  • File name
  • Record count
  • Status (success, partial, failed)

Versioning

What is Forecast Versioning?

Versioning maintains historical snapshots of forecasts:
Version TypeDescription
CurrentActive forecast being used
HistoricalPast versions for comparison
DraftWork-in-progress (not active)

Versioning Tab

The Versioning tab shows:
  • List of forecast versions
  • Version dates and descriptions
  • Actions (view, restore, compare)

Creating a Version

1

Go to Versioning Tab

Open the Versioning tab
2

Click Create Version

Start a new version snapshot
3

Add Details

  • Name: “Q1 2024 Plan”
  • Description: Reason for version
4

Save

Version is created and stored

Comparing Versions

Compare forecast versions:
  1. Select two versions
  2. Click Compare
  3. View differences by SKU/channel/period

Restoring a Version

To revert to a previous version:
1

Select Version

Click on the version to restore
2

Click Restore

Choose Restore action
3

Confirm

Review what will change and confirm
4

Version Active

Selected version becomes current
Restoring a version replaces the current forecast. Consider creating a version of the current state first.

Forecast Regeneration

When Forecasts Regenerate

Forecasts typically regenerate:
  • On a scheduled basis (daily, weekly)
  • When model settings change
  • When historical data is updated
  • On manual trigger

Manual Regeneration

To trigger a forecast update:
1

Go to Settings

Open Forecast Admin Settings
2

Click Regenerate

Find the Regenerate Forecasts button
3

Select Scope

Choose what to regenerate:
  • All forecasts
  • Specific channels
  • Specific collections
4

Confirm

Start the regeneration process
5

Monitor

Track progress and completion
Regeneration may take time for large datasets. User edits are typically preserved unless specifically overwritten.

Data Quality

Monitoring Data Quality

Good forecasts require good data:
Quality IssueImpactSolution
Missing historyInaccurate baselineImport historical data
OutliersDistorted patternsClean or flag anomalies
GapsIncomplete patternsFill or interpolate
Late dataDelayed updatesImprove sync timing

Data Quality Indicators

Watch for warnings about:
  • SKUs with no history
  • Channels with sparse data
  • Products with high variability
  • Recent data gaps

Best Practices

Choose models carefully:
  • Start with simpler models
  • Compare performance before switching
  • Consider product segments
  • Document selection rationale
Keep forecasts current:
  • Ensure regular regeneration
  • Monitor data freshness
  • Review model performance
Use versioning effectively:
  • Create versions before major changes
  • Name versions descriptively
  • Compare versions during planning
Handle bulk uploads with care:
  • Validate data before upload
  • Preview changes
  • Keep backup of current state
  • Document upload purpose

Troubleshooting

Forecasts Not Updating

Possible causes:
  • Regeneration not scheduled
  • Processing error
  • Data sync issues
Solutions:
  1. Check regeneration schedule
  2. Trigger manual regeneration
  3. Review system logs
  4. Verify data sources

Upload Errors

Common issues:
  • Wrong file format
  • Invalid SKU codes
  • Date format problems
Solutions:
  1. Use the provided template
  2. Verify SKU codes exist in system
  3. Use standard date formats
  4. Check for special characters

Next Steps