How to turn Wix stock data into a reorder plan
Wix stock analysis should start with the current quantity at the product or variant level, then combine it with confirmed inbound units, an agreed demand rate, supplier lead time, the next review date, safety stock, MOQ, and case-pack rules. The result should be a proposed quantity with visible arithmetic—not an unexplained low-stock score.
Wix Stores already records and reports useful evidence. As reviewed on 23 July 2026, Wix's inventory overview documents exact quantity tracking or manual In Stock and Out of Stock states. Its Wix Stores analytics guide lists Sales by Product Variant and Inventory Snapshot reports. A planning workflow can use those surfaces as inputs while keeping supplier assumptions and buyer decisions separate.
The five numbers that drive the first calculation
On-hand units
Use the recorded quantity available to satisfy demand under the store's operating definition. Confirm whether reservations, damaged stock, pre-orders, returns, and location-specific inventory are reflected. A planning formula cannot repair a count that means something different from what the buyer assumes.
Confirmed inbound units
Count only supply with enough evidence to expect it inside the planning window. A draft, quote, or unapproved recommendation is not confirmed inbound. Record the order reference and expected date so another reviewer can challenge it.
Average daily sales
A simple starting rate is:
average daily sales = units sold in observation period ÷ observed days
Choose the observation window deliberately. A 30-day average may react faster; a longer average may reduce noise. Neither is automatically correct. Exclude or annotate periods where stockouts suppressed sales or a promotion temporarily changed demand.
Lead time and review period
Lead time is the expected number of days from an approved order to usable stock. The review period is how long until the buyer will assess the item again. Both matter. Ordering enough only for lead time can leave an item exposed between its arrival and the next buying cycle.
Safety-stock days
A transparent early-stage buffer can express safety stock as days of average sales. It is easy to understand, but it is not a statistically optimized service-level model. The rule should state who chose it and when it was last reviewed.
A transparent reorder formula
First calculate the planning window:
planning days = lead-time days + review-period days + safety-stock days
Then calculate the target:
target units = average daily sales × planning days
Subtract available and incoming stock:
raw shortage = target units − on-hand units − confirmed inbound units
If the raw shortage is zero or negative, the rule proposes no order. If it is positive:
- raise it to the MOQ when it is below the MOQ;
- round upward to the next full case pack;
- retain the pre-rounding shortage and each adjustment in the result.
A precise implementation must define how fractional target units are handled. One understandable option is to preserve the decimal through the shortage calculation and round the final order upward to a valid case. Document the rule instead of relying on spreadsheet defaults.
Worked synthetic Wix SKU
Consider an invented variant, TEA-GREEN-100:
- on hand: 34 units;
- confirmed inbound: 12 units;
- units sold in the last 28 days: 98;
- lead time: 12 days;
- review period: 7 days;
- safety stock: 4 days;
- MOQ: 24 units;
- case pack: 12 units.
Average daily sales are 98 ÷ 28 = 3.5.
Planning days are 12 + 7 + 4 = 23.
Target units are 3.5 × 23 = 80.5.
Raw shortage is 80.5 − 34 − 12 = 34.5.
An order is needed. The shortage already exceeds the MOQ, so the next step is case rounding. Three cases provide 36 units. The illustrative proposal is therefore 36 units.
The output should also show that 12 inbound units were counted and identify their source. If that shipment is delayed beyond the planning window, the calculation changes to 80.5 − 34 = 46.5, which rounds to 48 units. The recommendation is only as current as its inputs.
Add days of cover for prioritization
A second useful signal is approximate days of cover:
days of cover = (on-hand units + qualifying inbound units) ÷ average daily sales
For the example, current plus inbound stock is 46 units, so approximate cover is 46 ÷ 3.5 = 13.1 days. That is shorter than the 23-day planning window, which explains why the item appears in the queue.
Days of cover has boundaries:
- it is undefined or not useful when average daily sales are zero;
- it assumes the selected demand rate continues;
- inbound should be included only if its arrival timing supports the calculation;
- it does not account for expiry, substitutions, or stock at the wrong location.
Use it to explain priority, not to promise a stockout date.
Build a reviewable weekly queue
1. Freeze an observation point
Capture stock, sales, inbound, and supplier data at a named time. Mixing Monday's stock with Friday's sales and an undated supplier sheet creates a result no one can reproduce.
2. Match the orderable unit
Analyze the same unit the supplier sells. If Wix tracks small and large variants separately but the supplier SKU maps to a mixed case, the simple one-variant formula is incomplete.
3. Validate exceptions
Flag:
- negative or unexpectedly high stock;
- zero sales caused by a stockout;
- missing lead time;
- inbound with no expected date;
- MOQ smaller than a case pack;
- a case pack of zero or one entered by mistake;
- new products with insufficient history;
- products affected by a known promotion.
Unknown inputs should block or downgrade the recommendation rather than silently becoming zero.
4. Calculate before ranking
Apply the same versioned formula to every valid SKU. Keep raw values and adjustment reasons. A queue can then sort by an agreed signal such as shortage urgency, days of cover, or estimated consequence, but the underlying arithmetic must remain visible.
5. Require buyer review
The buyer should approve, defer, or override each proposed quantity and record a short reason. An override is not necessarily a model failure; it may contain important evidence that should improve the next run.
6. Carry orders forward
Once approved and placed, record the confirmed quantity and expected date. Otherwise the next analysis may propose the same order again.
For a manual version of the arithmetic and boundary cases, use the Wix inventory reorder calculator.
Where native Wix workflows fit
Wix's current purchase-order guidance, reviewed on 23 July 2026, describes a dashboard workflow that is currently available to Wix Stores merchants in the US or Canada. It covers suppliers, products, quantities, costs, draft and ordered states, and receiving inventory.
Analysis should remain distinct from action:
- the stock and sales evidence describes the store;
- the formula proposes a quantity;
- the buyer makes the decision;
- the approved operational workflow creates and communicates the order;
- the receipt process updates inventory.
For the broader native-capability distinction, read does Wix have inventory management?. For app selection criteria, see the Wix inventory management app guide.
A compact stock-analysis checklist
- Confirm the product and variant identifier.
- Capture the Wix stock quantity and observation time.
- Reconcile known receipts, returns, cancellations, and pre-orders.
- Count only confirmed inbound arriving within the relevant window.
- Select and document the demand observation period.
- Mark stockout- or promotion-distorted sales.
- Verify lead time, review cadence, safety-stock rule, MOQ, and case pack.
- Calculate target, raw shortage, MOQ adjustment, and case rounding separately.
- Surface missing or suspicious values.
- Record buyer approval, deferral, or override.
- Carry the approved order into inbound supply.
- Re-run after material stock, demand, or supplier changes.
Limitations of this model
This formula is intentionally simple. It does not model seasonal curves, promotion uplift, demand distributions, supplier reliability ranges, partial deliveries, substitution, product cannibalization, expiry, multi-location allocation, budget constraints, or service-level optimization.
Wix reports describe their configured platform scope; they do not validate the physical count or supplier facts. Sales observed during a stockout can understate demand. New products may have no representative history. A recommendation cannot guarantee availability, sell-through, delivery timing, or profit.
The method should not automatically place an order or change Wix stock. Any connected workflow needs separately reviewed permissions, account-specific API feasibility, idempotency, error handling, and human authorization.
Official sources reviewed
Platform facts were checked on 23 July 2026 against Wix's inventory overview, Wix Stores analytics reports guide, and purchase-order guidance.
To inspect this calculation across a bounded synthetic catalogue, run the ReplenishIQ sample and request one paid Wix-connected planning review. The result is a draft decision aid, not a purchase order.