Inventory

Weeks of Supply Formula: Calculate SKU Cover Before the Next Purchase

Weeks of supply shows how long sellable stock lasts

Weeks of supply is the number of weeks current sellable stock would last if the weekly unit rate you used kept going. It is a cover check before a purchase review, not the quantity to order.

Use it on one variant at a time. A storewide average hides the SKU that runs out in two weeks and the SKU that still has a season of stock left.

The weeks of supply formula

Weeks of supply = Available units ÷ Average weekly units sold

Available units are units you can still sell. Average weekly units sold is net units over a recent, comparable period, divided by the number of weeks in that period. Keep both inputs in units. Do not mix unit stock with dollar sales.

What each input includes

  • Available units: sellable stock for that variant on the as-of date. Leave out units already promised to orders, units set aside, and units still in transit.
  • Average weekly units sold: net units in the lookback, divided by complete weeks. A 4-week window reacts faster. An 8-week window smooths a one-week spike.
  • Lookback rule: use the same window for every SKU in the review, then replace the rate only when you have a reason the next weeks will differ.
  • Zero sales: if the variant sold nothing in the lookback, do not divide. Mark it as no recent demand and review it outside this formula.

Some teams say weeks on hand or weeks of cover for the same unit math. Others reserve weeks of supply for a forward demand rate and weeks on hand for a trailing rate. Write the inputs next to the result so two buyers are not comparing different numerators.

Pull the same Shopify variant on the same date

The numerator and the denominator have to describe the same variant. Pull stock and sales before you divide, and write the as-of date on both.

  1. Open the variant inventory card, or the Inventory page. Read Available for locations that fulfill this variant. Shopify defines Available as inventory you can sell. It is not committed, not set aside as Unavailable, and it does not include Incoming.
  2. Skip On hand. Shopify defines On hand as Committed plus Unavailable plus Available, so On hand counts units you cannot sell. If Available shows a dash, that location is inactive for the variant. Do not add its On hand into online cover.
  3. Open Analytics, then Reports. Filter Category to Sales and open Total sales by product variant. Set a custom range of complete weeks ending last Sunday, usually the last 4 or 8 weeks.
  4. Read Net quantity for that variant. Shopify defines Net quantity as the number of sold items minus the number of returned items. Divide that figure by the number of weeks.
  5. If you need to see what was removed, add Reversed quantity. Shopify defines reversed quantity as units removed for refunds, returns, cancellations, or edits, and ordered quantity as net quantity plus reversed quantity. Use Net quantity for the weekly rate, not gross units.

Shopify's sales reports include pending, unpaid, and canceled orders, and a reversal shows on the date it was processed, not on the original order date. If last week's Net quantity dropped because a large refund posted, do not treat that dip as a permanent demand change. The field definitions are in Shopify's inventory states and sales reports help pages.

Incoming stock stays out of the numerator. Shopify says incoming inventory is not available to sell until it is received and its state changes to Available. A draft purchase order is not cover.

Calculate cover for two hypothetical SKUs

These figures are an example, not store results. Both variants are reviewed on a Monday. Call that Monday the start of Week 1. Sales are Net quantity for the four complete weeks ending the Sunday before the review.

InputSKU A, everyday mugSKU B, holiday candle
Available units12680
Net quantity, 4 complete weeks8440
Average weekly units sold84 ÷ 4 = 2140 ÷ 4 = 10
Weeks of supply126 ÷ 21 = 6.080 ÷ 10 = 8.0

SKU A has 6.0 weeks of supply. At 21 units a week, 126 available units last six weeks if that rate holds. SKU B has 8.0 weeks of supply. The candle looks safer on the trailing formula. The calendar section below shows why that reading can fail.

How to read the result and what to do

Read weeks of supply against supplier lead time and your buying cycle. There is no single weeks-of-supply target that fits every Shopify SKU. A consumable with a 10-day supplier can run short cover. A seasonal item with a 12-week supplier cannot.

Lead time here means the weeks from purchase approval until units become Available, including production, transit, and receiving. The ranges below are an example policy for a team that reviews buys once a week. They are not universal inventory rules. Widen the buffer when weekly demand swings, or when the supplier often misses the quoted lead time. Narrow it only when both demand and the supplier are stable.

  • Example policy, stable demand: cover is at least one review cycle longer than lead time. Leave the SKU off this week's purchase list. If demand or the supplier varies, keep a wider buffer than one review cycle.
  • Example policy: cover is within about one week of lead time. Confirm the order in this cycle if you use that one-week buffer. Waiting another review eats it. Treat a wider gap as urgent when demand or lead time is unreliable.
  • Cover is shorter than lead time at one rate that applies from today: escalate it. An order placed today arrives after available stock hits zero if that rate holds. Skip this test when the weekly rate changes before arrival, and project cumulative demand instead.
  • Cover is far longer than the next quiet period: treat it as surplus. Do not reorder it just because the formula produced a large number.
  • No weekly rate: stop. A new, seasonal, or unsold SKU needs a demand check, not a division by zero.

A very long cover on a slow seller is a surplus decision. Size those extra units against a target cover before you buy again, using the excess inventory workflow.

Promotions and seasonality break the trailing rate

The simple formula assumes next week looks like the average week you just measured. A promotion, a stockout inside the lookback, or a seasonal shift breaks that assumption.

