Quality Free Backlinks is live · Browse vetted free-submission opportunities with fit, submission steps, and risk notes.

1/2
Intermediate70 minutesStep 2

Inventory and Demand Planning: Replenish, Throttle, or Pause a SKU

Use the A-07 established SKU to verify `68 - 12 = 56` sellable units, `56 / 4 = 14` days of cover, `18 - 14 = 4` days of exposure, and `4 x 18 + 40 = 112` reorder point. Then record demand range, service target, lead-time distribution, 3PL data freshness, and bundle/preorder boundaries within one SKU, market, and location scope before assigning operations, supply, ads, and finance a throttle, replenish, or pause action in an inventory cadence sheet.

2
Current Lesson
2/17 lessons

Last reviewed

2026-07-29

Review scope

Reviewed against Shopify, Google Search, ads, analytics, and ecommerce operating workflows.

Lesson Progress
Progress
2/17 lessons
Current lesson unlockedContinue in sequence
Loading interactive version
Text version of this lessonExpand

Once an independent store starts growing, inventory stops being a back-office task and becomes an operating constraint. This lesson is not a full supply-chain forecasting model. It is a weekly operating review that connects Shopify inventory, purchase sheets, supplier lead time, campaign plans, sales velocity, and cash pressure so each important SKU can become a decision: replenish, throttle, clear out, repair data, or pause.

Case boundary: A-07 in the inventory workbench is a separate established SKU: sellable cover is 14 days and actual total lead time is 18, so `18 - 14 = 4` days of stockout exposure comes first and this week can only throttle, not scale. Operations subtracts committed and held units from sellable stock, supply confirms 18 days from recent receipts, ads pauses scale tests, and finance or growth checks whether the purchase crowds out cash. The prior pet rear-seat protector remains an unvalidated research hypothesis and cannot become A-07 sales history or reorder proof.

Lesson task: connect inventory decisions to sales rhythm

Inventory is not only a warehouse issue. It controls growth rhythm. Read this lesson through the relationship between sales velocity, replenishment time, safety stock, media plans, and campaign calendars, then leave with an inventory review cadence sheet.

Small catalogs can review every core SKU. SKU-heavy stores should sample by A core products, campaign products, deep stock, market inventory mismatches, and high-refund products so the weekly review does not only follow the most visible items.

Inventory review terms to anchor on

  • Safety stock: Inventory buffer for demand swings and replenishment delays.
  • Turnover: How quickly inventory becomes cash; too slow traps cash, too fast creates stockout risk.
  • Demand forecast: Expected demand based on sales history, campaigns, ads, and seasonality.
  • Stockout risk: Not just missed orders; it can affect ad learning, SEO, and customer trust.

This lesson first splits inventory states, then calculates normal and campaign cover, and finally turns inventory pressure into a weekly review row. The copyable lesson notes stay at the end so the decision can move into the team workspace.

Align inventory evidence from three places first

An inventory decision cannot rely on one admin number. Put current Shopify state, future arrivals from the purchase sheet, and real supplier lead time together before deciding this week’s move. When these three do not match, media and campaigns may run ahead of fulfillment.

Evidence sourceWhat to checkDecision it supports
Shopify Products / Inventory / LocationsAvailable, Committed, Unavailable, On hand, Incoming, market/location availability, and bundle allocation.Confirms how much stock can actually be fulfilled now.
Purchase sheet or purchase orderOrdered quantity, expected receiving date, purchase cost, MOQ, payment status, and inbound status.Confirms whether future inventory can support this week’s action.
Supplier lead-time recordRecent real production, shipping, customs, and receiving days, not only the supplier’s verbal promise.Confirms whether reorder point and safety stock reflect real lead time.

How to review small and large catalogs

If the store only has a few dozen SKUs, review every core SKU and every product currently receiving traffic. If the catalog is larger, do not sample randomly. Split the review by risk: A core products, campaign products, deep stock with slow velocity, target-market inventory mismatch, and high-refund or high-support products.

Replenishment decision practice: decide SKU state before choosing the action

An inventory table is not a capture of the admin inventory number. It is a growth capacity table. It tells media, page, support, purchasing, and merchandising teams whether a SKU can keep scaling, for how long, when it must replenish, when it should throttle, and when it should clear out or repair inventory-state logic.

Use this practice in four steps: understand that On hand does not mean sellable; split Available, Committed, Unavailable, On hand, Incoming, total lead time, safety stock, reorder point, and days of cover; decide the current SKU state; then write media action, purchasing action, page/support action, and review date back to the weekly inventory review.

