|
Home > Archive > WebSphere Commerce suite > March 2006 > Help on applying a discount to all items in a catalog group.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Help on applying a discount to all items in a catalog group.
|
|
|
| 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 followed 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 category group.
Any Help would be great.
Thanks
| |
|
| Err meant to add this in my original post, its on Websphere Commerce Express 5.6
Thanks
| |
| Robert Brown 2006-03-03, 6:50 pm |
| 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 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 followed the steps above expe
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 nothing. I have triple checked the steps and what to change for each of the tables 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 category group.
>
> Any Help would be great.
> Thanks
| |
|
| 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, but as near as i can tell I
have all the entries in CALCODE, CALRULE, CALSCALE, CALRANGE, CRULESCALE, CALRLOOKUP and CATGPCALCD setup and referencing each other correctly so it is driving me crazy.
| |
| Robert Brown 2006-03-03, 6:50 pm |
| 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 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, but as near as i can tell
I have all the entries in CALCODE, CALRULE, CALSCALE, CALRANGE, CRULESCALE, CALRLOOKUP and CATGPCALCD setup and referencing each other correctly so it is driving me crazy.
|
|
|
|
|