When we calculate your forecasted sales, settings can be enabled to adjust your forecast based on stockouts during a specific period of time.

Stockouts = the number of days when a product is out of stock.

Inventory Planner automatically detects when a product is out of stock starting from the moment you connect your store to Inventory Planner. This data helps to estimate the demand correctly.

For example: if you sell on average 10 units of Variant A per month and the product is out of stock for 1/2 of the month - the real demand for that month is 20 units. Without taking stockouts into account, the forecasted demand could be too low.

By default, your account is set to take into account stockouts. If your store allows overselling (continuing to sell an item even when it is out of stock), then you should change this setting to disregard out-of-stock information.

Inventory Planner cannot import stock history from your platform, so stock-related information starts with the account start date. Past stockouts can be imported however using the steps in this article (or see below).

You can enable or disable "Adjust forecast using stockout data" for all items in your account under Account > Settings 

> Forecast - then uncheck the box for Adjust Forecast using Out of Stock Information.

This should be done if you allow customers to order even when a product is out of stock. You can also set this on the SKU level instead of the store level if needed under custom forecast settings (under 'Details' for any item, or using Bulk Actions whenever item(s) are selected).


ADJUST PAST STOCKOUTS DATA

Past stockout data can be adjusted for a single item at a time, or for multiple items at once using a CSV import.

To adjust past stockouts for a single item, select the "i" icon under the 'Details' column for a specific item:


> Replenishment & Forecast

> Toggle to 'Past Sales' in the 'Edit Forecast' table at the bottom.


IMPORT PAST STOCKOUTS

If you have stockout history or stock level history available from another program, you can import that information into your Inventory Planner account. This can help to produce a more accurate forecast more quickly. 

Note: importing stockout or stock level history does not adjust the stored stock history, only the number of stockouts.

Inventory Planner takes into account stockouts when calculating the forecast and replenishment recommendations. Read more about how the forecast is calculated here.

Importing Stockout History

Note: importing stockout history does not adjust the stored stock history, only the number of stockouts.

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 when stockouts occurred using 'mm/yyyy' format, for example 1/2019.  
  • Number of stockouts during that month. Each day when the item was out of stock will count as a stockout.

Go to Replenishment > Import > Stockouts.

Click Select File and then select the spreadsheet you've created with stockout history.

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.

Importing Stock Level History

Note: importing stock level history does not adjust the stored stock history, only the number of stockouts.

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. 
  • Date using 'dd/mm/yyyy' format, for example 31/1/2019.  
  • Stock level for the corresponding date.

Go to Replenishment > Import > Stockouts.

Click Select File and then select the spreadsheet you've created with stock level history.

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?