Inventory scenarioFirst evidenceSafer actionDo not move this way
A core SKU has only 14 days of coverReorder point = average daily sales x total lead time + safety stock. If 56 units are below a 112-unit reorder point, cover is already below lead time.Trigger replenishment review today, pause scale tests, and sync page plus support.Keep increasing budget because ROAS still looks good.
C test SKU suddenly spikes from a short videoWhether the spike is repeatable, sample consistency, MOQ, reorder lead time, refund reasons, and substitute SKU.Keep C test status, validate small batch, and do not overbuy from one spike.Place a large order only to lower purchase cost.
D SKU has deep stock but slow turn90-day turn, refund reasons, margin, clearance price floor, ad spend, and bundle potential.Stop replenishment, move to clearance or bundle, and record price floor plus review date.Reorder because the supplier offered a lower unit cost.
Canada market says buyable but local location cannot fulfillAvailable, Committed, Unavailable, On hand, Incoming, location rules, market availability, and bundle allocation.Fix inventory states and location/market rules before syncing page, ads, and support.Keep advertising from Shopify total stock alone.

Inventory coverage calculator: calculate how long stock can carry demand before ads and replenishment

The weakest inventory reviews say "stock is a little tight" or "we still have plenty" without putting sellable stock, committed orders, normal daily sales, campaign daily sales, lead time, and safety stock into one calculation. For every core SKU, calculate three numbers first: real sellable units, normal days of cover, and campaign days of cover.

CaseCalculationJudgmentThis-week action
A-07 pet car mat68 Available - 12 Committed = 56 sellable units; 56 / 4 normal daily sales = 14 days; reorder point = 4 x 18 + 40 = 112 unitsBelow reorder point and below the 18-day lead-time coverTrigger replenishment review today, pause scale tests, and sync low-stock language to page and support
B-12 drawer organizer bundle230 Available - 20 Committed = 210 sellable units; 210 / 12 = 17 normal days of cover; 210 / 28 = 7 campaign days of coverNormal coverage looks acceptable, but campaign cover will break the 21-day lead time quicklyStage the campaign, set a daily sales cap, and prepare substitute SKUs plus back-in-stock capture
D-03 old-color organizer bag510 Available - 30 Committed = 480 sellable units; 480 / 3 = 160 normal days of coverThis is not stockout risk; it is deep stock with slow turnStop replenishment, do not reorder for a lower unit cost, and move to bundle, repeat-customer add-on, or clearance test

Why this step matters

The media owner sees whether ads can scale, purchasing sees whether to order, and page plus support see whether promises can hold. Days of cover connects those decisions: below lead-time cover means throttle first; weak campaign cover means stage the promotion; too much cover means handle cash and clearance before buying more.

Work one four-day gap before you forecast a campaign

A-07 is deliberately an established SKU, not the unvalidated pet rear-seat-protector research idea from the preceding lesson. The point is to show the order of an inventory judgment. On Monday, the operations owner reconciles the same dated inventory snapshot: `68 Available - 12 Committed = 56` units that this lesson treats as sellable. At normal velocity, `56 / 4 = 14` days of cover. Supply then validates the actual total lead time from recent receipts: `10 production days + 6 freight days + 2 receiving days = 18 days`.

That creates the first operating fact: `18 - 14 = 4` days of exposure. It does not predict an exact four-day stockout date, and it is not a universal Shopify or marketplace threshold. It says this May planning snapshot cannot carry its own recent replenishment cycle. The local reorder point makes the shortfall more visible: `4 normal units per day x 18 lead-time days + 40 safety units = 112 units`. With 56 sellable units, `112 - 56 = 56` units sit below the local reorder point. That is a review trigger, not a blind purchase quantity, because inbound status, cash, MOQ, and forecast quality still change the order.

Give the row to named people before discussing a campaign. Operations owns the dated Available, Committed, hold, and location reconciliation. Supply attaches the recent three-receipt lead-time evidence, the next receiving date, and any split-shipment risk. The media owner freezes new scale tests and keeps only the already-approved stable budget. Merchandising and support use only a delivery date that the receiving evidence can support; if no date is reliable, they offer a substitute SKU or back-in-stock capture instead of a vague promise. Finance checks whether the deposit and balance timing crowd out approved creative, media, or core-SKU cash.

The decision has a stop line as well as a replenishment line. Continue only with a small, stable media cadence if the next receipt has a dated receiving path, the page can make an accurate promise, and the purchase cash does not break the store's contribution and cash guardrails. Throttle further if the 18-day lead time is still the best evidence. Pause the affected market or campaign if sellable stock, location availability, or the receiving date cannot be reconciled. A preorder is not an automatic escape hatch: without a support-owned ship-date explanation and a delivery path that can be checked, it simply transfers the inventory uncertainty to a customer and refund queue.

At Friday review, record the starting snapshot, arithmetic, owner, evidence date, blocked action, and next verification date. The row should read like a decision someone else can challenge: A-07, 56 sellable, 14 normal days, 18-day actual lead time, replenish plus throttle, no new scale test until receipt evidence and cash review pass. That record is reusable because a later delay, campaign spike, or corrected committed count can change one input and make the next action visibly different.

