OĞUZ EROLADS & AI

Separate Reserved Stock from Available Quantity

12 September 2026

Goods on the shelf may already be promised to other customers. I can turn the allocation process in your Excel and Google Sheets files into a custom app that shows physical stock, reservations and available quantities separately, with the order behind each reservation visible.

Update allocations when an order changes

A sales colleague opens a reservation for the product and quantity on an order. Reducing the order releases the difference, while cancellation releases the allocation. At delivery, the reservation closes and the actual stock issue is recorded. We design these steps together so the reservation and issue do not deduct the same quantity twice.

Test two requests for the last item

Order, reservation and available-stock screens make a focused first version to try quickly. We specifically test two salespeople trying to allocate the final item at the same time. The decision must be checked against current quantities when saved, rather than relying only on an earlier screen value. Expiring reservations or authorised exceptions can be added to match your sales process.

Frequently Asked Questions

Can a reservation expire automatically?

If your business uses time-limited allocations, we can define an expiry date and agree how the quantity is released and the order owner informed.

Does insufficient stock prevent an order being accepted?

Order acceptance and stock allocation can be separate decisions. We can allow backorders or reserve only the available quantity, following your rules.

Discuss your workflow

Describe your workflow on the contact page. Explore other examples of custom web apps for your team.

WHAT YOU CAN ASK FOR

How do I work?
Work-hour packages

Tell me about your website and what you need on WhatsApp or by phone; we agree on a work block of somewhere between 5 and 40 hours and I start doing what is needed. What you get is not a calendar window — it is net working hours spent directly on your business. I can use 40 hours working three days straight, or deliberately spread it out and finish it over a year — whatever the work calls for. I do not spend my time estimating how long something will take, I spend it doing the work; every hour I spend has a lasting result on your site. We keep going for as long as you find it useful.

WORK BLOCKS

Why not monthly?
Is 40 hours a week?

On a fixed monthly fee both sides are watching the wrong thing: you watch a fixed cost, the other side watches how many more contracts like this they can line up. Working by the hour puts us both in front of the same thing — the real value of the work that got done. I know not having an upfront answer to "how much will this cost in total?" is the natural cost of this model. But instead of paying a fixed fee for months to a setup that is not producing results, you only pay for the qualified time spent on your work — and you see exactly where that time went, start to finish. That is why my clients keep coming back.

5hours300€ + VAT60€ per hourChoose this block
10hours500€ + VAT50€ per hourChoose this block
20hours800€ + VAT40€ per hourChoose this block
40hours1,400€ + VAT35€ per hourChoose this block