The automatic forecast is based on the historical sales and is recomputed by Inventory Planner every day. Sometimes it makes sense to manually override the automatic forecast to more closely align it with your plans. It can be especially useful in the following situations:  

  1. You are planning a marketing campaign or other changes to your business and projections based only on past sales are not reliable enough.
  2. You are planning purchases and would like to review the forecast first and fix it. Once the forecast has been fixed for a period, it stops recomputing every day. This allows you to postpone creation of purchase orders
  3. You are receiving new products and would like to manually enter the initial demand for them.

Edit Forecast Screen

You can edit the forecast in three ways: 

  • Directly on the Edit Forecast screen to change units forecast to be sold or change the forecast by a percentage
  • Using Bulk Actions to increase the forecast by a percentage
  • By importing a forecast override to change units forecast to be sold or change the forecast by a percentage

Change forecast on Edit Forecast page

To override the forecast in the Edit Forecast screen, check actual sales and edit the forecast override accordingly.

Entering the forecast override updates the planned sales (used for replenishment recommendations). 

You can also specify the forecast percentage increase which is applied for the forecast override (if set) or for the automated forecast. The final result is shown in planned sales. 

Bulk changes to forecast percentage

To make changes in bulk, select some products using checkboxes on the left. 

Then use the Bulk Actions menu. It allows you to apply same action to a group of products:

  • recompute the automatic forecast
  • clear the forecast override
  • add/remove the percentage increase
  • enable/disable the seasonality
  • adjust (or do not adjust) the forecast using stockout data

Top-Down tabs allow to check and review the aggregated forecast for products, categories, vendors, and the entire store. This forecast can be overwritten and reconciled with variants. Enter your forecast override in units then save changes to update the forecast override for variants from the aggregated forecast using automatic forecast distribution. 

For example you have two products in a category. The automatic forecast for these products is 10 and 20 units for December. The bottom-up forecast for the category is 30 units (10 + 20). When you override the top-level forecast to 60 (+100%) and save changes to variants it makes it 20 and 40 respectively. 

Replenishment Screen

Forecasts can also be edited in the Replenishment screen by clicking the icon under Details for any item, then clicking the Replenishment & Edit Forecast tab.


To make changes in bulk, select some products using checkboxes on the left. 

Then use the Bulk Actions menu. It allows to apply same action to a group of products:

  • recompute the forecast calculation
  • clear a forecast override
  • add/remove the percentage increase
  • set custom forecast settings including seasonality and consideration of stockouts when calculating the forecast

Importing Forecast Overrides

Create a spreadsheet with the following information and including a column title for each:

  • SKU or other identifier such as Title, ID (used by your sales platform), Inventory Planner ID, Vendor Reference, or Barcode. 
  • Month you are overriding the forecast using 'mm/yyyy' format, for example 01/2019.  
  • Forecast Override for that month.

To import forecast overrides select Import > Forecast Override,

Click Select File and then select the spreadsheet you've created with forecast overrides,


In the import dialog, be sure to select the correct identifier. SKU will be the identifier used by default. When all fields are matched to the corresponding field in Inventory Planner, select Upload.

Did this answer your question?