The product catalog
The product catalog database holds all the information for customer
reservations and room prices and is in two sections. The
YearPlan table holds all the
information for the catalog interface and is displayed on your
website where customers can browse for available rooms and dates.
The Bookings table and
the RoomRates table are displayed
on the web site control panel. All three product catalog tables interact to provide
your customers with the latest information on availability,
as changes to room allocations are made through your web site, and
alterations to room prices are made using the web site control panel.
Together the product catalog and the customer shopping cart share a
total of twelve interrelated tables and support code. Some of this
information is displayed on the web site for customer to browse and
make reservations. The remainder in used for administration purposes
using the web site control panel.
Using this relationship between the tables means that any changes or
alterations made will automatically be displayed to the customer.
Keeping information relevent to any changes avoides conflicts in room
allocations and double bookings. Dates can be locked out instantly the
room allocation for a given date has been achieved.