[ic] CommonAdjust and profiles
tom at acronpaints.co.uk
Tue Mar 2 03:49:01 EST 2004
I know this has been brought up many times, I have been looking through
previous posts and am unable to find an answer.
I have set in my catalog.cfg the following:
CommonAdjust pricing:q2,q5,q10,q25,q100: ;products:price
Profile dealer CommonAdjust "pricing:w2,w5,w10,w25,w100:
Profile dealer PriceField "common_adjust"
Profile default CommonAdjust "pricing:q2,q5,q10,q25,q100:
Profile default PriceField "common_adjust"
Profile harvey CommonAdjust "harvey:q2,q5,q10,q25,q100: ;harvey:q1"
Profile harvey PriceField "common_adjust"
In an attempt to have different pricings for different groups of people.
This seems to work for users with price_level set to dealer (in the userdb
table) and for users who don't have a price_level set. This however doesn't
work for any users with price_level set to harvey.
In the harvey table There are columns for sku (Primary Key), price_group,
q2,q5,q10,q25,q100,q1 (in that order).
Do I need to reference the table somewhere else for it to be useable?
This is with a store based on the foundation store with Interchange v5.0.0,
Postgresql v2.4.0, Perl5.8.3, DBI.pm v 1.40 and DBD::Pg v 1.31.
Also, does anyone know a way of adding a writeable field as an options to a
product item (that needs to appear on the invoice/email notification). Since
some products come in many thousand colours it wouldn't be sensible to have
a pull-down list.
TIA for any help you can give me.
More information about the interchange-users