Re: CommonAdjust Help Please (Solution)

[Ceres <jfrye@ehg.net>]

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