[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] Pricing Strategy
****** message to minivend-users from Ryan Hertz <rhertz@gyb.baits.com> ******
At 10:22 PM 3/13/00 , you wrote:
>****** message to minivend-users from "Honig, Daniel"
><Daniel.Honig@pfizer.com> ******
>
>
>
> I am new to minivend but quite accustomed to perl and internet programming
>in general. I've spent more than an hour or so reviewing discussion and
>documentation on CommonAdjust, PriceBreak and so on....So far I'm unable to
>figure out how I can get them to work with my requirements...I think I will
>have to write my own pricing function....Being new to MiniVend
>I'm in desperate need of some guidance....
> I can redesign this table structure, but it's best to be kept the same for
>
>
>
>The table of products is defined as a product code and description
> ex
> CODE DESC
>458 SPOTBILT `MONSTER'
>A36 `INTERAWEAR' SPORT SHORTS
>
>There is a table of sizes and "pricegroups".....Some items are placed into
>different price groups based on sizes...
> As shown below the sizes may use different enumerations
>
>CODE COL SIZE PRICEGROUP
>458 10
>458 101/2
>458 11
>458 111/2
>A36 L 1
>A36 M 1
>A36 XL 1
>A36 XXL 2
>A36 XXXL 2
>A36 XXXXL 2
Except the "code" / key field must be unique.
>The pricegroup field if it exists is used to key another table containing
>the pricing information,
> the price group field is not used with an item that has only one size....
>
> CODE GROUP QTY PRICE
> 458 38.95
> A36 38.95
> A36
> A36 1 3 15.95
> A36 2 16.95
>
>
>When the quanity is 3 or greater and the pricegroup is = 1 the price should
>be 15.95
>
>
> So after reviewing CommonAdjust and PriceBreak I can't figure out how I
>could create a new table to get this to work or how to use the existing
>table structure to work
>with these functions either. My gut feeling is that I will have to write
>my own pricing function that executes a query to MySQL to determine the
>correct price for an item.
>
> Is this the correct strategy and does anyone know of an example of how to
>write your own pricing function?.....Would I do this with a UserTag?....
You can put any manner of [calc] or [perl] or other minivend tag inside the
formula portion of the pricing.asc database. I think you're on the right
track.
> thank you kindly for any help!!....this is not an easy one!....
>
> -daniel honig
Ryan Hertz tel 800-645-BAIT
Webmaster fax 520-645-2588
Advertising Director http://yamamoto.baits.com
Gary Yamamoto Custom Baits, Inc. http://www.insideline.net
-
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
