[ic] Quantity Discount

rbragg redhat at rickbragg.net
Wed Aug 18 22:17:08 EDT 2004


admin at bridaljewels.com wrote:
> Interchange 5.2 MySQL
> 
> I have defined a column in my PRODUCTS database called “bridal”.  When I add an
> item to inventory through the ADMIN, I have added a radio button that selects
> whether this item is to be included in “bridal”.  This works fine.
> 
> I want to give a 20% discount if three or more identical “bridal” items are
> ordered.
> 
> I have figured out how to accomplish this using CommonAdjust and entering -20%
> under q3 for EACH ITEMS.
> 
> I am looking for a way to eliminate having to enter in the -20% under q3 for
> each item.
> 
> Can anyone point me in the right direction to accomplish:
> 
> Check PRODUCTS database for “bridal”, check for quantity of 3 or more, apply 20%
> discount if 3 or more items are ordered?
> 
> Thanks in advance.
> _______________________________________________


Hi,

Use a price "group" call it bridal. You will still need to set that 
discount on each item though. Its just that each of the "items" will be 
in that group.

This is what the "pricing.txt" might look like.

sku     price_group     q3
0001    bridal          -20%
...

-Rick





More information about the interchange-users mailing list