Before You Scale Ads: A Stock Availability Checklist

CAMPAIGN STOCK REVIEW — original Growthcraft synthesis
[DECISION] Variant / market / fulfilment pool / campaign / owner / deadline:
[SNAPSHOT] Inventory source / timestamp / timezone / reconciliation owner:
Available units (already excludes committed, unavailable and incoming):
Additional campaign reserve / why chosen / double-count check:
[WINDOW] Start / end / number of days / no-replenishment assumption:
[DEMAND] Other units per day / source / excludes modelled paid orders:
Paid click-to-order conversion % / click definition / observation dates:
Units of this variant per paid order / currency / cost per click:
Proposed total spend / shared campaign allocation policy:
[SCENARIOS] Base / high-conversion-low-CPC / higher-other-demand:
For each: paid units / ending units / remaining above reserve / ceiling:
[GATE 1] Inventory definition and region/variant scope verified? evidence + owner:
[GATE 2] Non-overlapping demand and denominator verified? evidence + owner:
[GATE 3] Selected scenarios retain the chosen reserve? unresolved risks:
[GATE 4] Landing page / checkout / feed / structured availability aligned?
[ACTION] HOLD_FOR_EVIDENCE / REVISE_PLAN / BOUNDED_TEST_REVIEW:
Monitoring cadence / freshness limit / stop condition / response owner:
Finance contribution check / operations capacity check / approver:
Resume conditions / next review / unresolved evidence:
Do not treat a positive allowance as approval to spend or as a stockout guarantee.

Use this before a campaign promises more than you can ship

This framework is for ecommerce founders, D2C marketers and operations teams preparing a product launch, promotion or an increase in paid traffic. It answers whether the proposed demand fits a declared stock allowance. Use it for one variant and a fulfilment pool that can actually serve the target market. Do not use it as a multi-warehouse allocation engine, a safety-stock optimizer or a replacement for checkout inventory reservations.

Bring a timestamped inventory snapshot, the campaign window, other-channel unit demand, a compatible paid-click conversion estimate, units per paid order and the proposed spend. If those inputs are missing, the output is an evidence request, not a spend cap. Assign a marketing owner, operations owner, analyst and approver; one person can hold several roles but no responsibility should be implicit.

Four gates and a handoff

1. Verify what is sellable. Operations reconciles the chosen variant, locations, market restrictions and snapshot age. Start from available units, not warehouse on-hand totals. Exclude incoming stock until it is received and released. Record any extra campaign reserve separately from stock already unavailable.
2. Separate demand. The analyst documents other-channel units and paid-click-derived units as non-overlapping planning buckets. If a baseline contains the paid orders you add later, rebuild it. Use a click-based conversion fraction with click-based costs, and inspect bundles that consume more than one unit.
3. Test the constraint. Marketing checks base and explicitly chosen stress scenarios. Higher conversion and lower CPC consume stock faster for the same budget. If even other demand exceeds the allowance, revise the plan before evaluating paid spend. There is no universal reserve percentage.
4. Make the promise consistent. The ecommerce owner checks the actual selected variant through the landing page and checkout, then the product data and structured availability. Pausing promotion is different from declaring a sellable item out of stock. Confirm the implementation against current platform rules.

A passed arithmetic check leads only to a bounded-test review. The approver still considers contribution, customer commitments, warehouse capacity and the ability to respond to a sudden spike. An unverified definition means hold for evidence; negative headroom means revise the demand or availability plan.

Worked example: the campaign fits until conversion improves

Synthetic scenario: 500 available units, 60 extra reserved units and 14 days. Other demand is 10 units per day, leaving 500−60−140=300 for paid demand. With 12,000 currency units of spend, CPC 1, conversion 2% and one unit per paid order, paid demand is 240 units. Ending stock is 120, which is 60 above the reserve. The modelled spend ceiling is 15,000.

Now change only conversion to 3%. Paid demand becomes 360, ending stock 0 and the budget ceiling 10,000. A better marketing conversion rate breaks the original inventory plan. The correct response is to review a smaller or shorter campaign, replenish before a new window, or choose an eligible alternative product—not to present the base case as safe.

Turn the worksheet into an operating agreement

State the maximum acceptable snapshot age, who checks available units, and how long changing the campaign takes. Choose the reserve in relation to that response delay and business obligations; do not copy the synthetic 60-unit value. Recalculate with remaining days and remaining budget after each review. Keep past snapshots for explanation, rather than overwriting them with a newly convenient estimate.

Pause and investigate when input freshness fails, sellable quantities cannot be reconciled, or an agreed stock guardrail is breached. If a forecasted shipment arrives, verify receipt and release before starting a new scenario. Do not treat an expected arrival date as stock available today. Resume only after the responsible owner confirms the evidence and the customer-facing promise.

Where this framework can fail

Daily averages hide bursts, channels overlap, attribution can double-count orders, and one product may contain several constrained components. A shared ad campaign can shift its product mix. Inventory can also become unavailable after a quality check. None of these uncertainties is solved by a precise-looking budget number. For bundles or multiple regions, review the bottleneck separately and document allocation. Use a stochastic demand and lead-time model if you need a probability of stockout; this worksheet deliberately supplies none.

Sources and evidence boundaries

Checked October 15, 2026: Shopify: understanding inventory states distinguishes available stock from committed, unavailable and incoming quantities. Google Merchant Center: availability requires consistent availability across product data and the customer journey, including the selected variant. Both are living documentation with an unknown publication date. The planning model and worksheet here are original editorial synthesis, not vendor-endorsed controls. All examples are synthetic; no measured search volume, stockout probability or performance improvement is claimed.