| Author |
Message |
Sourav Dutta Gupta
Guest
|
Posted:
Fri Oct 21, 2005 4:51 pm Post subject:
Keeping Product in CS as Master Detail |
|
|
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. |
|
| Back to top |
|
 |
Ravi Shankar
Guest
|
Posted:
Fri Oct 21, 2005 4:51 pm Post subject:
RE: Keeping Product in CS as Master Detail |
|
|
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 |
|
| Back to top |
|
 |
Sourav Dutta Gupta
Guest
|
Posted:
Mon Oct 24, 2005 8:51 am Post subject:
RE: Keeping Product in CS as Master Detail |
|
|
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. |
|
| Back to top |
|
 |
Ravi Shankar
Guest
|
Posted:
Mon Oct 24, 2005 8:51 am Post subject:
RE: Keeping Product in CS as Master Detail |
|
|
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 |
|
| Back to top |
|
 |
|
|
|
|