Re: <no-solution>CommonAdjust Help Please (Solution)

["Rob Zimmerman" <rob@readysite.net>]

******    message to minivend-users from "Rob Zimmerman" <rob@readysite.net>     ******

Jayme

The store I am working on sells puzzles along with a few other misc. items. If 
someone buys 2 or more puzzles they get them for 12.50 each instead of 
14.95 for one, (any combination of puzzle titles). This works great under the 
MixMatch directive but when you add the other items to the mix it doesnt 
because now it gives the discount on one puzzle if also a misc. item was 
also orderded. 

I checked out your example and it does not mix and match for quanity 
discount. 

Many thanks for your efforts though. I did not think of trying to use a 
commonadjust string in the price field. I will try that angle. 

Rob
----------

-------
> ******    message to minivend-users from Ceres <jfrye@ehg.net>     ******
> 
> Rob,
> 
> 	Are you just wanting certain items to have quantity price breaks? If
> so, try CommonAdjust. I use it in the following way to give quantity
> price breaks to a few items.
> 
> First I set up my catalog.cfg with: 
> 	
> 	CommonAdjust   set_in_products_price
> and
> 	#PriceField   no_price
> 	
> This sets CommonAdjust extended pricing on. But, since it is a non valid
> CommonAdjust string it will look in the products database price field
> for a valid string. Also, comment out the price field because it will
> enable the CommonAdjust scheme for ALL products.
> 
> Then, in the products database price field, for each item that gets a
> qty price break I place a string like:
> 	
> 		pricing:q1,q6, ;16.90
> 
> This is a valid CommonAdjust string which looks in the pricing database
> for qty 1 and 6 for price information. It also sets up a fallback price
> when no price information exits for a given qty.
> 
> Finally, the pricing database lists all the item codes that price breaks
> are given on and the corresponding price.
> 
> 		code	q4	q6
> 		110B		14.40
> 		110G		14.40
> 		140B	16.40
> 
> This is working for me on my development site
> com1.ehg.net/cgi-bin/hgdev. Go to the workpapers section to see it.
> 
> Have Fun!
> Jayme Frye
> 
> Rob Zimmerman wrote:
> > 
> > ******    message to minivend-users from "Rob Zimmerman" <rob@readysite.net>     ******
> > 
> > I need to provide a MixedMatch quanity discount for 'most but not all' items in my
> > products.db. I am trying to figure out a scheme that will let me do this. Can
> > MixMatch be applied to only specific databases? If so then I can make separate
> > databases for these items. If not then using CommonAdjust is the way to go.
> > 
> > Here is what I am trying but it doesn&#146;t seem to work:
> > 
> > CommonAdjust: ;products:price, pricing:q1,q2:key,
> > 
> >   (key is a column in the pricing database that marks
> > the items that will get quanity discount.) My thinking
> > is all if item is keyed then include in q1,q2 quanity
> > pricing scheme.
> > 
> > Maybe I am going about this wrong and should try doing
> > this with MVdiscount tags?
> > 
> -- 
> Jayme Frye
> Sys Admin
> Epsen Hillmer Graphics Co.
> 402-342-7000
>               jfrye@ehg.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
> 


=================================
Robert Zimmerman [rob@readysite.net]
System Administrator
ReadySite Web Hosting and Design
http://readysite.net
Ph:888-356-2992
fax:603-356-6990
-
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