[ic] question about custom pricing

[Ed LaFrance (New Media E.M.S.)]

At 06:28 PM 9/15/2004, you wrote:


>--- "Ed LaFrance (New Media E.M.S.)"
><ic_users at newmediaems.com> wrote:
>
> > At 10:31 AM 9/14/2004, you wrote:
> >
> > >Sorry for the confusion. Here is my original post:
> > >
> > >I am setting up a catalog with 4 different pricing
> > >levels (these values are defined in the
> > product/item
> > >table).
> > >
> > >I can display the price just fine on the results
> > list
> > >and the item page based on the affiliate's pricing
> > >level value, but when any item is added to the
> > cart,
> > >it picks up the default 'item-price' value and not
> > the
> > >affiliate based-price.
> > >
> > >I'm sure this is to protect a malicious user from
> > >being able to order items at a discount.
> > >
> > >My question is:
> > >Is there a single place where I can put in the
> > price
> > >level checking logic and have an item added to the
> > >cart w/ the correct price? If not, where do I need
> > to
> > >make these changes?
> > >
> > >To which you replied:
> > > > > > Mark -
> > > > > >
> > > > > > There are examples of pricing Profiles in
> > > > > > yourcat/etc/after.cfg; start there.
> > > > > >
> > > > > > - Ed
> > >
> > >I took a look at the file. The desired effect is to
> > >detect the affiliate ID, and set the price_level
> > >variable to a value based on the affiliate (1, 2,
> > 3).
> > >I have columns in my product table called
> > >price_level1,
> > >price_level2, price_level3, price_level4 that
> > contain
> > >the corresponding prices.
> > >
> > >What is the best way to include the logic in the
> > >after.cfg file? I tried a couple of variants but
> > >nothing seemed to work correctly. I couldn't find a
> > >detailed reference or example in the archives.
> > >
> > >Thanks in advance,
> > >Mark
> >
> > You can use ITL in the CommonAdjust string, so try
> > something like:
> >
> > PriceField      0
> > CommonAdjust    :[scratch aff_price], ;:price, ;$,
> > ==:options
> >
> > This presumes that you have first set aff_price in a
> > logical place in the
> > catalog, such as the catalog page you have
> > designated for this affiliate in
> > their 'url' field:
> >
> > [set aff_price][data base=affiliate
> > field=price_level key="@@MV_PAGE@"][/set]
> > [comment] the above assumes that the affiliate page
> > name matches the key to
> > their affiliate record
> > [/comment]
> > [if scratch aff_price]
> >          [set aff_price]price_level[scratch
> > aff_price][/set]
> > [else]
> >          [set aff_price]price[/set]
> > [/else]
> > [/if]
> >
> > If this is the only kind of pricing stuff you are
> > doing, you can comment
> > out the include for etc/after.cfg
> >
> > ### include etc/after.cfg
> >
> > ...and just use the PriceField and CommonAdjust
> > directives in catalog.cfg.
> >
> >
>
>Ed:
>
>I have the value for the price_level being set in the
>top section of my main template that is used for every
>page (the variable is called affilPrice). It works
>fine. I can see that the value is being set correct
>for price_level and is viewable my results_buylist
>component, etc.
>
>However, using [item-price] in the results_buylist
>component is bringing up the "base" price, and adding
>an item to the cart results in the same "base" price
>being used. It is not using what I set in the
>CommonAdjust string...
>
>This is in my catalog.cfg file:
>PriceField      0
>CommonAdjust    :[scratch affilPrice], ;:price, ;$,
>==:options
>
>I'm sure I'm missing something minor..any add'l help
>would be greatly appreciated!

Did you comment out or remove 'include etc/after.cfg'? To comment it out, 
you need at least two '#'.  Did you Apply Changes or restart Interchange?

If so, put this on any page and see what the output is:

[calc] return $Config->{CommonAdjust}; [/calc]


- Ed


===============================================================
New Media E.M.S.              Technology Solutions for Business
11630 Fair Oaks Blvd., #250   eCommerce | Consulting | Hosting
Fair Oaks, CA  95628          Ed.LaFrance at newmediaems.com
(916) 961-0446                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (916) 961-0447 Fax
===============================================================