Inventory Risk Exposed by Sales Data

A simple inventory count combined with sales velocity can reveal a lot about product demand, order planning, and even how much investment sits idle on warehouse shelves. In June 2026, for example, U.S. retailers collectively held merchandise equal to about 1.23 months of sales, according to the Federal Reserve Bank of St. Louis. Thus an online shop averaging $50,000 per month in sales might have roughly $61,500 worth of inventory at cost.

Too little inventory can dampen sales, while too much can tie up capital and add storage, handling, and markdown expense. Sales velocity is the number of units sold per day, week, or similar. Consider two products that each generated $10,000 in monthly sales. The first costs $500 and sold 20 units. The second costs $25 and sold 400 units.

The revenue is the same, but the $25 item moves 20 times faster. It needs more frequent replenishment, risks selling out, and requires more effort to keep it available. Tracking sales velocity is useful to compare products over time. The calculation is simple. Choose a period, count the units sold, and divide by the number of units of time in that period.

Calculating Sales Velocity

For a period of days: Sales velocity = Units sold ÷ Number of days. If an online shop sold 84 units of a given product during the past 28 days, the sales velocity would be three units per day. In a sense, velocity becomes a product-specific performance indicator, regardless of price or total revenue.

The period in view affects volatility. A shorter period, such as seven days, shows demand changes, while a 28- or 90-day period smooths out temporary spikes. Seasonal merchants may also want to compare the current period with the same timeframe a year earlier. Merchants may already have access to sales velocity without knowing it.

Accessing Sales Velocity Data

Shopify, for example, calls the metric “Quantity sold per day” in its reporting. Shopify also reports “Days of inventory remaining,” combining units sold per day with inventory on hand to estimate how long current stock might last. Other ecommerce platforms may use different terms. Look for reports covering units sold over time, product performance, sell-through, inventory turnover, or days of inventory remaining.

Or the store owner or manager can export orders and inventory by product to calculate velocity. Sales velocity helps with purchasing and merchandising inventory. For example, if 60 units remain in inventory at an estimated sales velocity of three units per day, the shop has a 20-day supply. Twenty days of inventory might be comfortable if replenishment takes a week, or a warning if a supplier needs 30 days to deliver.

Using Sales Velocity to Examine Trends

A product gaining momentum may need another purchase order. A slowing item may need a promotion, bundle, price change, or simply less inventory. Sales velocity also helps examine trends. Imagine a product selling five units per day during the past week, three per day during the past 28 days, and two per day during the past 90. The current velocity is five units per day, but the more important observation is that sales are accelerating.

That acceleration could represent seasonal demand, a successful promotion, an emerging bestseller, or inventory stockouts faster than expected. Similarly, an item selling five units per day over 90 days but only one per day this week may be losing momentum. Shops with few products in the catalog can monitor seven-, 28-, and 90-day velocity for each item.

Stores with large catalogs might set up automated alerts to sound the alarm when a product is trending. Thanks to AI, trend watching requires little effort. ChatGPT, Gemini, Claude, and related tools can support recurring tasks or workflows. Given access to current order and inventory data, an AI task could run daily, comparing per-item sales velocity for the past seven, 28, and 90 days.

The automation could identify products accelerating or slowing significantly and compare those trends with inventory on hand. Rather than producing a massive daily report, it could alert the store owner or manager only when something requires attention. Depending on the workflow, those alerts might arrive via email, Slack, text, or another messaging service.

In effect, AI can turn sales velocity into an automated system for purchasing and merchandising inventory.