[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