[ic] Display Quantity Discount in Flypage

[interchange-users@interchange.redhat.com (Steve Graham)]

Hi Mike,

I am doing this just on the flypage for any specific item a customer clicks 
on, so it should not be a database search.

Therefore, we already know the sku. I'm pretty sure I could write some loop 
in SQL to parse the pricing database on the specific sku, but I thought 
someone might already have done this before.

Wouldn't it make sense to display the items quantity prices in the flypage?

-Steve


>From: Mike Heins <mheins@redhat.com>
>Reply-To: interchange-users@interchange.redhat.com
>To: interchange-users@interchange.redhat.com
>Subject: Re: [ic] Display Quantity Discount in Flypage
>Date: Tue, 26 Feb 2002 23:03:21 -0500
>
>Quoting Steve Graham (dtlgc@hotmail.com):
> > Hello,
> >
> > I would like to display all the different quantity breaks each item has, 
>and
> > if it doesn't have any don't display, in each items flypage. I have IC 
>4.8.3
> > calculating the prices correctly with commonadjust, now I want to show 
>the
> > potential buyers the qty breaks.
> >
> > I see that [item-price q1], [item-price q5] etc... will show the breaks, 
>but
> > I have discounts of 1,2,3,5,6,10,12,15,20,25....various up to to 250 opr
> > more.
> > If an item has only breaks at say 1,6,12 then I don't want to display 
>all
> > the redundant breaks in-between.
>
>Well, if you are expecting Interchange to intuit them for you it can't.
>You can tell it what they are, though, and loop through them:
>
>[loop prefix=item list="os28004"]
>     [loop prefix=break list="1,6,12"]
>	SKU [item-code] quantity [break-code]:
>		[price code="[item-code]" quantity="[break-code]"]
>     [/loop]
>[/loop]
>
>This is not the type of thing you want to do on long lists -- it is too
>database-intensive.
>
>--
>Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
>phone +1.513.523.7621      <mheins@redhat.com>
>
>Clothes make the man.  Naked people have little or no influence on
>society.  -- Mark Twain
>_______________________________________________
>interchange-users mailing list
>interchange-users@interchange.redhat.com
>http://interchange.redhat.com/mailman/listinfo/interchange-users




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com