Lesson output: inventory review cadence sheet

Split inventory judgment into daily alerts, weekly replenishment, and pre-campaign capacity checks.

CadenceWhat to reviewAction
Daily alertLow stock, abnormal sales, out-of-stock SKUsPause or adjust ads and page promises
Weekly replenishmentSales baseline, lead time, safety stock, MOQCreate replenishment recommendation and owner
Pre-campaign checkPeak demand, warehouse capacity, shipping timingDecide campaign SKUs and stock boundary

Inventory Is a Growth Problem, Not Just a Warehouse Problem

Many teams only care about inventory after a stockout or overstock problem appears. But inventory directly affects ad scaling, SEO continuity, customer-service volume, repeat purchase, and cash-flow safety. If a product keeps selling out, ad algorithms lose stable conversion signals, existing customers move to alternatives, and support gets flooded with when will it restock? questions. If a product is overstocked, cash is trapped in the warehouse and the team has less budget for creative, ads, and new product tests.

Inventory Planning Must Protect 4 Lines

  • Avoid stockouts: core SKUs must support ads, organic traffic, and repeat-purchase demand
  • Avoid overstock: new and weak SKUs should not be scaled with large inventory bets
  • Avoid random replenishment: buying decisions should follow sales velocity, margin, lead time, and inventory turnover
  • Avoid operational chaos: preorder, low-stock, exchange, and delayed-shipping rules must be clear

Common Inventory Mistakes

  • Only looking at yesterday’s sales: ignores ad budget, campaign timing, seasonality, and supplier lead time.
  • Using bestseller logic for every SKU: core products still run out while long-tail variants fill the warehouse.
  • Treating stockouts as a good sign: it may look like demand is strong, but repeated stockouts hurt ad learning and customer trust.
  • Using preorder as a universal fix: preorder without a reliable ship date and support playbook creates refunds and negative reviews.

Start With an Inventory Data Baseline

Before forecasting demand, make sure inventory data is decision-ready. Many stores do not fail because they cannot forecast; they fail because core fields are missing. They do not know real sellable stock, in-transit stock, supplier lead time, daily sales velocity, stockout days, or each SKU’s margin contribution.

Minimum Inventory Table Fields

1 SKU basics: product name, variant, supplier, purchase cost, weight, dimensions, fragile status, and special shipping requirements
2 Stock status: sellable stock, reserved stock, in-transit stock, allocated stock, and stockout days
3 Sales velocity: 7-day, 14-day, and 30-day average daily sales, separated for promotional and non-promotional periods
4 Supply-chain parameters: supplier production time, freight time, warehouse receiving time, and MOQ
5 Business metrics: gross margin, refund rate, ad spend, conversion rate, repeat purchase, and inventory turnover days
💡

Do Not Rely Only on the Shopify Inventory Number

Shopify can tell you current stock, but business decisions also need ad plans, supplier lead time, in-transit inventory, slow-moving risk, and cash-flow impact. A practical setup is to combine Shopify orders, ad budgets, purchase orders, and supplier lead times into one weekly inventory sheet.

Inventory stateWeekly-review meaningLesson action
On handTotal inventory at a location; it is not the sellable number.Use as context, not as the direct signal for scaling.
AvailableSellable stock not tied to orders, holds, or location rules.Use it for normal days of cover and campaign days of cover.
CommittedInventory tied to paid but unfulfilled orders.Do not sell it again; subtract it from growth capacity.
UnavailablePhysically present but not sellable because of QA, damage, reserve, or app hold.Check the hold reason and decide whether to release, isolate, or fix rules.
IncomingTransfer or purchase-order stock that has not been received yet.Use it for receiving forecasts and replenishment gaps, not immediate shipping promises.

Forecast Demand by Forecasting Demand You Can Actually Fulfill

Demand planning is not as simple as multiplying the last 30 days of sales by the number of future days. Independent-store demand is shaped by ad budget, creative fatigue, promotions, seasonality, SEO ranking, social content spikes, and past stockouts. Separate baseline demand, ad-driven demand, campaign demand, and one-time spikes.

Baseline sales
Use the last 14/30/60 days of daily sales as a baseline.
Exclude stockout days, abnormal discount days, and one-time viral spikes.
Traffic plan
Review upcoming ad budgets, SEO ranking changes, email campaigns, and social content calendars.
If budget will double, past sales cannot be used as a static forecast.
Seasonality
Holidays, weather, back-to-school, gifting periods, and category cycles change demand.
Seasonal SKUs need replenishment dates calculated backward from supplier lead time.
Promotions
Black Friday, anniversaries, clearance campaigns, creator collaborations, and launches create short-term spikes.
Campaign forecasts should be modeled separately from normal daily sales.
Supply limits
Supplier capacity, MOQ, freight time, and customs risk decide whether demand can be fulfilled.
Being able to sell does not mean being able to deliver consistently.

