SellerStrat
Supplier order

Calculate how much to order without counting inbound stock twice

A useful order recommendation covers demand until the next replenishment and subtracts both available stock and confirmed inbound units.

Reviewed: SellerStrat Editorial Team
Short answer

Multiply average daily sales by lead time plus safety days, then subtract available stock and confirmed inbound units. Never subtract unconfirmed supply drafts.

Grand total

PlanningStock at warehousesLiquidationOrder from supplierOrderedPurchase requestsIn transit
SKU8
Total at warehouses128,3
In transit64
Urgent order210,7
Excess stock255,3
No sales299,9
Liquidation354,7
Refresh OzonFilterSearch productsSupplier: allColumns
Tab: PlanningSupplier: allSales for: 30 daysOrder for: 28 daysSort: Seller code descending
SupplierSeller codeBarcodeRecommended orderStock cover, daysDaily average ordersTotal ordersOrders from marketplace warehouse
MellowSS-410746070002109597727,57,8220190
FormaPlusSS-410646070002108228426,28,2234202
SeverTradeSS-410546070002106859124,98,6248214
BalanceGroupSS-410446070002105489823,69262226
LumoSS-4103460700021041110522,39,4276238
MellowSS-41024607000210274112219,8290250
FormaPlusSS-4101460700021013711919,710,2304262
SeverTradeSS-4100460700021000012618,410,6318274
Total:81222,9573,62 1521 856
Demo illustration · sample data
Calculation example

Reproducible order example

The example uses one SKU and confirmed inbound stock only.

12 x (18 + 7) - 96 - 84 = 120 units
Average daily sales
12 units
Lead time and safety window
18 + 7 days
Available and inbound stock
96 + 84 units

Recommended supplier order: 120 units.

Illustrative calculation. Replace every input with the current data for the same SKU and fulfillment model.

Use five controlled inputs

The recommendation depends on average daily sales, supplier lead time, safety days, sellable stock and confirmed inbound units. Use the same SKU and fulfillment scope for every input.

Calculate target stock before the order

Target stock covers expected demand during lead time and the selected safety window. The order is the positive difference between target stock and units already available or confirmed in transit.

Review exceptions before sending the order

A mechanical result still needs a check for promotions, seasonality, minimum order quantity, supplier packaging and stock that is blocked or unlikely to arrive.

Frequently asked questions

Should goods in transit be subtracted?

Subtract confirmed inbound units that belong to the same SKU and fulfillment scope.

What if the calculation is negative?

The immediate recommended order is zero; review excess stock and the next replenishment date.

Evidence and sources

How this material was reviewed

  • SellerStrat cabinet: stocks and recommended orderSellerStrat Product

    Input names and the treatment of available and inbound stock were checked in the current workflow.

SellerStrat Product and Data TeamProduct, analytics and integration specialists

Recalculated the example independently and checked every input against the stocks and supplier-order workflow.

Product version: SellerStrat 2.0
Stickers, barcodes and KIZ labels are free

Use SellerStrat with your store data

Start free