Ecommerce Replenishment Planning: Calculate an Urgent Stock Top-Up

Keep inventory states separate

Track saleable stock, quantities allocated to orders, goods in transit, goods awaiting warehouse receipt and goods still in production separately. Do not count one batch in more than one state. Cargo that has reached a port but is not available for sale is not equivalent to stock on the shelf.

Review each product's quantity alongside its expected availability date. This can reveal a gap hidden by a healthy-looking total: there may be enough units overall, but current saleable stock could run out before the next batch completes receiving. The timing of availability matters as much as the quantity.

Use the full replenishment cycle

Include purchasing or production, packing, transport and receiving in the lead-time assessment. The main carriage is only part of that cycle. Separate normal demand from promotion effects and seasonal changes, and avoid projecting either an unusually strong day or a quiet day across the entire future period.

For a simple illustration, 300 saleable units at an assumed average demand of 10 units per day represent about 30 days of static coverage. This is a discussion baseline, not a forecast. Allocated orders, changing demand and uncertainty about when replenishment becomes available still need to be considered.

Give transport options different jobs

For products with relatively stable demand and sufficient preparation time, assess a routine batch plan. If a small number of critical products face a stock gap, calculate the quantity and cost of a targeted urgent shipment. Routine stock need not travel as fast as the urgent items.

Splitting also adds documents, handling and warehouse administration, so compare the full cost with expediting the entire consignment. Where possible, plan carton references and packing so batches can be separated cleanly. Picking urgent items out of mixed cartons at the last minute can introduce errors and delay handover.

Create regular decision points and learn from exceptions

Agree how often to update sales, saleable quantities, production progress and inbound milestones. Define what prompts a fresh mode comparison, such as a widening projected stock gap or a warehouse appointment moving later than planned. Assign someone to start the review so the decision does not fall between teams.

After an urgent shipment, record whether the cause was demand change, production, documents or transport connections. Repeated causes deserve changes earlier in the process. For new or low-volume products, smaller initial batches can help establish actual demand and receiving data before revising the plan. Use urgent transport when needed, and address recurring causes of last-minute shipments.

Worked example: calculate the urgent top-up quantity

Illustrative assumptions: at the start of Day 1, one SKU has 300 unallocated saleable units. Demand is a constant 10 units each day. The routine shipment becomes saleable at the start of Day 41; an urgent shipment could become saleable at the start of Day 21. No other stock arrives, and the planning target is a 30-unit buffer immediately before the routine shipment. These assumptions are not a demand forecast or transport promise.

Check the arrival window and carton rounding

Without the urgent batch, stock reaches zero at the end of Day 30. An urgent arrival after the start of Day 31 therefore fails to prevent a gap, even if the quantity is adequate. Check the date the warehouse can release stock, not only the date the vehicle arrives.

If dispatch is only possible in 24-unit cartons, round 130 up to six cartons: 144 units. The expected buffer then becomes 44 units. Update the packing list and freight calculation for those six actual cartons; do not quote 130 loose units if that is not how they will ship.

Compare the urgent shipment’s extra freight, document, handling and receiving costs with the likely business cost of the shortage. Recalculate by SKU when demand, allocations or saleable-arrival dates change. A buffer expressed in units is a chosen planning assumption, not a substitute for reviewing uncertainty.

• Calculate the packed volume and weight of the urgent cartons ↗

Stress-test demand before choosing the urgent quantity

Reuse the earlier assumptions: 300 unallocated saleable units at the start of Day 1, an urgent receipt at the start of Day 21, routine stock at the start of Day 41 and a chosen 30-unit buffer. Vary only daily demand. Required urgent units U = max(0, daily demand × 40 + 30 − 300), then round up to complete 24-unit cartons.

The final-day quantity is only one check. At 16 units per day, the projected balance before the urgent receipt is 300 − 20 × 16 = −20. That negative number represents demand that cannot be filled from the opening stock, not physically negative inventory. Shipping 384 units on Day 21 cannot undo that earlier gap, even though the arithmetic balance after all forty days is positive. The final column subtracts all modelled demand, including units that could not be filled on time. It is a planning balance, not a prediction of physical stock after lost sales.

Shopify distinguishes Available stock from Committed, Unavailable and Incoming stock. Use the quantity actually available to the plan, and do not count incoming units as if they were already ready for sale. If your warehouse adds inspection or stock-release steps, use the date those steps finish.

• Calculate a dated balance: previous balance + receipts released for sale − demand. Check every interval before a receipt, not only the end of the planning period.
• If a shortage occurs before the urgent arrival, test an earlier feasible receipt, a smaller earlier bridge batch or an agreed change to sales commitments.
• Have the inventory owner refresh demand and allocations; have the shipping coordinator confirm the revised saleable-arrival assumption before approving the freight spend.

• Shopify: inventory states — checked 18 October 2026 ↗