The big read / Buying stock
Cheaper stock. Costlier shelves?
A five percent supplier discount can cost more over a year. Compare the total cost, then check the cash needed now.

A supplier offers five percent off if you order six months of stock at once. The unit margin improves immediately on the spreadsheet. The money leaves the bank immediately too. Those are different effects, and a small shop needs to check both before accepting.
The decision is whether the purchase saving and fewer deliveries outweigh the extra cost and risk of holding that particular product. Then comes a second question: can the business afford the larger payment without starving a more important purchase?
Compare a year of demand, not two different invoices
A EUR2,000 order and an EUR11,400 order do not buy the same amount of stock. Comparing their totals tells you about cash needed now, but little about which purchasing pattern costs less over a year. Use the same expected sales volume for both options, then compare how you replenish it.
Start with one product or variant. Keep selling price and customer demand unchanged so the purchasing decision is visible. Separate the supplier price from delivery and ordering costs. Add only the storage, financing and stock-risk costs that change when the order size changes. Existing rent does not become an additional cash expense merely because an internal allocation assigns more of it to this product.
ACCA’s inventory-control guidance describes the underlying trade-off: larger orders reduce ordering frequency but increase average inventory. Its approach to quantity discounts compares purchasing, ordering and holding costs together. The example below is our own simplified calculation, not ACCA’s example or a merchant case study.
A five percent discount that costs EUR280 more
Hypothetical example, excluding VAT. A shop expects to sell 1,200 units over a year, evenly at 100 per month. It can buy 100 at a time for EUR20 each, or 600 at a time for EUR19 each. The discounted price applies to every unit in each qualifying 600-unit order. Each delivery/order costs EUR40 under either option.
Assume replenishment arrives exactly when needed, with no shortages or safety stock, and stock falls evenly to zero between deliveries. Average cycle stock is therefore half the order quantity: 50 versus 300 units. All 1,200 units eventually sell at the same retail price; this model does not assume a larger order creates more demand.
For the first scenario, assume an annual holding-cost allowance equal to 40 percent of average inventory purchase value. This deliberately demanding assumption combines relevant carrying costs and an expected stock-risk allowance. It is not a claimed industry benchmark or just a borrowing rate. A shop should replace it with its own estimate, avoiding double counting the same loss twice.
| Annual comparison | 100-unit orders | 600-unit orders |
|---|---|---|
| Units purchased and sold | 1,200 | 1,200 |
| Purchase cost | EUR24,000 | EUR22,800 |
| Orders per year | 12 | 2 |
| Ordering/delivery cost | EUR480 | EUR80 |
| Average inventory value | EUR1,000 | EUR5,700 |
| Holding allowance at 40% | EUR400 | EUR2,280 |
| Total modelled annual cost | EUR24,880 | EUR25,160 |
The purchase discount saves EUR1,200, and fewer orders save another EUR400. But the additional average inventory carries an extra EUR1,880 allowance. The larger order ends up EUR280 more expensive under these assumptions. A better unit price has not produced a cheaper annual purchasing pattern.
The model has not found the mathematically optimal order size among every possible quantity. It compares two offers the shop can actually choose. Intermediate quantities, different freight bands or negotiated delivery releases could produce a better result than either.
The same offer wins when carrying costs are lower
Keep demand, prices and order costs unchanged, but reduce the annual holding allowance to 20 percent. The small-order total becomes EUR24,680. The bulk-order total becomes EUR24,020. Bulk now saves EUR660 a year.
The break-even holding rate in this example is about 34 percent. Divide the EUR1,600 combined purchase-and-ordering saving by the EUR4,700 extra average inventory value: approximately 34.04 percent per year. Below that rate, bulk wins within the model. Above it, smaller orders win. That is a sensitivity boundary, not a recommended holding rate for another shop.
A compact way to reproduce the comparison is: annual units multiplied by unit price, plus number of orders multiplied by cost per order, plus average inventory value multiplied by the annual holding rate. Use consistent annual units throughout. Do not add an entire year’s holding cost to every delivery and then multiply it again by the number of orders.
A cheaper year can still mean a difficult month
The cash requirement has not disappeared in the winning scenario. Before delivery costs, the shop pays EUR11,400 for a bulk order instead of EUR2,000 for a small one: EUR9,400 more at the payment date. That is an upfront-payment difference, not an extra annual expense. Over the year, both patterns buy the same number of units.
Average stock value is also different from the peak payment. EUR5,700 is the bulk option’s average cycle inventory value; it is not the payment to the supplier. Keep the annual cost comparison and the cash calendar on separate lines so neither number stands in for the other.
Supplier credit, deposits, staged releases and payment deadlines can change the cash timing materially. Ask whether the supplier can commit the price for 600 units while releasing smaller deliveries, and what that arrangement would cost. A price reservation and a physical delivery of six months of stock are different offers. Do not treat a proposed concession as agreed until the supplier confirms it.
Check the speed of the specific stock
A steady average can hide the wrong product mix. A popular size can sell out while another colour occupies the shelves. Build the comparison at variant level where buying quantities or demand differ. Consider on-hand stock and already committed incoming stock before adding another delivery.
Shopify defines days of inventory remaining as ending inventory divided by average daily units sold in its product analytics documentation. That is a useful starting view of sales speed. It is not a guarantee that the recent pace will continue, particularly after a promotion, during a seasonal peak or when a product has spent time unavailable.
Use at least a base and a slower-sales case. If the product is seasonal, perishable or being replaced, check how many units might remain at the end of its useful selling period. Estimate their likely recovery value and handling cost separately. If you explicitly model that loss, remove the overlapping loss allowance from the holding rate rather than counting both.
Make the buying decision on one page
Write down the required quantity for the same demand period, the all-in supplier offers, delivery dates and payment dates. Then record average stock, incremental holding costs and the uncertain assumptions. Add a downside case and the cash left for other essential commitments after the order is paid.
The supplier discount is most defensible when demand is reasonably dependable, the extra stock is inexpensive to hold, and the payment fits the cash plan. Smaller orders can be worth their higher unit price when they preserve flexibility around a fragile forecast. Neither choice repairs inaccurate inventory records or an unreliable supplier.
For the next meaningful offer, calculate the total-cost difference and the upfront cash difference before accepting. If those two answers point in different directions, the decision needs more than a lower price tag.
Sources and method
Primary references checked 16 November 2026: ACCA, Inventory control (undated technical teaching guidance), and Shopify Help, Product analytics overview (current documentation). This is independent editorial analysis, not a report of new platform features. All euro amounts and scenarios are hypothetical calculations by Webshop Toolkit; no customer results or stock test are claimed. The model excludes VAT, changes in revenue, fixed overheads, stockouts and safety-stock differences. It treats the holding allowance as a decision estimate, not an accounting inventory valuation or tax calculation.