SellerStrat
Guide · Stocks

Avoid shortages without locking cash in excess stock

Stock alone does not answer how much to order. The calculation needs sales pace, planning horizon, goods in transit, supplier lead time and safety stock.

Reviewed: SellerStrat Editorial Team
Short answer

Stock control combines sellable units, confirmed inbound stock and sales pace to show availability risk and prepare a supplier order.

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

Required inputs

Verify that inventory and supply states use a current date.

  • stock by SKU and warehouse
  • goods in transit
  • average sales
  • production and delivery lead time
  • minimum order and safety stock

Calculation sequence

Estimate demand until the next replenishment, subtract available and incoming stock, then account for safety stock and supplier constraints.

Shortage and overstock

Shortage removes product availability. Overstock ties up cash and increases storage and discount risk. Both require active control.

SellerStrat workflow

The stocks module connects warehouse stock, goods in transit, problem products and a supplier-order recommendation.

Frequently asked questions

Can I plan using last month sales only?

It is a baseline, but seasonality, promotions, incoming supplies and changing sales pace can materially change demand.

Evidence and sources

How this material was reviewed

SellerStrat Product and Data TeamProduct, analytics and integration specialists

Checked stock, inbound, deficit, overstock and recommended-order fields against the current interface.

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

Use SellerStrat with your store data

Start free