Re: [mv] Pricing based on customer status (with a few twists)

[Chris Rapier <rapier@psc.edu>]

******    message to minivend-users from Chris Rapier <rapier@psc.edu>     ******


> My client wants to make his database available to both the public, and
> to dealers.  Dealers would usually pay 1/2 retail *but not always*.
> There is a discount structure on some items that I will use common
> adjust for (if I can under the circumstances).  The discounts would
> apply to both retail and dealer pricing schemes. This combination of
> needs is making my set up process a little more difficult than usual.

If this discount applies to all dealers I would assign all dealers a
special flag when they logged in. I would then manipulate the datebase
so there are two entries per SKU for prices - one for retail and one for
wholesale. The price displayed would be based on the value of the dealer
flag. I like this solution because it also provides the greatest
flexibility in pricing and doesn't require much in the way of overhead
to handle.
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list