WebSphere Commerce suite

Author

TERMCOND

Sabo

2004-01-19, 2:47 pm

As far as I found (I couldn't find any documentation about this} the
integerfield1 on the termcond table establishes the relationship against the
productset table and bigintfield in TERMCOND relates against the TRADEPOSCN
?

Behind this question is the following issue, we would like to define Custom
ProductSets, and we want them to be very heterogeneous in terms they are not
base on a single CATGROUP, instead it could contain product and items from
diferent CATGROUPs and PRODUCTs.

There are two final objectives for this ProductSets,
a) Define a price list, that it might be used accross multiple Customers
(having the ProductSet to be part of the contract), kind of "reusing" the
same ProductSet.
b) Define a finite set of items that a Customer can buy, again think in
reuse

Reuse is important since we want to simplify the administration and we want
to avoid the "re-selection" of all the items per contract, this is very
important since we might handling literally "hundreds" of contracts.

We are using 5.4.0.2 BE *Currently still queing 5.4.03 due the high
customization performed on the store :-\

Now, other couple of things (the last ones... I promise) being all this
possible (which I think it is) we should go ahead and use the underlaying
API, instead of trying a SQL approach? I state this because of the XML use
to define the productSets, since I think it's used only for displaying
purposes isn't? I mean SQL could feasible, right?

TIA.
Sabo

Bibhas Bhattacharya

2004-01-19, 2:47 pm

You can define a price list and product set and re-use them in many
contracts. They are called standard price lists and product sets. The custom
ones are specific to a contract and can not be re-used.

A brief step by step process:

1. Define a standard price list by creating a TRADEPOSCN and POLICY entry.
This can be done in the SAR file if needed.

<tradeposcn
tradeposcn_id="@MY_PRICE_LIST"
member_id="&MEMBER_ID;"
markfordelete="0"
name="MY_PRICE_LIST"
precedence="0"
type="S" <-- Note: "S" stands for Standard
/>
<policy
policy_id="@MY_PRICE_LIST_POLICY"
policyname="MY_PRICE_LIST_POLICY"
policytype_id="Price"
storeent_id="@storeent_id_1"
properties="name=MY_PRICE_LIST&member_id=&MEMBER_ID;" <-- This is how
the policy refers to the price list.
/>

2. Create OFFER/OFFERPRICE table entries using this TRADEPOSCN for each item
that belongs to the price list.

3. Define a T&C in a contract that uses the price list:

<TermCondition>
<PriceTC>
<PriceTCPriceListWithOptionalAdjustment>
<PriceListPolicyReference>
<PolicyReference policyName="MY_PRICE_LIST_POLICY"
storeIdentity="mystore" policyType="Price">
<Member>
<Organization distinguishName="o=Gilmore,o=Root Organization"/>
</Member>
</PolicyReference>
</PriceListPolicyReference>
<PriceAdjustment signedPercentage="0.00"/>
</PriceTCPriceListWithOptionalAdjustment>
</PriceTC>
</TermCondition>

Hope that helps.

--
Thank you,

Bibhas Bhattacharya
--
Web Age Solutions Inc.
WebSphere and WebLogic Training and Consulting Services
www.webagesolutions.com

"Sabo" <jesus.chavez@neoris.com> wrote in message
news:b8jr68$3vjk$1@news.boulder.ibm.com...

quote:

> As far as I found (I couldn't find any documentation about this} the
> integerfield1 on the termcond table establishes the relationship against

the

quote:

> productset table and bigintfield in TERMCOND relates against the

TRADEPOSCN

quote:

> ?
>
> Behind this question is the following issue, we would like to define

Custom

quote:

> ProductSets, and we want them to be very heterogeneous in terms they are

not

quote:

> base on a single CATGROUP, instead it could contain product and items from
> diferent CATGROUPs and PRODUCTs.
>
> There are two final objectives for this ProductSets,
> a) Define a price list, that it might be used accross multiple Customers
> (having the ProductSet to be part of the contract), kind of "reusing" the
> same ProductSet.
> b) Define a finite set of items that a Customer can buy, again think in
> reuse
>
> Reuse is important since we want to simplify the administration and we

want

quote:

> to avoid the "re-selection" of all the items per contract, this is very
> important since we might handling literally "hundreds" of contracts.
>
> We are using 5.4.0.2 BE *Currently still queing 5.4.03 due the high
> customization performed on the store :-\
>
> Now, other couple of things (the last ones... I promise) being all this
> possible (which I think it is) we should go ahead and use the underlaying
> API, instead of trying a SQL approach? I state this because of the XML use
> to define the productSets, since I think it's used only for displaying
> purposes isn't? I mean SQL could feasible, right?
>
> TIA.
> Sabo
>
>
>

