# Store-level inventory ordering with min/max rules

> Retail inventory ordering fails when min/max rules sit in analyst workbooks disconnected from store on-hand data. Teams need store-level dashboards that flag below-min SKUs and draft purchase orders automatically.

For: inventory analyst

## The problem in retail terms

An analyst maintains min/max levels in a workbook. Store on-hand counts come from the POS or ERP on a delay. By the time someone notices a floor speaker at 3 units in Denver, the store has been below min for two days.

## Why spreadsheets and point tools fail

- On-hand data and reorder rules live in different systems
- Min/max updates require manual workbook edits
- Draft POs are rebuilt every morning from scratch
- Store managers have no single view of what to order

## What good looks like

- Min/max by store, updated when assortment or season changes
- Dashboard flags below-min and near-min SKUs with suggested order qty
- Draft PO ready for analyst review, not manual assembly

## How Layerr handles it

Describe your reorder logic in plain language: min/max by store, truck days, category rules. Layerr connects to on-hand data and surfaces "order 17" before the shelf is empty.

## Frequently asked questions

### What is min/max inventory in retail?

Each SKU at each store has a minimum on-hand level (trigger reorder) and maximum (cap order size). Rules vary by store format, season, and category.

### Why do stores still stock out if spreadsheets track min/max?

Spreadsheets are only as current as the last export. Without hourly or daily on-hand sync, reorder triggers fire late or not at all.

### Who should approve store orders?

Analysts or store ops should review draft POs, not build them from scratch in Excel every morning.

## Related problems

- [Finding and acting on aged inventory in retail](https://layerr.ai/problems/aged-inventory)
- [Store forecasting when spreadsheets break down](https://layerr.ai/problems/retail-forecasting)