A Practical Forecasting Formula

Forecast demand = baseline daily sales × forecast days × traffic adjustment × seasonality/campaign factor

Suggested reorder quantity = forecast demand + safety stock - current sellable stock - in-transit stock

This is not a finance model. It is an operating model. The point is to update assumptions weekly and record forecast error so the next forecast becomes more accurate.

Forecast error ledger fieldWhat to writeHow to use it next time
Forecast version/dateThe forecast version and date used this week.Prevents next week from guessing which assumption drove the order.
Expected normal daily salesExpected daily sales after removing stockout days, abnormal discounts, and one-time spikes.Use it as the next normal baseline instead of polluting baseline with campaign peaks.
Actual normal daily salesThis week's actual normal daily sales.Compare it with forecast to decide whether the coefficient needs correction.
Variance % / reason tagVariance percentage plus reason tag such as stockout, promo, creator spike, ad budget, seasonality, page issue, or feed mismatch.If it misses for two weeks, recalculate baseline, media boundary, or reorder point.
Next correctionThe coefficient, order quantity, campaign cadence, or ad cap to change next week.Turns demand planning into a reviewable forecast error ledger instead of a post-meeting guess.

Reorder Points and Safety Stock Reduce Guesswork

A reorder point is the stock level that triggers a replenishment decision. Safety stock is the buffer that protects against demand variation and supply delays. Independent stores do not need advanced algorithms at the beginning, but they do need clear rules so replenishment does not depend on memory or mood.

Basic Calculation Method

1 Calculate average daily sales: use the last 14 or 30 normal selling days and exclude stockout days
2 Confirm total lead time: production time + freight + customs + warehouse receiving and put-away time
3 Set safety stock: based on supply stability and sales volatility, start with 7-21 days of demand
4 Calculate reorder point: reorder point = average daily sales × total lead time days + safety stock
5 Create alerts: when sellable stock drops below the reorder point, trigger a purchasing review

Safety Stock Is Not More Is Always Better

The purpose of safety stock is not to eliminate every possible stockout. It is to reduce stockout risk for key SKUs within an acceptable cash-flow burden. New products, trend products, and seasonal products should not carry excessive safety stock, or the buffer becomes dead inventory after demand fades.

Segment SKUs Because Different Products Need Different Rules

Using the same replenishment rule for every SKU is a common cause of inventory failure. Segment SKUs by sales volume, margin, supply risk, and strategic value. Bestsellers need stable availability, profit SKUs need protected supply, new SKUs need small-batch testing, and long-tail SKUs need strict inventory control.

A-class core SKUs

High sales, strong margin, and important to ads or repeat purchase. Keep higher safety stock, lock supplier capacity early, and slow ad spend before a stockout hits.

B-class profit SKUs

Not always the highest-volume products, but strong margin contributors. Use them in bundles, add-ons, and repeat-purchase offers. Keep supply stable without overexpansion.

C-class test SKUs

New products or new variants. Start with small batches and short learning cycles instead of buying heavily just to lower unit cost.

D-class cleanup SKUs

Slow sales, weak margin, high refund rate, or hard-to-sell content angle. Reduce replenishment, use bundles or clearance, and remove them from ads when needed.

Monthly SKU Review Checklist

  • Which SKUs contribute most sales and gross margin
  • Which SKUs repeatedly stock out and waste ad or organic traffic
  • Which SKUs turn slowly and hold cash without strategic value
  • Which variants sell poorly and should be merged, retired, or stopped from replenishment
  • Which SKUs have high refund rates and require expectation-setting changes or promotion cuts

Design the Low-stock, Stockout, and Preorder Experience Before It Happens

Stockouts are sometimes unavoidable, but the customer experience can be controlled. Do not let users discover the problem only after landing on a product page. Do not open preorder without a reliable fulfillment date. Prepare low-stock messaging, back-in-stock notifications, alternative recommendations, preorder rules, and support scripts in advance.