SKU B's 8.0 weeks used a lookback rate of 10 units a week. If a later peak runs near 40 units a week, dividing all 80 available units by 40 gives 2.0. Treat 2.0 as a simplified peak-rate scenario only. It applies the peak rate to units that will already have sold at the quieter rate before the peak starts. Do not compare 2.0 with lead time to decide whether to escalate. The timing section counts those pre-peak sales through the expected arrival date.

The reverse error loads the warehouse. A rate taken from BFCM, a sitewide sale, or last year's peak will show short cover in a quiet month. Buying against that inflated week leaves units you are still holding in February.

Replace the rate when the lookback is distorted

  • A promotion, bundle, or ad push starts inside the cover window and was not in the lookback.
  • The same calendar weeks last year sold a clearly different weekly rate, and you expect that pattern again.
  • The variant was unavailable for part of the lookback. Zero-sale days pull the average down and make cover look longer than real demand supports.
  • You are heading into BFCM, a gifting window, or the post-holiday lull. One trailing average cannot represent both the peak and the lull.
  • A large refund posted in the lookback. Net quantity fell on the reversal date, not because demand disappeared.

Example, still hypothetical. SKU A shows 84 net units over 28 days, but it was unavailable for 7 of those days. In-stock time is 21 days, or 3 weeks. The in-stock weekly rate is 84 ÷ 3 = 28 units, not 21. Cover becomes 126 ÷ 28 = 4.5 weeks, not 6.0. That adjustment estimates demand on days the item could be bought. It does not prove how many people would have ordered during the unavailable week.

When the next weeks will not look like the last ones, divide available units by a forward weekly demand estimate for the weeks you are covering. Building and checking that estimate is a separate job, covered in the inventory forecasting guide. Do not stretch the lookback until the number feels safe.

Compare cover with delivery timing before you escalate

Weeks of supply answers how long this stock lasts at the rate you trust. The purchase screen also needs lead time and what is already incoming.

  1. Write demand through the arrival date. If one weekly rate holds the whole way, weeks of supply is available units divided by that rate. If the rate will change, add each week's expected units, including quieter weeks before a peak. Do not divide every available unit by the later peak rate.
  2. Write lead time in weeks, from approval to Available. Use the supplier's full cycle, not only the quoted ship time.
  3. If one rate applies from today and that cover is shorter than lead time, an order placed today does not close the gap. Escalate that SKU before longer-cover items. If the rate changes before arrival, compare available units with cumulative demand through the expected arrival date. Do not subtract a peak-rate weeks-of-supply figure from lead time.
  4. Add incoming units only after the purchase order is accepted and the arrival week is realistic. Keep them out of Available until Shopify receives them.
  5. If a promotion starts before the inbound arrives, apply the promoted weekly rate only to the weeks it runs. Leave the weeks before the promotion on the quieter rate.

Same example, still hypothetical. SKU A has 6.0 weeks of trailing cover and a 3-week supplier, so it can wait for the normal buying cycle if demand stays near 21 units a week. SKU B needs a different check. A 5-week lead time from the Monday review puts expected Available at the start of Week 6. The 40-unit peak rate starts in Week 5, not on the review date. Until then, keep the trailing rate of 10 units a week.

  • Weeks 1, 2, 3, and 4: 4 × 10 = 40 units sold before the peak.
  • Week 5, before the Week 6 receipt: 40 units at the peak rate.
  • Cumulative demand through the start of Week 6: 80 units, equal to current available stock.

On this projection, stock reaches zero in the same week the order is expected to become Available, with no units left if that first peak week sells 40. Decide the candle in this cycle because the receipt does not land with a buffer. The mug is not the urgent buy. Use this cumulative total for the timing decision. Comparing 2.0 weeks of peak-rate cover with a 5-week lead time skips the pre-peak sales and can point to the wrong buy.

That comparison is a timing screen. It does not set the order quantity. Once a SKU fails it, move that SKU into the reorder calculation instead of guessing a purchase quantity from weeks of supply.

On a live catalog, the screen is faster when stock and recent unit velocity sit on one SKU list. Skymetrics stock intelligence reads Shopify stock levels and sales velocity so you can flag variants that may run out before the next delivery. You still apply the seasonal check before you buy.

Weeks of supply, days sales in inventory, and the reorder point

Days sales in inventory uses inventory value and cost of goods sold over a period. It answers how long inventory value sits relative to the cost of what you sold. Weeks of supply uses sellable units and a weekly unit rate. It answers how long current Available stock lasts at that rate. When you need the value version, use the days sales in inventory formula instead of turning this unit result into dollars.

A reorder point is the stock level that should trigger a purchase: expected demand over lead time, plus a safety buffer. Weeks of supply leaves lead time and safety stock out of the math, so it cannot be the buy trigger by itself. When cover is shorter than delivery time, calculate the trigger with the Shopify reorder point formula.

Keep the three numbers in separate columns on the weekly review. Weeks of supply flags cover. Forecasting replaces the weekly rate when the next weeks will differ. The reorder formula sets the buy trigger. A weekly Shopify inventory routine can hold all three without collapsing them into one cell.

Run this before the next purchase review

  1. Export Available by variant, and Net quantity from Total sales by product variant for the last 4 complete weeks.
  2. Divide Available by average weekly units. Sort the list from shortest cover to longest.
  3. Replace the weekly rate for any SKU with a promotion, a stockout in the lookback, or a seasonal shift you already expect.
  4. Compare trusted cover with supplier lead time only when one rate holds through arrival. If the rate changes, compare available units with cumulative demand through the expected arrival date, including pre-peak weeks.
  5. Send only those SKUs into the reorder calculation. Leave long-cover, stable SKUs off the purchase list.