Documentation

Recently Out of Stock with Sales

This report lets you see items that are selling, but have recently gone out of stock. Find the items that need to be reordered now.

  • Role

    Inventory Manager

  • Job

    Increase Inventory Turns

  • Recommended Use

    Daily

Benefits to You:

Smarter Purchasing
  • Re-order the out of stock items that have been selling. Make sure you have stock on hand to meet customers’ demands.
Increased Profits
  • Customers can’t buy things you don’t carry. Recognize the items that customers are likely to buy, and make sure they’re available in the future.
Increase Customer Lifetime Value
  • Keep customers happy by staying in stock on the products they expect you to have.
  • Build new customers: happy customers tell friends about the products they bought and where they bought them. These friends may come in to buy this same thing. Make sure you’re carrying it.

How it's calculated:

(Uses a Per Store Metric: Items will appear on this list if they meet the criteria for any of your stores.)

Days since an item was last sold = 14.
  • The item has sold within the last two weeks.
Current quantity on hand = 0. Time Stamp for Recent Sales = last 3 months.
  • The Quantity Sold column shows you the last 3 months of sales.

Available Variations:

By Manufacturer
  • The default report but grouped by manufacturer, so you can see if a particular brand has a lot of recently out of stock products.
By Top Category
  • The default report but grouped by top level category, so you can compare which segment of your inventory has the most recently out of stock products.
By Vendor
  • The default report but grouped by default vendor, so you can see if a particular vendor has a lot of recently out of stock products.
By Price
  • Default report, but sorted by the added column "Item Metrics: Price", so you can see which high-priced items have recently gone out of stock.
By Reorder Point
  • Default report with an added measure of "Reorder Point", so you can compare your recent sales with the item's current reorder point, and determine whether the reorder point should be adjusted.

Next Steps:

  • Order more stock
    • Use the Quantity Sold Column to guide how much to order.
  • Adjust Reorder Points and Desired Inventory Levels in Lightspeed
    • Add these columns to check current levels