Sales history is not the whole demand picture
An inventory forecast estimates future demand for a product over a defined period. Replenishment planning turns that estimate into a buying decision using supplier lead times, stock already available, orders in transit and practical constraints. They are related, but not interchangeable.
Recorded sales can understate demand when a product was unavailable. They can also overstate normal demand during a promotion or one-off event. Mark stockout periods, returns, campaigns and product changes before treating a recent sales average as a forecast.
Work at the level at which you buy and fulfil: often a product variant and location, not just the whole store. A healthy total can hide a popular size that is repeatedly unavailable. For new products, document assumptions and comparable items; do not imply that historical data exists when it does not.
A forecasting workflow a small store can maintain
Clean and align the records
Use consistent product identifiers and time periods. Separate completed sales, cancellations and returns, and record days when each item was unavailable. Confirm that stock quantities agree with physical counts.
Start with a baseline
For relatively stable demand, try a recent average; for seasonal products with sufficient history, compare equivalent periods. Document the chosen window rather than picking the one that makes the forecast look best.
Track actual supplier lead times
Measure from placing an order to stock becoming usable, including transport, receiving and checks. Note variability, order minimums, pack sizes and supplier closures.
Translate demand into reorder rules
A basic continuous-review reorder point is expected demand during lead time plus safety stock. Use consistent time units and adjust for your inventory position, not only the shelf count.
Apply cash and storage constraints
A suggested order may exceed your budget, shelf capacity or an item’s useful life. Review those limits before purchasing; reducing unit cost through bulk buying can still tie up too much cash.
Review forecast error and service outcomes
Compare forecasts made before a period with the results after it. Track bias, stockout periods and excess stock alongside error; revise assumptions when demand or lead times change.
A simple reorder-point example
Illustrative arithmetic, not a sales prediction: suppose an item’s expected demand is 4 units per day, supplier lead time is 10 days and you choose 12 units of safety stock. Expected lead-time demand is 40 units, so the basic reorder point is 52 units. Those example numbers are not a recommended buffer for any real store.
Compare that point with inventory position: usable on-hand stock plus confirmed incoming stock minus outstanding demand not already deducted. Avoid subtracting reservations twice if your system’s available quantity already accounts for them. Verify how your stock tool defines each field.
This simple model assumes a continuous review process. Periodic ordering needs to cover the review interval as well as lead time; intermittent demand, short shelf life or highly variable supply may need another method. Safety stock should reflect uncertainty and the service level you can afford, not a universal percentage.
Stock tracking is not the same as forecasting
Shopify documents inventory tracking and management, including quantities at locations. WooCommerce documents product and variation stock settings. For Wix, check its current stock-management documentation and export options for your setup. Keeping a quantity accurate is essential, but does not by itself establish an automated forecast or replenishment engine.
You can start with exported reports and a spreadsheet, then evaluate a planning app, plugin or external system if the workload justifies it. Ask how the tool handles stockouts, promotions, lead-time variation and new items, and which features depend on a paid plan or integration.
If a tool uses AI, test it on historical periods held back from model fitting, without giving it future information. Compare it with your simple baseline on the same items and periods. Better forecast accuracy does not automatically mean lower total costs; purchasing constraints and service trade-offs still matter.
The weekly inventory review
Tick these off before you commit.
- Products at risk of running out before the next usable delivery.
- Incoming orders with changed dates or quantities.
- Slow-moving, ageing, damaged or expiring stock.
- Upcoming promotions and known seasonal events.
- System quantities that disagree with recent physical counts.
- Purchasing decisions that exceed cash or storage limits.
Common questions
Keep exploring
Official sources
Platform facts on this page reference the documentation below. Features, plans and availability change — check the provider before you decide.
- Shopify Help Center — Inventory reports
- Shopify Help Center — Inventory management for multiple locations and apps
- WooCommerce — Products settings and inventory management
- Microsoft Learn — Demand forecasting overview (concepts; Dynamics 365 features)
- U.S. Small Business Administration — Manage your finances