Reports
      Back to home
      1. SellerActive Support
      2. Reports

      Low Stock Report

      This guide walks you through the key features of the Low Stock Report, the setup and common workflows to help you optimize your inventory decisions.

      The Low Stock Report is designed to help you manage your inventory effectively by providing insights into stock levels, sales velocity, and forecasted demand. This guide walks you through the key features of the Low Stock Report, the setup and common workflows to help you optimize your inventory decisions.

      Accessing the Low Stock Report

      To access the Low Stock Report in SellerActive you must have at least one sales channel integrated with order ingestion on.

      1. Log in to your SellerActive account.
      2. Navigate to the Low Stock section from the left-hand menu inside of Reports.

      Overview

      Low Stock
      The Low Stock Report is powered by forecast settings which allow you to tailor the report to your business. The forecast settings can be accessed by clicking the gear to the right of the title on the Low Stock Report or by selecting Forecast Settings under Settings in the left hand menu. These settings can be changed at any time and the Low Stock Report will update to reflect the change.
      Forecast

      The three primary settings are: 

      • Lead Time to Ship: This value, in days, represents the amount of time it typically takes for inventory to reach your warehouses/fulfillment centers and become available for sale. This value is used in the report to ensure you always have sufficient stock to cover the replenishment time for new inventory.
      • Target Days of Coverage: this value, in days, represents the ideal number of days of stock you would like to keep inventory on hand. Restocking suggestions will be based on getting inventory to your fulfillment centers before your inventory falls below the Target Days of Coverage.
      • Velocity Weights: The low stock report determines sales velocity by looking at sales over periods of time when the products were in stock and available for sale.  By default the report will use the last 7 days of in-stock sales. The velocity weights allow you to adjust how each time period impacts the sales velocity calculation.

      The Low Stock Report itself can be viewed across all of your warehouses and fulfillment centers or you can view the report for a specific one by choosing the warehouse tab at the top of the report


      Forecast


      Each column in the report is calculated based on sales that have been routed to the particular warehouse that has been chosen to help you make inventory decisions for that warehouse or fulfillment center.

      • Total Quantity: The total stock for a SKU, including any inbound inventory.
      • Inbound Quantity: For FBA sellers, this represents inventory currently en route to a warehouse, including transfers between warehouses. 
      • Stock Status: A measure of inventory health; action is needed if stock is low or out of stock.
      • Velocity: The average number of units sold per day, calculated using velocity weights.
      • Sales Trend: A week-over-week comparison showing how sales are changing.
      • Days of Stock: The estimated number of days inventory will last at the current sales velocity.
      • Revenue at Risk: The potential revenue loss if restocking doesn't occur by the latest reorder date.
      • Reorder Amount (Today): The quantity to reorder today to maintain the target days of coverage.
      • Suggested Reorder Amount: The quantity to reorder at the Suggested Reorder Date to maintain the target days of coverage.
      • Suggested Reorder Date: The recommended reorder date to maintain the target days of coverage.
      • Last Reorder Date: The latest possible date to reorder before a stockout occurs.
      • Last Reorder Amount: The quantity needed to avoid a stockout and replenish inventory to the target days of coverage.

      There are additional columns that can be added to the report by using the column selector above the grid.

      Best Practices

      1. Sort or filter by Revenue at Risk to determine which products are getting critically low and in need of re-stocking.
      2. To avoid stock-outs, review the Low Stock Report at least as often as your Lead Time to Ship days. 
      3. Use sales velocity trends to anticipate demand and adjust purchase orders, sales or product prices.
      4. Regularly review the Days of Coverage metric to maintain optimal stock levels.
      5. Utilize warehouse filtering for location-specific insights.