[ic] percentage in pricing table and dealer price

Mike Heins interchange-users@icdevgroup.org
Tue Jun 25 23:33:01 2002


Quoting Mike Heins (mike@valuemedia.com):
> Quoting Ludek Mokry (ludek@mokry.cz):
> > Hello,
> > 
> > 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%
> > 
> > Please advise.
> 
> Looks like that might be a bug. Someone may be able to take a look at it,
> but I won't be able to for quite a while. I have put it in my todo
> list, but I suspect someone else might find it before I have a chance.
> 

Finally got around to looking at this. It is not a bug.

With the standard "tools" CommonAdjust:

CommonAdjust => <<EOF,

	pricing:w5,w10:,
	;:wholesale,
	;:wholesale:mv_sku,
	;$,
	==:options
EOF

there is no initial price to take a percentage from!

You need to make it instead:

CommonAdjust => <<EOF,
    :wholesale,
    pricing:w2,w5,w10:,
    ;:wholesale:mv_sku,
    ;$,
    ==:options
EOF

At that point the percentage stuff will work as advertised based
on quantity.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting
phone +1.513.523.7621      <mike@perusion.com>

I don't want to get to the end of my life and find I have just
lived the length of it. I want to have lived the width of it as
well. -- Diane Ackerman