E-commerce
October 1, 2026
Wondering how to calculate stock truly available for sale? The answer lies in a simple formula: add quantities in transit, subtract unshipped orders and future sales. This metric is essential for avoiding stockouts and overselling.
The calculation becomes more complex with numerous SKUs, variable delivery dates, and perishable products. Poor estimation can lead to cancelled orders or unnecessary storage costs.
So how do you calculate stock available for sale? On the agenda:
What is the basic formula for available stock?
How do you integrate orders in progress and purchases in transit?
How do you manage future sales and delivery dates?
How do you forecast your supply needs?
What checklist is needed to make your calculation reliable?
Let's go.
Summary
Why does the stock available for sale differ from the physical stock?
Physical stock, or quantity on hand, represents the items present in your warehouse. This figure does not reflect the commercial reality. It ignores unshipped customer orders, incoming supplier purchase orders in transit, and planned future sales.
An accurate stock available for sale integrates these three elements. It allows you to know how many items you can actually promise to a customer. Without this calculation, you risk selling a product that you cannot ship, which damages your reputation.
The difference between these two concepts is crucial for daily management. Physical stock is a snapshot, whereas available stock is a dynamic projection. This projection helps you make informed decisions regarding your replenishment and delivery promises.
For example, if you have 100 units on hand but 30 are already reserved for customer orders, your available stock is only 70 units. This distinction allows you to avoid overselling and to maintain your customers' trust.
Convert over 2,000 customers on average per month with Qstomy.
The world’s 1st Shopify AI dedicated to customer conversion
Empowering 200+ e-commerce merchants
What is the basic formula for calculating available stock?
The basic formula is simple: Available Stock = (Quantity on Hand) + (Pending Purchase Orders) - (Pending Customer Orders) - (Future Sales). Each variable represents an incoming or outgoing flow of your inventory.
Pending purchase orders are supplier purchases already placed but not yet received. Pending customer orders are sales recorded but not yet shipped. Future sales include forecasts or contractual orders to be delivered later.
Let's take a concrete example. You have 140 units on hand, 200 units ordered from a supplier, 10 units sold but not shipped, and 20 units reserved for a customer. Your available stock is 310 units. This figure tells you what you can sell immediately.
This basic formula is the foundation of any effective inventory management. It allows you to respond quickly to customer demands and plan your future purchases with precision.
How do you include transit purchase orders in the calculation?
Not all purchase orders should be included in your calculation. A purchase order with a distant delivery date does not help you sell today. For example, if you ship within two days and your supplier order arrives in a week, including it distorts your available stock.
The adjusted formula becomes: Available Stock = (Quantity on Hand) + (Purchase Orders with delivery within X days) - (Pending Customer Orders) - (Future Sales). The parameter X represents your standard shipping lead time.
This approach prevents you from promising products that will not be available in time. It forces you to precisely track your suppliers' delivery dates. A purchase order in transit is only useful if it arrives before your shipping requirement.
In practice, set X based on your average delivery time. If you offer 48-hour shipping, only include purchase orders that will arrive within this timeframe. This ensures you only sell what you can deliver on time.
How do you manage future sales in the calculation of available stock?
Future sales complicate the calculation because they involve two dates: the supplier delivery date and the customer shipping date. A future sale should only be subtracted if its shipping date is prior to the receipt date of the purchase order.
For example, a customer reserves 20 items for next month. If your supplier delivers in three weeks and the customer order departs in four weeks, you can include this future sale in your calculation. The available stock decreases by 20 units.
This precise management avoids date conflicts. It requires rigorous tracking of each order. Companies with subscriptions or scheduled deliveries must particularly monitor these parameters to avoid stockouts.
For future sales, it is recommended to record them as soon as they are confirmed. This allows you to adjust your available stock in real time and react quickly if a supplier order is delayed.
How should product expiration dates be handled in the calculation?
Perishable products add a layer of complexity. An on-hand quantity can be unusable if it expires before the delivery date of the next purchase order. You must then subtract this percentage of expired products from your available stock.
The formula becomes: Available stock = (Quantity on hand) + (Purchase orders in X days) - (Pending customer orders) - (Future sales) - (Percentage of products expiring before delivery). This subtraction prevents you from selling items that you will not be able to deliver in good condition.
This variable is essential for the food, cosmetics, or pharmaceutical sectors. It requires you to know precisely the expiration dates of each batch. Rigorous tracking of expiration dates protects your reputation and reduces waste.
Implement a stock rotation system (first in, first out) to minimize losses. This allows you to sell the oldest products first and reduce the risk of expiration before sale.
How to forecast your supply needs with available stock?
Historical-based sales forecasting helps you determine your order quantities. For example, if you anticipate a need for 100 units for the next quarter, have 50 units on hand, and want to keep a minimum stock of 20 units, your supplier order should be 70 units.
The formula is: Order Quantity = (Future Sales) - (Quantity on Hand) + (Minimum Stock). This approach avoids costly overstocks and stockouts. It allows you to maintain a consistent level of service.
This method relies on reliable historical data. It requires regular tracking of your sales and stock levels. A good replenishment calculation improves your cash flow by avoiding tying up capital in unnecessary stock.
Use analytical tools to identify seasonal trends and adjust your orders accordingly. This allows you to meet demand without overstocking, thereby optimizing your profitability.
How to use a spreadsheet to calculate available stock?
A spreadsheet like Excel is an effective tool for managing available stock, especially with a limited number of references. You can create columns for each variable: quantity on hand, purchase orders, customer orders, future sales, and expiration dates.
Built-in formulas allow you to automate the calculation. You can also set up alerts when the available stock falls below a critical threshold. This approach is simple and does not require any additional investment.
For a small catalog, a spreadsheet is more than enough. It gives you a clear and editable view of your inventory. You can test different scenarios by changing the variables, which makes decision-making easier.
For growing businesses, consider upgrading to a more advanced inventory management software. This will allow you to manage a larger volume of data and further automate your processes.
What are the pitfalls to avoid when calculating available stock?
The first pitfall is to ignore supplier delivery dates. Including a purchase order that arrives too late distorts your available stock. The second pitfall is to neglect future sales with different shipping dates.
The third pitfall is to forget about expired products. An on-hand quantity can be unusable, which reduces your actual stock. Finally, not updating your data regularly makes the calculation obsolete.
To avoid these pitfalls, establish a daily or weekly update process. Check each variable carefully. An accurate calculation requires rigorous discipline in data entry.
Another common pitfall is not taking customer returns into account. Returns can increase your available stock, but they must be inspected to verify their condition before being reintegrated. Integrate this flow into your calculation for maximum accuracy.
How does available stock fit into Shopify management?
In the Shopify admin, inventory management is a core element. You can track on-hand quantities for each product variant. However, Shopify does not automatically calculate the stock available for sale with future sales and purchase orders.
You must therefore export your data or use apps to integrate these variables. Accurate tracking of available stock helps you avoid overselling. It also allows you to better plan your replenishments.
To go deeper, consult our complete guide to managing inventory in the Shopify admin. Rigorous management of your stock levels is essential for customer satisfaction and your store's performance.
Shopify also offers inventory reports that can help you identify slow-moving products. Use this data to adjust your orders and avoid overstocking.
How does available stock influence sales and cash flow?
Accurate available stock allows you to sell with confidence. You avoid order cancellations and refunds, which protects your revenue. You can also offer realistic delivery times to your customers.
Good management of available stock improves your cash flow. You avoid overstocking products that do not sell, thereby freeing up capital. You can invest in high-turnover items, increasing your profitability.
To optimize your sales, combine this calculation with smart product recommendations. This approach helps you offer the right products at the right time, maximizing your sales opportunities.
Accurate available stock also reduces storage costs. By avoiding overstocking, you decrease warehousing fees and the risk of product obsolescence.
How does Qstomy help make available stock and sales more reliable?
Qstomy, a Shopify AI agent, guides your customers toward purchasing by offering personalized recommendations. By analyzing purchasing behavior, Qstomy can suggest complementary products, increasing the average cart value. This approach boosts your sales without requiring additional stock.
Qstomy also manages parcel tracking and post-purchase support. In the event of a delivery delay, it informs the customer and proposes solutions. This responsiveness reduces refund requests and protects your reputation.
Finally, Qstomy helps with conversion by reducing friction during checkout. It can send reminders for abandoned carts and answer questions about delivery times. With over 100 merchants supported, Qstomy is a reliable partner for optimizing your store.
By integrating Qstomy with your inventory management, you can also receive alerts in the event of an imminent stockout. This allows you to react quickly and maintain a high level of service.
What checklist should you use to make your available stock calculation reliable?
Here is a checklist to ensure your calculation is reliable:
Quantity on hand: regularly verify your physical inventory.
Purchase orders: only include those with a delivery within your shipping lead time.
Customer orders: subtract all unshipped sales.
Future sales: integrate orders with a ship date before the supplier delivery.
Expiration dates: deduct products that will expire before the next delivery.
In brief
Stock available for sale is a key indicator to avoid stockouts and overselling. It is calculated by adjusting the quantity on hand with incoming and outgoing flows. Rigorous tracking improves your cash flow and customer satisfaction.
FAQ
What is the difference between physical stock and available stock? Physical stock is the quantity on hand, while available stock integrates pending orders and future sales.
Should I include all purchase orders in the calculation? No, only those with a delivery date compatible with your shipping lead times.
How to manage perishable products? Subtract the percentage of products that will expire before the next supplier delivery.
To go further: How to integrate Shopify with Amazon for products, stock, and reviews? - Qstomy, Can you sell Amazon products on Shopify? - Qstomy, How to create a payment gateway for an e-commerce site? - Qstomy, Does Texas levy a sales tax on online purchases? - Qstomy, Inventory management in the Shopify admin: complete guide - Qstomy.
Enzo
October 1, 2026
