Title: Intelligent Min Stock Thresholds: Auto-Adjust Based on Sales Velocity
Category: Inventory Management
The Problem
Square lets merchants set a minimum stock alert for each item, but that number is static. Set it once, forget it, and it quickly becomes wrong.
A product that sold 2 units a week last winter might sell 8 a week in spring. Your min stock threshold doesn't know that. You either get alerted too late (stockout before you notice) or too early (alert fatigue from false alarms on slow movers).
For stores with hundreds of SKUs, manually reviewing and updating min stock thresholds is not realistic. Most merchants either never update them or abandon them entirely.
What We Actually Need
Min stock thresholds should be dynamic, automatically adjusted based on how each item is actually selling.
Specifically:
- Velocity-based calculation: derive the recommended minimum from actual daily sales rate over a rolling 91-day window, not a guess at setup
- Automatic daily adjustment: recalculate and update thresholds each morning as sales patterns change
- New item protection: skip auto-adjustment for items without sufficient sales history so new arrivals aren't penalized with bad recommendations
- Merchant override: let merchants lock a threshold on specific items to prevent auto-adjustment when they know something the system doesn't (seasonal buys, samples, display stock, promotional inventory)
- Case pack awareness: round recommended minimums to case pack quantities so reorder suggestions align with how vendors actually ship
- Max conflict detection: flag items where the recommended minimum meets or exceeds the current maximum and hold for merchant review instead of applying blindly
- Skips slow and zero-velocity items: items with no meaningful sales history are excluded from adjustment automatically to avoid noise
Why This Matters
Stockouts are lost sales. Overstocking is tied-up cash. The gap between the two is min stock, and right now merchants are either guessing or building their own tooling to solve it.
I built daily auto-adjustment into my own inventory system because Square doesn't offer it natively. It runs every morning, adjusts thresholds based on 91-day rolling velocity, skips new items and pinned overrides, flags conflicts for review, and syncs the result back to Square. This morning it processed 111 items, adjusted 6, flagged 3 for human review, and correctly skipped 89 that were too new to have reliable data.
That shouldn't require custom development. It should be a native Square feature available to every seller.
The Ask
Intelligent, velocity-based min stock thresholds with daily auto-adjustment, merchant pin overrides, case pack rounding, and conflict detection built into Square's inventory management natively.
