[mv] Pricing Strategy

["Honig, Daniel" <Daniel.Honig@pfizer.com>]

******    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	



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?....

   thank you kindly for any help!!....this is not an easy one!....

         -daniel honig   











    

-
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