Hello all,

Well I have been banging my head on this probelm for a few days now. I found
 what I thought were the steps i needed at

http://publib.boulder.ibm.com/infoc...unt_example.htm

but after following it, it doesnt appear to be applying the discount. What I
 am basically trying to to is, in accelerator I went tp Merchandise->catalog
 management and added a new category under an existing category. I then foll
owed the steps above expect
ing it to make any product in the new category have a discount applied to it
 when it is added to the shopping cart. But it seems to do absolutly nothing
. I have triple checked the steps and what to change for each of the tables 
and it all looks like it sh
ould be correct.

Anyone have any experience setting something like this up where all items in
 a certain catalog group will have a discount applied to the automatically, 
say you wanted to apply a 30% off discount to all products in the pants cate
gory group.

Any Help would be great.
Thanks

[ Post a follow-up to this message ]

Err meant to add this in my original post, its on Websphere Commerce Express
 5.6

Thanks

[ Post a follow-up to this message ]

Have you stopped and started the instance (or flushed the WC Registry in
Admin Console) since making this change?  The calculation codes are
stored in the registry.

A number of other things could be wrong...the documentation (hey - its
better than the old days), a typo, etc.

R

> Hello all,
>
>  Well I have been banging my head on this probelm for a few days now. I fo
und what I thought were the steps i needed at
>
> http://publib.boulder.ibm.com/infoc...unt_example.htm
>
> but after following it, it doesnt appear to be applying the discount. What I am ba
sically trying to to is, in accelerator I went tp Merchandise->catalog management an
d added a new category under an existing category. I then followed the steps above e
xpe
cting it to make any product in the new category have a discount applied to 
it when it is added to the shopping cart. But it seems to do absolutly nothi
ng. I have triple checked the steps and what to change for each of the table
s and it all looks like it
should be correct.
>
> Anyone have any experience setting something like this up where all items 
in a certain catalog group will have a discount applied to the automatically
, say you wanted to apply a 30% off discount to all products in the pants ca
tegory group.
>
> Any Help would be great.
> Thanks

[ Post a follow-up to this message ]

Hi Robert,

Yeah I flushed the registry after the changes and then stopped and restarted
 the instance but still no go. I have been trying to dig around and see if I
 can find any more details instructions on setting up something like this, b
ut as near as i can tell I
have all the entries in CALCODE, CALRULE, CALSCALE, CALRANGE, CRULESCALE, CA
LRLOOKUP and CATGPCALCD setup and referencing each other correctly so it is 
driving me crazy.

[ Post a follow-up to this message ]

Yeah, there are quite a few CAL* tables to go through.  Not sure how
much I could help without access to your db to run some SQL queries.
I've pasted two statements from a recent project.  None include
CATGPCALCD so perhaps you can incorporate that table into the first by
changing the calusage_id to fit your efforts.

select cru.calrule_id, cru.flags, cs.calscale_id, cs.code,
cs.calmethod_id, cra.calrange_id, cra.calmethod_id, cra.rangestart,
crl.value, crl.setccurr
from calrule as cru, calscale as cs, crulescale as crs, calrange as cra,
calrlookup as crl
where cru.calrule_id = crs.calrule_id and cs.calscale_id =
crs.calscale_id and cs.calscale_id = cra.calscale_id and cra.calrange_id
= crl.calrange_id and cs.calusage_id = -2
order by cru.calrule_id, cs.calscale_id, rangestart, value


select jg.jurstgroup_id, jg.description, jg.code, sm.shipmode_id,
sm.code, sm.carrier, cru.calrule_id, cs.calscale_id, cs.code,
cs.calmethod_id, cra.calrange_id, cra.calmethod_id, cra.rangestart,
crl.value, crl.setccurr
from jurstgroup as jg, shpjcrule as sjcr, shipmode as sm, calrule as
cru, calscale as cs, crulescale as crs, calrange as cra, calrlookup as crl
where jg.jurstgroup_id = sjcr.jurstgroup_id and sm.shipmode_id =
sjcr.shipmode_id and cru.calrule_id = sjcr.calrule_id and cru.calrule_id
= crs.calrule_id and cs.calscale_id = crs.calscale_id and cs.calscale_id
= cra.calscale_id and cra.calrange_id = crl.calrange_id
order by jurstgroup_id, shipmode_id, cs.calscale_id, rangestart, value

R


> Hi Robert,
>
> Yeah I flushed the registry after the changes and then stopped and restarted the i
nstance but still no go. I have been trying to dig around and see if I can find any 
more details instructions on setting up something like this, but as near as i can te
ll
I have all the entries in CALCODE, CALRULE, CALSCALE, CALRANGE, CRULESCALE, 
CALRLOOKUP and CATGPCALCD setup and referencing each other correctly so it i
s driving me crazy.

[ Post a follow-up to this message ]