Low stock
Show stock or shipping urgency clearly without fake scarcity.
At the same time, tell the ad team to control budget before the SKU sells out.
Temporary stockout
Enable back-in-stock notifications and recommend alternatives.
Keep the SEO page alive, but avoid sending users into a dead purchase path.
Preorder
Clearly state estimated shipping time, cancellation rules, support contact, and delay handling.
Use preorder only when supply certainty is high enough.
Retirement
For long-term supply issues, low margin, or high support risk, stop promotion completely.
Redirect attention to alternatives or collection pages to avoid traffic waste.
Preorder / Backorder release gatePass conditionAction if it fails
Expected receiving or shipping dateA verifiable date exists and can be stated on the page.Do not open preorder; use back-in-stock capture or substitute SKU.
Feed availabilityMerchant Center uses the correct preorder / backorder / out_of_stock value and availability_date.Fix feed and landing-page consistency before restoring ads.
Checkout and shipping regionCheckout can ship to that market, and timing matches the page promise.Freeze scale in that market and fix shipping profile plus page promise.
Support and cancellation ruleSupport can explain timing, cancellation/refund, substitute SKU, and delay handling.Keep only back-in-stock capture instead of turning pressure into an unprepared preorder.
Payment and preorder app boundaryPayment method, preorder app, store rules, and customer-market rules all allow this promise.Downgrade the campaign, pause spend, or switch to a fulfillable SKU.
📣

When Stockout Risk Appears, Sync 4 Team Actions

  • Ads: reduce or pause spend on the risky SKU and shift budget to alternatives.
  • Page: update stock status, back-in-stock forms, alternative recommendations, and shipping notes.
  • Support: align scripts for restock timing, cancellation, exchange, and compensation.
  • Purchasing: confirm supplier lead time, in-transit status, and next receiving date.

Bring Supplier Lead Time Into the Growth Plan

Inventory planning cannot only look at front-end sales. It must include how controllable the supply chain is. Supplier reliability, MOQ, holiday delays, and backup options determine whether the store can scale without breaking fulfillment.

Supplier Evaluation Dimensions

  • Lead-time reliability: whether past orders were delivered on time and whether delays were explainable
  • Small-batch capability: whether the supplier supports test-stage replenishment instead of requiring large upfront bets
  • Quality consistency: whether batches vary in color, size, finish, packaging, or defect rate
  • Scaling capacity: whether the supplier can increase production when ads scale
  • Backup options: whether there is at least one alternative supplier or substitute SKU

Do Not Let MOQ Decide the Business Strategy

Lower unit cost often comes with higher MOQ. But when a new product is not validated, buying large quantities to reduce purchase cost is dangerous. In the early stage, inventory turnover and learning speed matter more than the lowest unit cost.

Lead Time Variance LedgerHow to record itWeekly-review action
standard lead timeNormal production, freight, customs, 3PL receiving, and put-away days.Use it as the baseline for reorder point; do not rely only on a supplier promise.
recent actual lead timeThe actual lead time and split-receipt pattern from the last three batches.If variance grows, add safety stock for A SKUs and reduce MOQ or split orders for C SKUs.
delay reasonProduction queue, freight, customs, receiving, QA, or supplier backlog.Choose purchasing follow-up, media throttle, page note, or support sync.
buffer decisionWhether this week changes safety stock, last order date, or backup supply.Put lead time variance into the weekly review before the stockout needs explaining.

Weekly Inventory Operating Cadence

Inventory management does not require a daily meeting, but it does require rhythm. Run a weekly inventory review that connects sales, ads, support, purchasing, and finance so every team is not making decisions from a partial view.

1 Review risk list: SKUs likely to stock out in the next 14/30 days and SKUs with excessive inventory days
2 Review growth plan: next week’s ad budget, email campaigns, creator content, promotions, and launches
3 Make replenishment decisions: confirm quantity, supplier, expected receiving date, and cash-flow impact
4 Make cleanup decisions: choose which SKUs need clearance, bundles, no replenishment, or ad removal
5 Review forecast error: record where forecasts were too high or too low and why

Weekly Inventory Metrics

  • Days of supply: how many days current inventory can support
  • Stockout risk: which SKUs will run out before the next receipt
  • Inventory turnover days: whether cash is locked for too long
  • Slow-moving inventory: SKUs and variants with weak movement after 90 days
  • Forecast error: why actual sales differed from forecast by more than 20%

Final Takeaway: Inventory Capacity Determines Whether Growth Can Be Fulfilled

Product research decides what you sell, advertising creates demand, and inventory determines whether that demand can be fulfilled consistently. Good inventory management is not conservative. It keeps core products available, prevents test products from trapping cash, removes slow movers early, and keeps supplier cadence aligned with the growth plan.

What You Should Build After This Article

  • Create an inventory baseline table with sellable stock, in-transit stock, daily sales, lead time, and margin
  • Set reorder points and safety stock for core SKUs instead of replenishing by instinct
  • Manage SKUs by A/B/C/D segments so long-tail inventory does not drain cash
  • Prepare page, ad, support, and purchasing actions for low-stock, stockout, and preorder scenarios
  • Review forecast error weekly so inventory planning becomes a system instead of a guess

split inventory forecasts into baseline and peak demand

Georgia Institute of Technology related arXiv research treats multi-week retail and ecommerce forecasting as especially difficult around high-stakes sales events. For independent stores, the practical move is to separate baseline demand, event peaks, supply limits, and cash pressure instead of using the last 30 days of sales as one answer.

