Inventory Planner tracks the history of stockouts (days when a variant is out of stock) starting with the date you create your Inventory Planner account. Stockout history prior to that date is not available.

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?