Keep track of items that often go out of stock with new default Missed items sold and Estimated items sold measures added to the inventory replenishment report. These measures can help you plan your ordering and gauge what inventory you’ll need for busy periods.

You can use these measures to:

• Identify and understand periods when products go out of stock.
• Ensure you have the right amount of stock during busy periods.
• Minimize manual estimations and get a clear picture of your sales potential.

These measures are best used for items that sell consistently, have historical data to pull from, and time frames that allow for a large data set. Products that sell infrequently and special order items are less ideal for this feature because there isn’t enough data to support an accurate recommendation.

The use of this forecasting tool is at the user’s own risk. Lightspeed cannot guarantee the accuracy and reliability of the forecasts generated. Actual results may differ. The tool is provided for informational purposes only and should not be considered as financial, investment, or legal advice. Users are encouraged to exercise caution before making business decisions based on the tool’s output.

To access these measures, navigate to Reporting > Inventory reports and click on the Replenishment tab. These metrics will be added to the report by default, but can be added to other inventory reports to suit your needs.

Missed items sold

This default measure shows the number of potential sales of an item that were missed during the date range selected. This number is calculated by taking the items sold per day only when items were in stock and multiplying it by the number of selling days the item was out of stock during the period.

For example, if an item is in stock and sells well during the weekdays but by the weekend has sold out, this measure will show the potential sales that could have been made on the weekend days had there been stock to sell.

Click the information icon beside the number to view details.

Estimated items sold

This default measure adds the Items sold and the Missed items sold columns to calculate the total Estimated items sold for the time period selected. This shows a total of potential and actual sales combined, giving you an idea of what your sales could have been had the item been in stock. This lets you plan for future busy periods as well as adjust your order numbers to anticipate increased sales.

Adding and removing measures

The out of stock measures are added by default to the replenishment report but can be removed if they are not needed. They can also be added to other inventory reports as optional metrics.

To hide or show stockout measures:

1. Navigate to Reporting > Inventory reports.
2. Select an inventory report from the tabs.
3. Click the + (plus) sign at the end of the report columns.
4. Click the checkbox beside the measures you wish to add or remove.

   

5. Click Update report.
6. To save your customized columns, click Save report.

For detailed instructions on creating and managing saved reports, refer to our Saving customized reports article.

What's next?