Forecast layerInspectNext owner
BaselineNormal 14/30/60-day sales, excluded stockout days, ad budget changesOperations owner updates forecast error weekly
Event peakPromotion, content spike, gifting season, creator push, email scheduleCampaign owner locks peak stock and fallback SKUs
Supply limitProduction, freight, receiving, MOQ, in-transit inventorySupply owner writes the latest order date
Cash pressureTurnover days, clearance risk, ad and creative budget tradeoffFinance or growth owner approves large buys

Inventory Demand Board: put inventory, cash, and demand forecast on one weekly board

The inventory review should not only read stock counts. A useful weekly board writes three decisions on the same row: how long stock can carry demand, how much cash replenishment or clearance will lock or release, and whether next week’s ads, email, creators, or campaign plan will create extra demand. The team is not asking “how many units remain.” It is deciding whether this week should scale, cap, replenish, clear out, fix data, or pause.

Inventory-demand scenarioCash signalDemand triggerThis-week action and route
A core SKU below reorder pointReplenishment locks cash, but stockout damages ad learning, repeat rhythm, and hero-page trust.Days of cover are below total lead time, and Incoming does not have a confirmed receiving date.Open same-day replenishment review; throttle media, sync page/support, and continue to cash flow, inventory, and ad spend rhythm.
Campaign peak breaks coverageReplenishment cannot arrive in time, and urgent buying may create post-campaign overstock. Cash should not chase a short peak blindly.Campaign daily sales push coverage below total lead time, while substitute SKUs and back-in-stock capture are not ready.Stage the campaign, cap volume, split email waves, release media budget daily, and continue to merchandising calendar and campaign planning.
Deep stock locks cashCoverage is over 90 days while conversion, refunds, or media efficiency worsens. Replenishment cash should move to core SKUs, creative, or new tests.Supplier discount, MOQ deal, or a full warehouse does not prove real demand remains.Stop replenishment, use bundles, repeat-customer add-ons, or clearance tests, and continue to pricing, margin, and promotion strategy.
Market or location stock mismatchWrong promises create refunds, reshipments, support cost, and wasted media; that can cost more than selling fewer orders.Available, Committed, Unavailable, On hand, Incoming, location rules, and market availability are not aligned.Freeze scale in that market, fix inventory states, page promise, Feed stock state, and support language, then continue to product data source of truth.
Replenishment cash-flow fieldWhat to fill inDecision
PO payment dateDeposit, balance payment, and supplier payment dates.Decide whether replenishment will crowd out ad, creative, or next-test cash.
Expected receiving dateExpected warehouse arrival, 3PL receiving, and put-away date.Decide whether the store can support a campaign or must stage the launch.
Shopify payout delayPayout cycle, reserve, or payment-provider delay.Check whether sales cash can cover the next purchase order.
Campaign spend before receiptAd, email, and creator budget planned before the next receipt.Throttle when stock cover is weak so demand does not outrun receiving.
Inventory aging bucket / clearance floor0-30, 31-60, 61-90, 90+ day stock and the break-even or controlled-loss price floor.Choose clearance, bundle, no replenishment, or cash release.

Your copyable lesson notes should leave one line: inventory-demand scenario, cash signal, demand trigger, this-week action, blocked move, and next route. Without an action word, the meeting is only inventory reporting, not inventory review.

Inventory, cash flow, and ad cadence table: do not let buying and scaling trip over each other

Inventory decisions usually fail not because the formula is hard, but because purchasing, media, and finance each read a different sheet. Purchasing sees a lower unit cost and wants to order. Media sees acceptable ROAS and wants to scale. Finance sees cash tied in stock and starts pushing back. The weekly review needs one shared row: how long stock can sell, how much cash replenishment will lock, and whether ads can keep pushing this week.

If you need to connect inventory pressure to profit judgment, go back to Cash Flow, Inventory, and Ad Spend Rhythm. If you need to decide whether channel budget should move, continue to Multi-channel Advertising. This table gives the inventory lesson a practical boundary for scale, cap, replenish, replace, clear out, or pause.

Business scenarioInventory judgmentCash-flow judgmentAd cadenceThis-week blocked move
A-class core SKU is below reorder pointDays of cover are below total lead time, and Incoming does not have a confirmed receiving dateReplenishment cash is acceptable because stockout would damage ad learning and repeat purchaseDo not scale new creative; keep brand search and remarketing; set a sellout alertIncrease budget only because ROAS still looks good
Campaign bundle has only 7 peak days of coverNormal sales look fine, but campaign daily sales will break coverageReplenishment cannot arrive in time; extra buying may create post-campaign overstockStage the campaign, cap daily sales, prepare substitute SKUs and back-in-stock capturePush email, creator content, and ads at full force on the same day
D-class old color has 160 days of coverThis is not stockout risk; cash is locked in slow-moving inventoryReplenishment cash should move to core SKUs, creative, or new testsStop acquisition ads; use bundles, repeat-customer add-ons, or clearance testsOrder more because the supplier lowered the unit cost
Market inventory source is mismatchedShopify total stock looks enough, but the target-market location cannot fulfillWrong promises create refunds, reshipments, and support costFreeze scale in that market, then fix location/market rules and Feed stock stateKeep pushing Canada or EU ads from total stock alone

