How to Calculate Safety Stock and Reorder Point for Shopify Inventory
Estimate demand during lead time, add a chosen safety buffer, then account for inbound stock, review cadence, MOQ, and case packs.
Table of Contents
Reorder point (units) = (average daily sales × lead time in days) + safety stock in units.
- Average daily sales = units sold during a representative observation period ÷ days in that period.
- Count the end-to-end time until new stock is sellable, not only factory production days.
- The reorder point is a trigger; order quantity also depends on target coverage, open purchase orders, MOQ, and pack size.
- A fixed buffer is a planning rule, not a guarantee against stockouts.
For Shopify inventory, calculate the reorder point from average daily sales, end-to-end lead time, and a chosen safety buffer. The threshold is simple; getting the inputs and inventory position right takes more care. The Shopify Inventory Reorder Planner matches inventory and SKU sales CSVs for one selected location and estimates coverage, reorder point, suggested units, and purchase cost when unit cost is supplied. Its safety-stock input is in days and uses the same average daily sales rate; it does not estimate demand or lead-time variability. For a single-SKU buffer and trigger calculation, the safety stock calculator and reorder point calculator show the formulas step by step.
Collect the right sales and inventory data
Use units sold for the relevant SKU and location over a period that resembles expected future demand. For example, use 840 units over 28 days to estimate 30 units per day. Choose a longer window for stable items and a shorter, carefully reviewed window when demand has shifted. Exclude or adjust stockout periods: observed sales can understate demand when the product was unavailable.
For current inventory, identify what is sellable now and what is committed, reserved, damaged, or inbound. The planner matches sales and inventory CSVs by normalized SKU and lets you select a location. It does not automatically reconstruct inventory position from purchase orders, transfers, backorders, or reservations, so reconcile those quantities before treating its suggested order as a purchase instruction.
Shopify has distinct product and inventory CSV workflows. Its inventory CSV guidance describes location-specific inventory fields and import requirements; do not assume a product CSV's inventory quantity field represents a multi-location inventory plan.
Calculate the Shopify inventory reorder point
Suppose an item sells an average of 30 units per day, and total replenishment lead time is 24 days from placing the order until units are received and available to sell. Expected lead-time demand is:
30 units/day × 24 days = 720 units.
Assume the operator chooses 8 days of safety stock, equivalent under the fixed-average model to 30 × 8 = 240 units. Then:
Reorder point = 720 + 240 = 960 units.
When inventory position approaches 960 units, review whether to place an order. Inventory position is generally sellable on-hand units plus confirmed inbound units minus committed demand, using a definition consistent with your system. The threshold is not necessarily the number physically on a shelf.
The same calculation can be written as average daily sales × (lead time days + safety stock days). That is how the planner's safety-stock-days input works. The buffer should be selected based on demand and supply uncertainty, the cost of a stockout, supplier reliability, and cash constraints. Do not treat “8 days” as a universal default.
Keep reorder point separate from order quantity
The reorder point says when to review or trigger replenishment. It does not say how many units to buy. A periodic review process may target enough stock to cover lead time plus the next review interval. If the review interval is 7 days, target stock under the planner's simple rule is:
30 × (24 lead-time days + 8 buffer days + 7 review days) = 1,170 units.
If current available inventory is 800 units and there is no inbound stock accounted for, the initial gap to that target is 370 units. A 100-unit MOQ and 24-unit case pack would round the suggested order up to 384 units: the smallest 24-unit multiple that meets the 370-unit gap. If the planner reports an order cost, it multiplies recommended units by the unit cost entered; it does not add freight, duties, deposits, or tax unless included in that unit-cost assumption.
Before ordering, subtract open purchase orders and committed demand if they are not already reflected in the inventory export. Check product status, supplier minimums, shelf life, and whether stock is transferable from another location.
Interpret the estimate and its limitations
An average-demand, fixed-buffer model is useful for a first operating rule and for checking a CSV. It assumes the observed sales rate is a reasonable proxy for demand, the lead time is entered accurately, and a chosen buffer is adequate. It does not use demand standard deviation, lead-time variability, promotions, seasonality, intermittent demand, or supplier correlation to infer a probability of service.
For volatile SKUs, consider a statistical or forecast-based approach using demand during lead time, supplier performance, and a chosen service objective. The planner remains useful for a quick location-level coverage and order-quantity screen, but compare its simplified result with a richer forecast before using it for high-value or seasonal purchases. Revisit the reorder-point estimate after a meaningful demand or lead-time change; the estimate is only as good as the assumptions and input data.
Put the calculation into a repeatable routine
- Export location-specific inventory and a matching period of SKU sales.
- Normalize SKU identifiers and confirm duplicate or blank keys.
- Record observation days, lead-time assumptions, buffer days, review cadence, MOQ, case pack, and cost source.
- Compare coverage days and reorder recommendations with open purchase orders and transfers.
- Review fast movers, at-risk items, and outliers with the buyer or supplier owner.
- Record the order decision and actual receipt date so lead-time assumptions improve over time.
Shopify's product analytics can also show metrics such as days of inventory remaining and product sell-through. Shopify documents the definitions and reporting windows in its product analytics overview. These platform metrics can help prioritize review, but their definitions and timing may differ from your planning spreadsheet; check the report's date range and location context before comparing values.
FAQs
What is the reorder point formula?
A basic formula is reorder point = average daily demand × lead time in days + safety stock in units. If the buffer is stated in days, convert it to units by multiplying safety-stock days by average daily demand.
Is safety stock included in lead-time demand?
No. Expected demand during lead time and safety stock are separate components in this formula. The buffer is added above expected lead-time demand to absorb uncertainty.
Does the reorder point tell me how much to buy?
No. It tells you when inventory position reaches a review threshold. Order quantity depends on the target stock level, current and inbound inventory, review cadence, MOQ, case pack, and cash availability.
Can Shopify sales history calculate safety stock automatically?
Sales history can support a demand estimate, but a chosen safety-stock policy also needs supply uncertainty and service goals. The linked planner uses a user-entered buffer in days; it does not calculate a statistical buffer from history.