Keeping Product in CS as Master Detail - Commerce server

Saurov,

To my thinking different room categories (executive, delux, salon, etc) make
more sense as different products since they'd have different prices. Also
from a Hotel standpoint, they have a fixed inventory (x executive rooms, Y
salons and such). This all can be kept in a single table.. different
attributes which could be displayed and such...
--
Ravi Shankar


"Sourav Dutta Gupta" wrote:

> Can we keep a product in CS as Master Detail, still manage to fill the Basket
> and generate Order correctly?
>
> Situation is such that we need to add different information for a particular
> product. Say for example Hotel. In this case a particular product say a room
> of a hotel can be purchased by different visitors, where duration and price
> will vary but the room will remain the same. So Order for a particular
> product vary as well as it's detail while the product remain same. We don't
> want to populate redandent data in the database in this case.
>
> How to deal with this situation? Need solution urgently.
>
>

Hi Ravi,

Thanx for ur response.
But this is not the problem I am facing. My issue is something different. I
wanted to keep data such as Check In and Check Out time of a visitor in the
hotel. For a particular room their may be series of such entries with time.
That is, room may be fixed but Check In and Check Out time may vary. Here
room of a hotel may be my product which might have an attribute called
RoomNumber. Check In and Check Out time also the attributes, but can not be
kept as same line items.

Also we will going to add the product dynamically (on the fly) through code.
We had an idea of dealing with this problem as keep the timing as variant. Do
you have any better idea?

If we are heading at the right direction, how to add multiple variants
through code.

"Ravi Shankar" wrote:

> Saurov,
>
> To my thinking different room categories (executive, delux, salon, etc) make
> more sense as different products since they'd have different prices. Also
> from a Hotel standpoint, they have a fixed inventory (x executive rooms, Y
> salons and such). This all can be kept in a single table.. different
> attributes which could be displayed and such...
> --
> Ravi Shankar
>
>
> "Sourav Dutta Gupta" wrote:
>
> > Can we keep a product in CS as Master Detail, still manage to fill the Basket
> > and generate Order correctly?
> >
> > Situation is such that we need to add different information for a particular
> > product. Say for example Hotel. In this case a particular product say a room
> > of a hotel can be purchased by different visitors, where duration and price
> > will vary but the room will remain the same. So Order for a particular
> > product vary as well as it's detail while the product remain same. We don't
> > want to populate redandent data in the database in this case.
> >
> > How to deal with this situation? Need solution urgently.
> >
> >

That is what basket/template and such objects are for (storage of dynamic
data). So if I were to design the app then I'd use a catalog to store fixed
information such as room type, rate, facilities. Another catalog for perhaps
the room service menu, another for perhaps the gym & health room related
stuff. When a customer check in, I'd create a profile and start a basket, in
the basket as the case progresses, I'd store the room charge, other charges
and such.. In the basket at the ordergroup level I'd store things like
checkin time, checkout time etc.. When the customer checks out, I'd run
something similar to a checkout pipeline and total the stuff up with taxes
and such and that would be the final bill... you can even integrate the
checkout process with the credit card/payment gateways... Print it out
whichever way you like
--
Ravi Shankar


"Sourav Dutta Gupta" wrote:

> Hi Ravi,
>
> Thanx for ur response.
> But this is not the problem I am facing. My issue is something different. I
> wanted to keep data such as Check In and Check Out time of a visitor in the
> hotel. For a particular room their may be series of such entries with time.
> That is, room may be fixed but Check In and Check Out time may vary. Here
> room of a hotel may be my product which might have an attribute called
> RoomNumber. Check In and Check Out time also the attributes, but can not be
> kept as same line items.
>
> Also we will going to add the product dynamically (on the fly) through code.
> We had an idea of dealing with this problem as keep the timing as variant. Do
> you have any better idea?
>
> If we are heading at the right direction, how to add multiple variants
> through code.
>
> "Ravi Shankar" wrote:
>
> > Saurov,
> >
> > To my thinking different room categories (executive, delux, salon, etc) make
> > more sense as different products since they'd have different prices. Also
> > from a Hotel standpoint, they have a fixed inventory (x executive rooms, Y
> > salons and such). This all can be kept in a single table.. different
> > attributes which could be displayed and such...
> > --
> > Ravi Shankar
> >
> >
> > "Sourav Dutta Gupta" wrote:
> >
> > > Can we keep a product in CS as Master Detail, still manage to fill the Basket
> > > and generate Order correctly?
> > >
> > > Situation is such that we need to add different information for a particular
> > > product. Say for example Hotel. In this case a particular product say a room
> > > of a hotel can be purchased by different visitors, where duration and price
> > > will vary but the room will remain the same. So Order for a particular
> > > product vary as well as it's detail while the product remain same. We don't
> > > want to populate redandent data in the database in this case.
> > >
> > > How to deal with this situation? Need solution urgently.
> > >
> > >