Weekly closeout standard

Every priority SKU needs one action word: scale, cap, replenish, replace, clear out, or pause. Without an action word, the meeting is only inventory reporting, not inventory review.

Copyable lesson notes: do not write "keep watching" in the inventory review

The easiest mistake in inventory work is reading "we still have stock" as "we can keep scaling." Start with Current inventory pressure, first evidence, and this-week blocked move, then state whether stock is sellable, how long it can carry demand, when the next receipt arrives, whether media or campaigns need throttling, and which move is blocked this week.

Note row What to write Why it matters
Inventory pressure Campaign peak, supplier delay, deep slow stock, or market inventory mismatch. Define the pressure first so the team does not call every issue low stock.
First evidence Available, Committed, Unavailable, On hand, Incoming, days of cover, reorder point, and total lead time. Total stock alone hides committed, unavailable, inbound, and location-limited inventory.
This-week action Scale, throttle, replenish, small-batch watch, clear out, fix inventory state, or pause promotion. The weekly review must leave an action, not only a feeling or vague observation.
Blocked move Scaling below lead-time cover, overbuying from one spike, or reordering because stock is deep. A blocked move keeps next week from restarting from the same mistake.

Inventory pressure router: check whether inventory can carry ads and campaigns

Inventory planning is not only a purchasing task. Before a campaign, creator push, email drop, or ad budget increase, the team should ask whether sellable stock, incoming stock, locked stock, supplier lead time, and page promises can support the extra demand. If the answer is unclear, the correct move is not to scale first and explain later. Route the pressure, check the proof, and write the boundary back into the weekly inventory review.

ScenarioHidden riskProof to check firstWrite back to inventory review
Campaign lifts demandAds sell faster than the next purchase order can arrive.Days of cover after the planned budget increase, in-transit units, and fallback SKUs.Set a daily budget cap and a sellout alert date before launching.
Supplier delay by 7 daysThe old reorder point is no longer safe because lead time changed.Updated production, freight, receiving, and safety-stock assumptions.Recalculate reorder point and tell ads, page, support, and purchasing owners.
Deep stock, slower salesHigh inventory can hide weak demand and trap cash.Sell-through trend, margin, return risk, and whether the SKU still deserves ad spend.Move to clearance, bundle, or stop-buy status instead of buying more.
Channel inventory mismatchShopify, warehouse, marketplace, and ad catalog may not show the same available stock.Available, committed, unavailable, on-hand, and incoming stock by channel.Freeze scale decisions until the inventory source of truth is corrected.

This router gives growth teams a simple operating rule: no campaign scale without an inventory answer. The answer can be "go", "cap", "replace", "replenish", or "pause", but it must be written before the demand is created.

Post-lesson FAQ

After the lesson, resolve these common questions

If inventory planning is not an admin screenshot, what should it decide?

It should decide how long the SKU can safely sell, whether it can support ads or campaigns, and whether cash is stuck in the wrong stock. In Shopify, On hand, Available, Committed, Unavailable, and Incoming do not mean the same thing. On hand means it exists somewhere; Available is closer to sellable; Committed is already tied to orders; Unavailable may be held, reserved, or in the wrong place. A weekly inventory review should state sellable stock, days of cover, reorder point, and this week's action.

When should ads stop scaling because of inventory?

When days of cover are lower than the replenishment lead time, or when campaign days of cover will be used up too fast, do not scale budget. If a core SKU has only 14 days of sellable cover but the supplier lead time is 21 days, more ads will push orders, support, and fulfillment into stockout risk. The rule is simple: if stock cover is shorter than replenishment time, do not increase spend.

Why should stockout and overstock be reviewed together?

A stockout breaks ads, campaigns, and repeat-purchase promises. Overstock locks cash into SKUs that are not moving and leaves less money for winners. Inventory planning is not only about avoiding stockouts or clearing old stock. Segment SKUs: A-tier core SKUs need reorder points and safety stock, campaign SKUs need campaign days of cover, and slow movers need cash, clearance, and refund-risk decisions.

How should I use the inventory coverage calculator?

Start with sellable units: Available minus quantities already tied to orders, holds, or unsafe locations. Divide that by average daily sales to get normal days of cover. Before a campaign, calculate again with campaign daily sales. Then compare cover, lead time, safety stock, and reorder point instead of only reading the total units in the admin.