Sabo

2004-01-19, 2:47 pm

Bibhas,
Nice !!!
Great, that's sounds like a great option, I just couldn't find the right
configuration, now we face other issues, we can't manage to use the loader
package or update the SAR file since we have a mess in general (VERY long
history), the management and deploy of contracts is very dynamic, it changes
almost on a daily basis, and think we are going to build a custom console
(we already built one to manage the catalog since accelerator is to "clumsy"
to do only catalog stuff) to manage and set the contracts or at least to
manage the price lists.

So my question is regarding TERMCOND since (and hopefully) we can almost
completely rule out the loader package (if there is not other option but
going this way... I will cry); we will have to go the API way, for the
POLICY seems to be no problem, for TRADEPOSCN and TERMCOND though, we have
this XML thing, also for TRADEPOSC there is no direct cmd.
In both cases there is some XML that needs to be feed in the CMD for the
TERMCOND and into the AccessBean for TRADEPOSCN does any one have a clue in
how this XML's should look like?

I will go ahead and do some experiments doing some straight SQL and I'll let
you know.

I appreciate your help !!!
Regards

Sabo
PD.
I'm still asuming that in TERMCOND INTEGERFIELD1 is the FK to PRODUCTSET
and BIGINTFIELD1 is the FK to TRADEPOSCN, could someone at IBM confirm this?
:D
TIA

"Bibhas Bhattacharya" <bibhas@webagesolutions-NO-SPAM.com> wrote in message
news:b8mj3k$1evu$1@news.boulder.ibm.com...

quote:

> You can define a price list and product set and re-use them in many
> contracts. They are called standard price lists and product sets. The

custom

quote:

> ones are specific to a contract and can not be re-used.
>
> A brief step by step process:
>
> 1. Define a standard price list by creating a TRADEPOSCN and POLICY entry.
> This can be done in the SAR file if needed.
>
> <tradeposcn
> tradeposcn_id="@MY_PRICE_LIST"
> member_id="&MEMBER_ID;"
> markfordelete="0"
> name="MY_PRICE_LIST"
> precedence="0"
> type="S" <-- Note: "S" stands for Standard
> />
> <policy
> policy_id="@MY_PRICE_LIST_POLICY"
> policyname="MY_PRICE_LIST_POLICY"
> policytype_id="Price"
> storeent_id="@storeent_id_1"
> properties="name=MY_PRICE_LIST&member_id=&MEMBER_ID;" <-- This is

how

quote:

> the policy refers to the price list.
> />
>
> 2. Create OFFER/OFFERPRICE table entries using this TRADEPOSCN for each

item

quote:

> that belongs to the price list.
>
> 3. Define a T&C in a contract that uses the price list:
>
> <TermCondition>
> <PriceTC>
> <PriceTCPriceListWithOptionalAdjustment>
> <PriceListPolicyReference>
> <PolicyReference policyName="MY_PRICE_LIST_POLICY"
> storeIdentity="mystore" policyType="Price">
> <Member>
> <Organization distinguishName="o=Gilmore,o=Root Organization"/>
> </Member>
> </PolicyReference>
> </PriceListPolicyReference>
> <PriceAdjustment signedPercentage="0.00"/>
> </PriceTCPriceListWithOptionalAdjustment>
> </PriceTC>
> </TermCondition>
>
> Hope that helps.
>
> --
> Thank you,
>
> Bibhas Bhattacharya
> --
> Web Age Solutions Inc.
> WebSphere and WebLogic Training and Consulting Services
> www.webagesolutions.com
>
> "Sabo" <jesus.chavez@neoris.com> wrote in message
> news:b8jr68$3vjk$1@news.boulder.ibm.com...
> the
> TRADEPOSCN
> Custom
> not
from[QUOTE][color=darkred]
the[QUOTE][color=darkred]
> want
underlaying[QUOTE][color=darkred]
use[QUOTE][color=darkred]
>
>

Bibhas Bhattacharya

2004-01-19, 2:47 pm

> PD.

quote:

> I'm still asuming that in TERMCOND INTEGERFIELD1 is the FK to PRODUCTSET
> and BIGINTFIELD1 is the FK to TRADEPOSCN, could someone at IBM confirm

this?

quote:

>

This is clearly documented in the TERMCOND database table documentation.
Just click on the "TERMCOND column mapping" link in the TERMCOND table
documentation page.

--
Thank you,

Bibhas Bhattacharya
--
Web Age Solutions Inc.
WebSphere and WebLogic Training and Consulting Services
www.webagesolutions.com