Summary

Enable automatic updates of product prices for existing reservations, with an option to offset package-inclusive stay services to maintain the originally agreed daily package rates.

Background / Problem

Currently, price changes apply only to future reservations. Existing reservations remain locked at the old product prices, which:

Causes revenue leakage when product costs rise.

Requires manual corrections by staff, leading to inefficiency and errors.

Creates package inconsistency: updating the product price increases the overall daily package rate, which conflicts with guest-confirmed agreements.

User Stories

As a Revenue Manager, I want product price updates to be applied to existing reservations, so that I don’t lose revenue when costs increase.

As a Front Desk/Reservations Agent, I want the option to keep the guest’s agreed total package rate unchanged, even when product prices are updated, so that I maintain trust and transparency with guests.

As a Finance/Controlling Manager, I want accurate product/stay service allocations reflected in reports after price changes, so that financial records align with actual costs.

Proposed Solution

Automatic Product Price Update

Extend update logic to affect existing reservations.

Configurable toggle: apply automatically or manually.

Offsetting Mechanism for Package Rates

For package-inclusive products:

Optionally reduce the stay service (room rate) by the same amount as the product price increase.

Keeps the total daily rate constant.

Configuration Options

Scope: all reservations, only future arrivals, or selected products.

Audit log: track changes for compliance and reporting.

Notification/alert for reservations where updates were applied.

Example

Half-board package includes dinner (€30). Dinner price increases to €35.

Existing reservation at €150 total per night (room €120 + dinner €30).

System updates dinner to €35 and reduces room rate to €115, keeping package total = €150.

Finance reports show corrected product/stay allocation, guest sees unchanged package price.