How to use OFBiz to provide room reservation

[X Gylee]

I'm currently exploring the possibility of using OFBiz for a hotel room
reservation system. The system will have several types of rooms, each with
its own number of available rooms for a date period.

For example:

Room 1 => Jan 1 - Jan 10 => 3 rooms.
Room 1 => Jan 11 - Jan 17 => 2 rooms.
Room 1 => Jan 18- Jan 31 => 3 rooms.

Room 2 => Jan 1 - Jan 20 => 1 room.
Room 2 => Jan 21 - Jan 31 => 2 rooms.

If a customer books a room in a certain date range the available quantities
in the corresponding periods will be subtracted.

For example:

A customer books one "Room 1" from Jan 10 to Jan 12. Then the availabilities
of Room 1 would be updated to:

Room 1 => Jan 1 - Jan 9 => 3 rooms.
Room 1 => Jan 10 - Jan 10 => 2 rooms.
Room 1 => Jan 11- Jan 12 => 1 room.
Room 1 => Jan 12 - Jan 17 => 2 rooms.
Room 1 => Jan 18- Jan 31 => 3 rooms.

I try to use OFBiz for such scenarios, but I do not know how to define the
products, pricings, and inventories for it. The provided OFBiz sample data
does not seem to be tailored for a purchase that spans accross a date range.

I could manipulate OFBiz by creating a single product for each date, such as
"Room 1 Jan 1", "Room 1 Jan 2", "Room 1 Jan 3", etc., and allocate pricings
and an inventory for each. But, this would be a very tedious process.

I see the existence a product type "Fixed Asset Usage", but I do not know
how to take advantage of it to fit the scenarios above.

Could anybody provide a suggestion on how one could best use OFBiz to handle
such scenario?

[Amine AZZI]

did you look into http://opentravelsystem.org ?

Regards
Amine.

2009/1/9 X Gylee <[hidden email]>

> I'm currently exploring the possibility of using OFBiz for a hotel room
> reservation system. The system will have several types of rooms, each with
> its own number of available rooms for a date period.
>
> For example:
>
> Room 1 => Jan 1 - Jan 10 => 3 rooms.
> Room 1 => Jan 11 - Jan 17 => 2 rooms.
> Room 1 => Jan 18- Jan 31 => 3 rooms.
>
> Room 2 => Jan 1 - Jan 20 => 1 room.
> Room 2 => Jan 21 - Jan 31 => 2 rooms.
>
> If a customer books a room in a certain date range the available quantities
> in the corresponding periods will be subtracted.
>
> For example:
>
> A customer books one "Room 1" from Jan 10 to Jan 12. Then the
> availabilities
> of Room 1 would be updated to:
>
> Room 1 => Jan 1 - Jan 9 => 3 rooms.
> Room 1 => Jan 10 - Jan 10 => 2 rooms.
> Room 1 => Jan 11- Jan 12 => 1 room.
> Room 1 => Jan 12 - Jan 17 => 2 rooms.
> Room 1 => Jan 18- Jan 31 => 3 rooms.
>
> I try to use OFBiz for such scenarios, but I do not know how to define the
> products, pricings, and inventories for it. The provided OFBiz sample data
> does not seem to be tailored for a purchase that spans accross a date
> range.
>
> I could manipulate OFBiz by creating a single product for each date, such
> as
> "Room 1 Jan 1", "Room 1 Jan 2", "Room 1 Jan 3", etc., and allocate pricings
> and an inventory for each. But, this would be a very tedious process.
>
> I see the existence a product type "Fixed Asset Usage", but I do not know
> how to take advantage of it to fit the scenarios above.
>
> Could anybody provide a suggestion on how one could best use OFBiz to
> handle
> such scenario?
>

[X Gylee]

Yes I did. I downloaded the sharedofbiz from the site and gave it a try. But
I did not find any inventories assigned for the sample hotel rooms. But,
since you mentioned it, I took another look and now I began to see the use
of "Fixed Asset Usage" as the product type. It could be used to check the
availabilities of a room. However, when I tried to assign multple prices
based on dates, the provided front-end did not calculate the total pricing
correctly. It always use the pricing of the current date multiplied with the
number of days.

Example:

Let's say a hotel room is priced as below,

Jan 1 - Jan 10 => USD 30
Jan 11 - Jan 20 => USD 40

If a customer books the room from Jan 10 - Jan 11, the total price should be
30 + 40 = 70. However, the opentravelsystem would give 30 * 2 = 60, which is
not correct.

Nonetheless, I think I would try to learn more about the Fixed Asset Usage
and how to assign pricings and promos to it.

I also see the availability of "Rental" menu. What does this menu do? Can I
use this menu to book a "Fixed Asset Usage" product?




On Sat, Jan 10, 2009 at 9:26 PM, X Gylee <[hidden email]> wrote:

> did you look into http://opentravelsystem.org ?
>
> Regards
> Amine.
>
> 2009/1/9 X Gylee <[hidden email]>
>
> > I'm currently exploring the possibility of using OFBiz for a hotel room
>
> > reservation system. The system will have several types of rooms, each with
> > its own number of available rooms for a date period.
> >
> > For example:
> >
> > Room 1 => Jan 1 - Jan 10 => 3 rooms.
>
> > Room 1 => Jan 11 - Jan 17 => 2 rooms.
> > Room 1 => Jan 18- Jan 31 => 3 rooms.
> >
> > Room 2 => Jan 1 - Jan 20 => 1 room.
> > Room 2 => Jan 21 - Jan 31 => 2 rooms.
> >
>
> > If a customer books a room in a certain date range the available quantities
> > in the corresponding periods will be subtracted.
> >
> > For example:
> >
> > A customer books one "Room 1" from Jan 10 to Jan 12. Then the
>
> > availabilities
> > of Room 1 would be updated to:
> >
> > Room 1 => Jan 1 - Jan 9 => 3 rooms.
> > Room 1 => Jan 10 - Jan 10 => 2 rooms.
> > Room 1 => Jan 11- Jan 12 => 1 room.
>
> > Room 1 => Jan 12 - Jan 17 => 2 rooms.
> > Room 1 => Jan 18- Jan 31 => 3 rooms.
> >
> > I try to use OFBiz for such scenarios, but I do not know how to define the
> > products, pricings, and inventories for it. The provided OFBiz sample data
>
> > does not seem to be tailored for a purchase that spans accross a date
> > range.
> >
> > I could manipulate OFBiz by creating a single product for each date, such
> > as
> > "Room 1 Jan 1", "Room 1 Jan 2", "Room 1 Jan 3", etc., and allocate pricings
>
> > and an inventory for each. But, this would be a very tedious process.
> >
> > I see the existence a product type "Fixed Asset Usage", but I do not know
> > how to take advantage of it to fit the scenarios above.
>
> >
> > Could anybody provide a suggestion on how one could best use OFBiz to
> > handle
> > such scenario?
> >
>
>

[Amine AZZI]

Ah from this point I can't really help, I tried once to use the fixed assets
products, i noticed that it's not really completed (I could not modify an
order for instance). From this point I think you should try to customize it
for your needs.
Some experienced users should help to estimate the effort, I didn't use
Ofbiz for a while I don' know if someone has added some features in that way
meanwhile.

Regards.
Amine Azzi..


2009/1/10 X Gylee <[hidden email]>

> Yes I did. I downloaded the sharedofbiz from the site and gave it a try.
> But
> I did not find any inventories assigned for the sample hotel rooms. But,
> since you mentioned it, I took another look and now I began to see the use
> of "Fixed Asset Usage" as the product type. It could be used to check the
> availabilities of a room. However, when I tried to assign multple prices
> based on dates, the provided front-end did not calculate the total pricing
> correctly. It always use the pricing of the current date multiplied with
> the
> number of days.
>
> Example:
>
> Let's say a hotel room is priced as below,
>
> Jan 1 - Jan 10 => USD 30
> Jan 11 - Jan 20 => USD 40
>
> If a customer books the room from Jan 10 - Jan 11, the total price should
> be
> 30 + 40 = 70. However, the opentravelsystem would give 30 * 2 = 60, which
> is
> not correct.
>
> Nonetheless, I think I would try to learn more about the Fixed Asset Usage
> and how to assign pricings and promos to it.
>
> I also see the availability of "Rental" menu. What does this menu do? Can I
> use this menu to book a "Fixed Asset Usage" product?
>
>
>
>
> On Sat, Jan 10, 2009 at 9:26 PM, X Gylee <[hidden email]> wrote:
>
> > did you look into http://opentravelsystem.org ?
> >
> > Regards
> > Amine.
> >
> > 2009/1/9 X Gylee <[hidden email]>
> >
> > > I'm currently exploring the possibility of using OFBiz for a hotel room
> >
> > > reservation system. The system will have several types of rooms, each
> with
> > > its own number of available rooms for a date period.
> > >
> > > For example:
> > >
> > > Room 1 => Jan 1 - Jan 10 => 3 rooms.
> >
> > > Room 1 => Jan 11 - Jan 17 => 2 rooms.
> > > Room 1 => Jan 18- Jan 31 => 3 rooms.
> > >
> > > Room 2 => Jan 1 - Jan 20 => 1 room.
> > > Room 2 => Jan 21 - Jan 31 => 2 rooms.
> > >
> >
> > > If a customer books a room in a certain date range the available
> quantities
> > > in the corresponding periods will be subtracted.
> > >
> > > For example:
> > >
> > > A customer books one "Room 1" from Jan 10 to Jan 12. Then the
> >
> > > availabilities
> > > of Room 1 would be updated to:
> > >
> > > Room 1 => Jan 1 - Jan 9 => 3 rooms.
> > > Room 1 => Jan 10 - Jan 10 => 2 rooms.
> > > Room 1 => Jan 11- Jan 12 => 1 room.
> >
> > > Room 1 => Jan 12 - Jan 17 => 2 rooms.
> > > Room 1 => Jan 18- Jan 31 => 3 rooms.
> > >
> > > I try to use OFBiz for such scenarios, but I do not know how to define
> the
> > > products, pricings, and inventories for it. The provided OFBiz sample
> data
> >
> > > does not seem to be tailored for a purchase that spans accross a date
> > > range.
> > >
> > > I could manipulate OFBiz by creating a single product for each date,
> such
> > > as
> > > "Room 1 Jan 1", "Room 1 Jan 2", "Room 1 Jan 3", etc., and allocate
> pricings
> >
> > > and an inventory for each. But, this would be a very tedious process.
> > >
> > > I see the existence a product type "Fixed Asset Usage", but I do not
> know
> > > how to take advantage of it to fit the scenarios above.
> >
> > >
> > > Could anybody provide a suggestion on how one could best use OFBiz to
> > > handle
> > > such scenario?
> > >
> >
> >
>