[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] Pricing based on customer status (with a few twists)
****** message to minivend-users from "Eran Binyamin Zeitoun" <eran_zeitoun@karmail.com> ******
Sorry Birgitt...,
I realy tought you are one..., and its not embarassment for mike...
i got the feeling you are...
Sorry again...
Eran
(and again sorry)
----- Original Message -----
From: "Birgitt Funk" <birgitt@my-books.com>
To: <minivend-users@minivend.com>
Sent: Saturday, May 27, 2000 7:00 PM
Subject: Re: [mv] Pricing based on customer status (with a few twists)
> ****** message to minivend-users from Birgitt Funk
<birgitt@my-books.com> ******
>
>
> On Sat, 27 May 2000, Eran Binyamin Zeitoun wrote:
>
> > ****** message to minivend-users from "Eran Binyamin Zeitoun"
<eran_zeitoun@karmail.com> ******
> >
> > Hi!
> > Let me donate from what i did... its not compleatly... and its not
somthing
> > like a real
> > programmer (someone in the level of brigit funk or mike...) would do....
but
>
> OK, could you please stop this. I just explained that I am NOT A
> PROGRAMMER publicly and I don't want to be put in one sentence with
> Mike Heins. That's a public embarassement for Mike Heins and a misreading
> of my post. Sorry.
>
>
> > its working
> > so who cares.... (If some one will have some comments or improvments...
you
> > are welcome!)
> >
> > I hope it will help you somehow James... or anybody else.... since i
couldnt
> > find somthing
> > at the mailing list when i started doing it...
> >
> > My case:
> > We have diffrent kind of dealers... each dealer and his kind of price...
> > Also each products group have diffrent price calculation....,
> > Sometimes there is a need to a special add-on factor...
> > so to get to the final price for a product the calculation
> > goes like this: Price * ImportFactor * UserFactor * ProductFactor *
> > PaymentFactor
> >
> > Price - The Basic Price (found in products.asc)
> > ImportFactor - Since we import the products, each product have a
diffrent
> > import factor
> > (cpu's 1%, Monitors 3%....), in the ProductsGroup
> > Table.
> > UserFactor - The special add-on factor for the customers
> > (Blondes 4%, Brunetes 5%...)
> > ProductFactor - When a special product should have a price raise or
> > discount, we set it
> > with this field in products.asc
> > PaymentFactor - Since we support many payment methods... there is add-on
on
> > some of them
> > (for credit card we chard 3% for the process... and so on)
> >
> > 1. I have added to minivend two tables, the first one is UserFactor
table,
> > where there
> > i have group names and them factor... Same for ProductFactor...
> >
> > 2. I created a global sub, for handeling the calc...
> > GlobalSub <<EndOfSub
> > sub calcprice {
> > my($costprice, $factor1, $factor2,$factor3,$factor4) = @_;
> > my($price);
> > $price =
> > (((($costprice*($factor1+1))*($factor2+1))*($factor3+1))*($factor4+1));
> > currency($price);
> > return $price;
> > }
> > EndOfSub
> >
> > 3. for this explain, i will show how i handeled the results in
> > results.html.. so whenever a product
> > is displayed with the search result loop... there is a little mess going
> > behind the html:
> > [if value payment eq "0"][sql type=list query="select cash from ugroups
> > where grp = '[value grp]'"]
> > [value name="userfact"
set="[sql-param
> > cash]" hide=1]
> > [/sql]
> > [sql type=list query="select cash,
> > impfact from pgroups where grp = '[item-field grp]'"]
> > [value name="productfact"
> > set="[sql-param cash]" hide=1]
> > [value name="importfact"
> > set="[sql-param impfact]" hide=1]
> > [/sql]
> > [currency][perl arg=sub
> > interpolate=1]calcprice([item-field price], [item-field basefact],
[value
> > userfact], [value productfact],
> >
> > [value importfact])[/perl][/currency]
> > [/if]
> > (There are 3 possibilites for payment...., payment= 0 its cash, payment
= 1
> > its thirty days, payment=2 its sixty days)....
> > [value grp] is taken from userdb database, and its the name of the group
> > that user is belong to
> > [item-field grp] is taken from products database, and its the name of
the
> > group that product is belong to
> >
> >
> > I know its quite a bizzare way to do so...., but its working......
> > I have only one problem.... i do all the calculation in the basket.html
by
> > myself...
> > not using subtotal... i will be glad if someone will have an idea how
can i
> > set
> > the price field of an item to item-price... so how can use the normal
> > minivend
> > tags (tax, subtotal, total) insted of my own....
> >
> > I hope it was clear (I still do not understand how i did it... but it
> > works...)
> > 8-)
> >
> > Eran.
> >
> > ----- Original Message -----
> > From: "junglepost" <junglejj@swbell.net>
> > To: <Minivend-users@minivend.com>
> > Sent: Tuesday, May 23, 2000 8:49 AM
> > Subject: [mv] Pricing based on customer status (with a few twists)
> >
> >
> > > ****** message to minivend-users from junglepost
<junglejj@swbell.net>
> > ******
> > >
> > > Hello List,
> > >
> > > I am a medium skill level Minivend developer. I have done several
> > > sites, and they all have this or that specific challenge. One of my
> > > latest ones is racking my poor tired brain. If someone out there
> > > could help me I will buy you a beer. Or mail you one, or something...
> > > ;)
> > >
> > > 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.
> > >
> > > I have looked at several options on how to implement this.
> > >
> > > 1. Locale seems to be one option, but it is not obvious to me at the
time
> > > how to use it.
> > >
> > > 2. I could set a variable via a password page and try to do some sort
> > > of [if variable...][perl config]
> > > {config}{PriceField}='dealerprice';[/perl] [/if] type of thing
> > > (dangerous??)
> > >
> > > 3. I could set up some sort of convoluted [discount] tags (this would
> > > end up being messy and complex)
> > >
> > > Have any of you experience in this area? I searched the maillist
> > > database and found a couple similar things, but nothing really
> > > illuminating.
> > >
> > > Thanks for your help!
> > > James Johnson
> > > flam@bigfoot.com (even though majordomo don't like bigfoot ;)
> > >
> > >
> > > -
> > > 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
> >
> >
> > -
> > 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
> >
>
> -
> 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
-
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
