Re: [mv] quantity pricing with multiple product databases

[John Turner <johnt@compar.com>]

******    message to minivend-users from John Turner <johnt@compar.com>     ******

I do not clearly remember which way around it was but I did try to
control the display using an [if] based on this result.  One of
[item-price noformat] and [item-price noformat=1] gave $0.00 and the
other gave 0, if the item was in prodktm.   If the item was in products
then the result would be either $123.00 or 123.   If [item-data prodktm
price] was the reference then it was always $0.00 or 0 regardless of the
table the item was in, but [item-data products price] gave the right
values if the item was in the products file.   This was essentially how
I deduced the price was zero inside quantity.html if the item resided in
the auxilliary products file.

jojo@buchonline.net wrote:
> On  5 Jun, John Turner wrote:
> > We have also run into this problem.   We have only two product databases
> > so far: one with our own in-store products, and the other a complete
> > parts list for one of our major product lines.   The quantity pricing
> > works fine on our products, but comes up with all zeros on the parts
> > list products.   I have tried Mike's suggestion of using just :price in
> > the CommonAdjust, but to no avail.   When I attempt to reference the
> > price from quantity.html, whether as price, loop-price, item-field price
> > or item-data prodktm price, the result is always zero (prodktm is our
> > parts list database).   As a result we have turned off the quantity
> > pricing feature since it is not strictly necessary at this stage of our
> > store's evolution. Incidentally, we are using mysql for the databases
> > and have used the simple demo as a basis for the store
> > (cistore.compar.com).
> 
> What is in your database as a price? "123.00" or "$ 123.00"?
> What ist for example [item-price noformat] or [item-price noformat=1]
> telling you?
>
-
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