[ic] Different Prices Per User
jonc at webmaint.com
Thu Aug 21 12:46:06 EDT 2003
> I am trying to change the price list per User definition.
> I have 2 different prices that need to be used, PLOF & CONTRACT, this is
> dependant on what the User has been given.
> I figured the easiest way would be to create 2 identical db
> tables, PLOF.txt
> & CONTRACT.txt, keeping the "price" column in both but containing
> values. Then in the USERDB set-up a column called "price_def"
> that dictates
> whether the user logging in needs the PLOF.txt or CONTRACT.txt database.
> When the user logs in, pass this "price_def" field into a session variable
> and reference the corresponding table in every instance of a
> Search, a Cart
> and the Checkout.
> But, what I need to know is, is this feasible or is it a tad long-winded??
> It'll mean throwing this variable around at virtually every page, to make
> the pricing user specific.
> Has anyone come across this before? And would I need to set a "scratch"
> Variable for this????
> I am slightly confused.
Please state what version you are running, including minor revision, eg.
Interchange has built-in features to handle pricing, depending on various
conditions. Personally, I would use two fields in the products table for
Your first step should be to do a search of the archives for CommonAdjust
which is the directive for defining your pricing.
ps. I take it you managed to fix your last problem. It would have been nice
to report back your findings..
More information about the interchange-users