How should I use the Inventory Demand Board?

Use it as the weekly board for inventory, cash, and demand forecast. Pick the closest scenario: core SKU below reorder point, campaign demand burning through stock, deep stock locking cash, or market/location inventory mismatch. Then write the cash signal, demand trigger, this-week action, blocked move, and next route so the review does not end with "keep watching".

What should I check before a campaign?

Do not use only normal daily sales. Check whether campaign traffic will burn through the stock faster. If a SKU has 17 normal days of cover but only 7 campaign days of cover, split the launch, set a daily sales ceiling, prepare a backup SKU, or downgrade the campaign. Campaign planning should match inventory cover, ad cadence, Email cadence, and fulfillment promise.

What if a market says the product is buyable but the local location cannot fulfill it?

That is not just an ad issue or a simple stock issue. It is a mismatch between market, location, feed, and fulfillment rules. Check Shopify location, market availability, shipping profile, Merchant Center availability, page promise, and checkout shipping area. Do not add budget to that market until the mismatch is fixed.

What decision does the inventory pressure router help with?

It routes pressure into replenish, throttle ads, split the campaign, clear stock, fix feed/location data, or pause promotion. An A-tier SKU below reorder point needs replenishment and spend control. A campaign SKU with weak cover needs a split launch. Deep stock needs cash recovery. Market mismatch needs data and fulfillment repair first.

What should weekly inventory copyable lesson notes include?

Write the current inventory pressure, SKU, Available, Committed, On hand, Incoming, normal days of cover, campaign days of cover, lead time, safety stock, reorder point, cash signal, demand trigger, this-week action, blocked move, responsible reviewer, and review date. Copyable lesson notes should not say only "keep watching"; they should name the first evidence and this-week blocked move.

Lesson HowTo steps

Complete this lesson step by step

  1. 1

    Choose the SKUs and market scope for this week

    Start with A core SKUs, B profit SKUs, C test SKUs, and D clear-out SKUs, then state the market, location, and campaign scope for this review. Do not start from total store inventory; start from the SKUs that affect growth and cash this week.

  2. 2

    Split official inventory states

    Write On hand, Available, Committed, Unavailable, and Incoming from Shopify, the warehouse, or WMS. Do not read only total inventory. Decide what is truly sellable and what is already tied to orders, holds, quality checks, locations, or market rules.

  3. 3

    Align purchase sheet and supplier lead time

    Put ordered quantity, expected receiving date, MOQ, payment status, inbound status, and recent real production, shipping, customs, and receiving days into the same table. Replenishment decisions cannot rely only on current Shopify inventory.

  4. 4

    Clean normal daily sales and campaign peak

    Build the baseline from 14/30/60 normal selling days and remove stockout days, abnormal discounts, one-time spikes, and campaign days. For campaign SKUs, separate normal daily sales from campaign daily sales.

  5. 5

    Calculate normal and campaign cover

    Use the inventory coverage calculator: subtract locked or unusable units from Available, then divide by normal daily sales and campaign daily sales to get normal days of cover and campaign days of cover.

  6. 6

    Record lead time variance

    Write standard production, freight, customs, receiving, and 3PL receiving time, then add the last three actual lead times and delay reason. If variance grows, adjust safety stock for A SKUs and reduce MOQ or split orders for C SKUs.

  7. 7

    Calculate safety stock, reorder point, and sellout date

    Use average daily sales, total lead time, and safety stock to calculate reorder point and expected sellout date. Below reorder point is not watch-and-wait; it triggers same-day replenishment review.

  8. 8

    Use the Inventory Demand Board to choose this week's action

    Choose the current inventory-demand scenario: core SKU below reorder point, campaign demand burning through stock, deep stock locking cash, or market/location inventory mismatch. Write the cash signal, demand trigger, this-week action, blocked move, and next route.

  9. 9

    Check the preorder and backorder release gate

    Only turn stockout pressure into preorder or backorder when expected shipping date, page copy, Feed availability, availability_date, checkout shipping region, support cancellation rule, and payment / preorder app boundaries all pass.

  10. 10

    Sync cross-team promises

    Send this-week action to ads, page, support, purchasing, Feed, and fulfillment owners. If cover is weak, throttle or stage the campaign first. If market/location data is mismatched, fix inventory and fulfillment promises first.

  11. 11

    Copy the weekly inventory copyable lesson notes

    Finish with weekly inventory copyable lesson notes: current inventory pressure, first evidence, SKU, normal days of cover, campaign days of cover, lead time, cash signal, forecast error ledger, this-week action, blocked move, owner, and review date. Do not write only "keep watching".

Back to Course Outline
17
View All Tutorials

Share this lesson with your reviewer

Share it with the copyable lesson notes so everyone reviews the same evidence, decision line, and next action.