Best Way to Track Low-Stock SKUs and Avoid Overselling on Shopify

Overselling is one of the most damaging things that can happen to a Shopify store. A customer orders something, you can't fulfill it, and now you're issuing a refund, writing an apology email, and hoping they don't leave a public review. The worst part: most overselling incidents are completely avoidable with a basic tracking system.

This guide walks through exactly how to set up low-stock SKU tracking that actually works — including the specific alert thresholds to use, what to automate versus what to do manually, and the common mistakes that let stockouts slip through even when you think you're watching.

Why Overselling Happens (Even When You're Watching)

Most Shopify store owners think they're aware of their stock levels. They check the dashboard a few times a day, they remember that the blue sneakers are getting low. But awareness isn't a system, and awareness breaks down in four predictable ways:

• High-velocity periods: During a flash sale or viral moment, a SKU can go from 20 units to 0 in under an hour. Manual checks can't keep up with order velocity when demand spikes.
• Concurrent orders: Two customers add the last unit to their cart simultaneously. Shopify's inventory reserve holds for a short window, but during checkout lag, both orders can complete.
• Supplier discrepancies: You think you have 30 units based on your last restock, but the actual pick-and-pack count at the warehouse is 22. You're working from wrong data.
• Variant-level blindness: The product page says "In Stock," but that's because the XL in forest green is fine. The SM in black — the variant your ads have been pushing — is at 2 units.

The Right Alert Thresholds for Your Store Size

There's no universal low-stock threshold — the right number depends on your reorder lead time and average daily sales velocity. Here's how to calculate it:

For most small Shopify dropshipping stores, a simpler two-level system works well:

Building Your SKU Tracking System: Step by Step

Step 1: Enable "Continue selling when out of stock" strategically

Shopify has a per-variant setting called "Continue selling when out of stock." This is useful for digital products or made-to-order items, but it's a trap for physical goods. Audit every SKU and make sure this is disabled for anything you actually warehouse or dropship. This one setting is responsible for a significant percentage of small-store overselling incidents.

Step 2: Use Shopify's inventory tracking at the variant level

In Shopify Admin → Products, every variant has its own inventory quantity. Many store owners set inventory at the product level and forget to configure variants. If you have a t-shirt in 4 sizes and 3 colors, that's 12 variants — each needs its own tracked quantity.

A quick audit: export your inventory as a CSV (Admin → Products → Export → Products and variants). Sort by quantity ascending. Any variant with "Track quantity" disabled is a hidden overselling risk.

Step 3: Set up automated low-stock notifications

Shopify's native low-stock alerts are limited — they fire once per product and don't distinguish between your threshold and zero. For a robust alert system, you have three options:

Step 4: Reconcile supplier stock vs. Shopify stock weekly

Your Shopify stock count is only as good as your supplier's accuracy. Set a weekly calendar reminder to request a stock confirmation from your top 10 highest-velocity SKUs. A quick supplier email asking for current warehouse counts on your items takes 5 minutes and can catch discrepancies before they become oversells.

Step 5: Automate the "out of stock" response

When a SKU hits zero, you want two things to happen automatically:

• The product becomes unavailable to purchase (no more add-to-cart on that variant)
• A "Back in stock" notification form appears so interested customers can opt in

Shopify handles #1 automatically when inventory tracking is enabled and the "continue selling" flag is off. For #2, apps like Back In Stock or Klaviyo's browse abandonment flow can handle the notification capture.

The Metrics to Watch Daily

For ongoing SKU tracking, you don't need to watch everything — you need to watch the right things. Three metrics cover 80% of your overselling risk:

Pulling It Together

Avoiding overselling on Shopify comes down to four things: variant-level tracking enabled on every SKU, a threshold-based alert system that fires before you hit zero, a weekly supplier reconciliation to catch discrepancies, and a daily review of velocity and days-of-stock-remaining for your top SKUs.

The good news is that once you have this system in place, it largely runs itself. You go from manually checking dashboards to reviewing a clean daily briefing that tells you exactly what needs attention. That's the difference between reactive and proactive inventory management — and it's the difference between the stores that keep growing and the ones that get stuck putting out fires.