Role: Inventory manager.
Job: Increase inventory turns recommended.
The Recently Out of Stock with Sales report allows you to see items that are selling but have recently gone out of stock. As a result, you can find the items that need to be reordered now.
- Re-order your out of stock items that have been selling.
- Make sure you have stock on hand to meet customers’ demands.
- 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.
Increases your customer lifetime value:
- Keep customers happy by staying in stock on the items they expect you to have.
- Build new customers by making sure you’re well-stocked. Happy customers tell friends about the items they bought and where they bought them. These friends may come in to your store to buy the same things.
The report uses a Per Store Metric which lists items if they meet the criteria for any of your stores.
Days Since Sold:
- By default, the filter is set to less than 14 to identify which items have sold within the last two weeks.
Quantity on Hand:
- By default, the filter is set to 0.
Time Stamp Date:
- By default, the filter is set to in the past 3 months. This means the Sale Line Quantity Sold column is showing you the last 3 months of sales.
Turbocharge your report
Find entire segments of your inventory that continually run out of stock:
- Replace the Item Description dimension with the Category, Department, Default Vendor or Manufacturer dimension to see which segments have the hardest time staying in stock.
- Filter by the Category, Department, Default Vendor or Manufacturer dimension to narrow the list to a specific segment.
Prioritize your reorders based on sales value:
- Add the Price dimension and sort by the Price column to identify high value items.
- Sort by Sale Line Quantity Sold column to see the items with the greatest sales volume.
Maximize your existing purchase orders:
- Filter by a Default Vendor to make sure your out of stock items are included on a purchase order you are building.
Adjust your reorder points based on sales data:
- Add Reorder Points and Desired Inventory Levels as measures on this report and compare them to the Sale Line Quantity Sold. Make sure your desired inventory levels complement your sales and adjust them if necessary.
- Order more stock by using the Sale Line Quantity Sold Column as a guide.
- Adjust your items' Reorder Points and Desired Inventory Levels in your Lightspeed Retail account. Use the Quick Edits section for bulk item updates. You can also export your inventory, format your spreadsheet and submit it to our Imports team.
NOTE: You can add the Reorder Points and Desired Inventory Levels filters to your report to check current levels.