[ic] percentage in pricing table and dealer price

Kevin Walsh interchange-users@interchange.redhat.com
Thu May 9 02:10:00 2002


> 
> According documentation I can use N.NN% (or -N.NN%) in pricing table to
> modify price according quantity (or in product table dealer price field to
> get dealer price). But I can't make it work. 
> 
> If I enter discounted price instead of percentage to pricing table
> everything is working properly.
> 
> Pricing table which doesn't work:
> sku	price_group	q2	q5	q10	q25	q100	w2	w5
> w10	w25	w100
> 00003	STANDARD	-10%	-20%	-30%	-40%	-50%	-10%	-20%
> -30%	-30%	-50%
> 
Are you using a MySQL or PostgreSQL table?  If so, are your columns
set to some form of CHAR type, or some form of DECIMAL?

When you set a column to "-20%", what do you get as a price adjustment?
Do you get "-20", for instance?

Last question:  Which version of Interchange are you using?

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/