Stop Reordering These Products: What a 365-Day Shelf Review Reveals

Why Liquor Store Owners Should Run a Shelf Review Report

One of the most expensive problems in a liquor store is inventory that sits on the shelf but does not sell.

At first glance, dead stock may not feel urgent. The bottles are already paid for.

They are sitting on the shelf. They are not causing an obvious daily problem.

But slow-moving inventory quietly ties up cash, takes up valuable shelf space, and prevents the store from reinvesting in products customers actually want.

That is why Liquor Bee POS includes a Shelf Review report.

What Is the Shelf Review Report?

The Shelf Review page helps liquor store owners and managers identify items that are slow-moving, stagnant, or not selling at all.

The report allows the user to choose a lookback period, such as 90 days, 180 days, or 365 days, then analyzes item movement across that time period.

For each product, the report shows:

• Item name

• SKU

• Quantity on hand

• Total units sold

• Total units received

• Average daily sales

• Estimated days of supply remaining

• Sell-through percentage

Instead of guessing which products are hurting the store, the owner can review actual sales velocity and inventory data.

Why Run a 365-Day Sales Report?

A 365-day view is especially useful because it removes short-term noise.

Some products may not sell every week, but they still perform well seasonally.

Others may look acceptable during a short window but barely move over the course of a full year.

A 365-day Shelf Review helps answer important questions:

• Did this product sell at all in the last year?

• How much inventory is still sitting on the shelf?

• How fast does this item actually move?

• Did we receive more than we sold?

• Is this product worth reordering?

• Should this item be discounted, moved, or removed?

For liquor stores with hundreds or thousands of SKUs, this type of report can uncover thousands of dollars in trapped inventory.

Key Metrics Liquor Store Owners Should Watch

Quantity On Hand

This shows how many units are currently in inventory.

A high on-hand quantity is not always bad. But if the item has low sales, it may be tying up cash that could be used on faster-moving products.

Total Sold

This shows how many units sold during the selected lookback period.

If a product sold zero units in 365 days, it is dead stock.

If it sold only a few units in a full year, it may be a very slow mover.

Total Received

This shows how many units were brought into the store during the same period.

This is important because some stores continue buying products that are not selling. If the store received 24 bottles but only sold 3, that is a clear purchasing problem.

Average Daily Sales

Average daily sales shows how quickly an item moves.

This helps owners separate fast-moving products from products that only appear important because they have been sitting on the shelf for a long time.

Days of Supply Remaining

Days of supply estimates how long the current inventory will last based on recent sales velocity.

If a product has 300, 500, or 1,000+ days of supply remaining, the store likely has too much inventory.

If the report shows infinite days of supply, that usually means the item has inventory on hand but no sales activity.

Sell-Through Percentage

Sell-through percentage compares how much inventory sold compared to how much was available.

Low sell-through is one of the clearest signs that a product is underperforming.

In the Shelf Review report, items are visually flagged as:

• Dead stock

• Very slow-moving

• Slow-moving

• Acceptable

This makes it easy for managers to quickly identify products that need attention.

Why Dead Stock Hurts Liquor Stores

Dead stock creates several problems.

First, it ties up cash. Every bottle sitting on the shelf represents money that could have been used to buy products that sell faster.

Second, it takes up shelf space. Liquor stores have limited room. If a slow-moving product is occupying premium shelf space, it may be blocking a faster-moving bourbon, tequila, wine, or ready-to-drink product.

Third, it creates bad ordering habits. If managers do not review slow-moving inventory, they may continue reordering products simply because they are familiar or because a salesperson recommends them.

Fourth, it makes the store look stale. Customers notice when shelves are filled with products that do not move. Fresh inventory creates a better shopping experience.

What Should Owners Do With Slow-Moving Items?

A Shelf Review report does not automatically mean every slow item should be removed.

Instead, it gives the owner a decision-making tool.

For each slow-moving product, the owner can decide whether to:

• Discount it

• Move it to a better shelf location

• Feature it in a promotion

• Bundle it with a related product

• Stop reordering it

• Disable it from purchasing workflows

• Replace it with a faster-moving item

Liquor Bee POS also allows users to select slow-moving items and disable them from appearing in the Shopping Cart.

This is important because it prevents managers or employees from accidentally reordering products that the store has already identified as poor performers.

Why This Matters for Absentee Owners

Shelf Review is especially valuable for absentee liquor store owners.

An owner does not need to physically walk every aisle to understand what is sitting, what is moving, and what should not be reordered.

The report creates visibility.

Instead of asking, “Do we have too much inventory?” the owner can review the data and see exactly which products are tying up cash.

Turning Inventory Data Into Better Decisions

The best liquor stores do not rely only on instinct.

They use data to make better purchasing, pricing, and merchandising decisions.

A 365-day Shelf Review gives owners and managers a clear view of what has actually happened over the last year.

It helps identify:

• Dead stock

• Overstocked products

• Slow-moving categories

• Poor purchasing decisions

• Items that should be promoted

• Items that should be removed from future orders

At LiquorBee POS, the goal is not just to track inventory.

The goal is to help liquor store owners make better decisions with that inventory.

Because every bottle on the shelf should have a purpose.

If it is not selling, not attracting customers, and not helping the store make money, it may be time to review whether it belongs on the shelf at all.