Insights
Purchasing: why the storeroom runs out on Saturday night
Hotels, resorts and parks don't have a purchasing problem — they have a visibility problem. Stock is counted monthly but consumed hourly, so the kitchen discovers the shortage mid-service, the storekeeper discovers the overstock at the stocktake, and nobody discovers the undelivered order at all. Here is why that happens, and why most of it is a database problem, not a discipline problem.
The pain: three ways purchasing goes wrong
Stock you can't see. The storeroom's truth and the report's truth diverge all month. Issues to outlets go on paper, breakages go unrecorded, and the monthly stocktake reconciles reality with the ledger only after four weeks of decisions were made on stale numbers.
Bought too late, or too early. Too late is the Saturday-night stockout — the menu item that dies mid-service on the busiest cover count of the week. Too early is quieter but costs more: cash tied up on shelves, perishables expiring in the chiller, storage stuffed ahead of a month that turned out soft. Both come from the same root — reordering by feel, because the numbers aren't live.
The lost follow-up. An outlet requests stock; the request becomes an email; the email becomes a purchase order — or doesn't. The order arrives partially, and nobody chases the balance because no list anywhere says it's outstanding. When requests, orders and deliveries live in separate places, the chain has no memory.
Why it happens: the consumption data lives in another system
Here is the structural part. The information that predicts a property's consumption is not in the purchasing system — it is in the reservation book and the tills:
- Packages already contain their components. When a guest books room + breakfast + snorkeling for next Friday, that reservation carries its breakdown items — one more breakfast, one more snorkeling slot, on a known date. Multiply across the book and next Friday's consumption is largely written before the week begins.
- Every sale depletes a recipe. A plate of nasi lemak rung up at the POS is coconut milk, rice and anchovies out of the store — if the system knows the recipe and shares the database.
- Events and attendance are known in advance. Banquet orders, group blocks and park attendance patterns all sit in the same operational data.
A generic ERP — however good its purchase orders — never sees any of this. It learns about breakfast demand after the kitchen requisitions stock. A hospitality PMS mostly has no purchasing at all. So properties end up guessing in the middle: consumption known in one system, buying done in another, and a spreadsheet bridging them when someone has time.
How WinX fixes it: purchasing on the operational database
WinX puts the purchasing module on the same database as reservations, POS and the general ledger — so the inputs above are not integrations, they are table joins:
- A live stock position per location — central store and outlet stores separately, updated by goods received, store issues, distributions and sales knock-off as they happen, with stocktake corrections when reality still drifts.
- Consumption ahead of time — package breakdown items on future reservations tell the kitchen and the storekeeper what a date already carries before it arrives.
- A follow-up chain with memory — the outlet's stock request links to the purchase order raised from it, the order to the goods received against it. Outstanding and partially delivered orders are standing lists, not remembered favours.
- Control without friction — purchase authorisation profiles enforce who can request, approve and order, per department and per limit.
- Cost that lands where it belongs — because receipts, issues and sales share the ledger, outlet-level cost of sales is a report, not a month-end archaeology project. The same logic that puts P&L on the day, not at month-end.
Proven where purchasing is hardest
Multi-outlet, multi-store operations are where purchasing breaks first — and where WinX runs largest. Manila Ocean Park + Hotel H2O runs around 40 outlets — in-park mall, hotel, spa, kiosks — on one WinX installation, with central-store-to-outlet distribution on the same records as the tills. Island properties like Atmosphere Resort & Spa in Dumaguete face the opposite pressure: supply runs are infrequent, so buying too little and buying too much both hurt — which is exactly when a computed purchase list beats a guessed one.
Common questions
- Why do hotels run out of stock even with a purchasing system?
- Because most purchasing systems only know what was bought, not what is being consumed. Stock is counted at the stocktake but consumed hourly; between counts the system works from a picture that gets staler by the day, so reorders run on guesswork.
- What does "consumption is predictable" actually mean?
- A property's future consumption is largely already sold. Packages on the reservation book break down into their components — breakfasts, lunches, activities — so the system knows what a future date carries the moment the booking is made. Add live recipe knock-off from the POS, and tomorrow's needs become a computation.
- Why does a generic ERP struggle with hotel purchasing?
- The data that predicts hotel consumption — future reservations, package components, recipes, attendance — lives in the PMS and POS, which a standalone ERP never sees. It learns about breakfast demand after the kitchen requisitions stock; a shared database knows when the room was booked.
- How does WinX keep follow-up from getting lost?
- The chain is one linked record: stock request → purchase order → goods received → stock location. Outstanding requests and partial deliveries are lists the system maintains, with approval limits enforced by purchase authorisation profiles.
See a purchase list computed from your own reservation book and outlets.
Request a WinX demo