Re: [mv] Pricing and Subtotal help.

[".cory.trese." <digital@specialty-books.com>]

On Wed, 20 Oct 1999, you wrote:
>******    message to minivend-users from Andrew Mull <mull@early.com>     ******
>
>Hello,
>
>The items in my catalog require the use of two prices - one for members, 
>and one for non-members.  There is no correlation between the two prices 
>for all the products. i.e.  The member and non-member prices do not follow 
>a certain rule ($5 off or 10%, etc) for all the products in this 
>database.  Therefore, the "discount" facility will not work for me.
>

Hmm.  I see.  Perhaps placing all the products in one database is not the best
way to do this.  MiniVend (at least to me, I may be way off here) seems to be
pretty set in it's ways of using one base price and then adjusting it for
different circumstances.

>Is there a way to have Minivend use a different field for "item price" when 
>calculating the [item subtotal] and [subtotal], etc.
>

I don't think so, since the field for price is a definded value in the
catalog.cfg file, and I think the code behind those two tags must use that
value internally, and probably does not have a method for using different
fields.

What I would do is use two databases.  If you were to setup one database for
members, and one for non-members.  Place identical product lists in each
database and then append a set alphanumeric key on one of the databases's list
of item-codes.  This way, you could setup a members page that searched the
member's database, and a non-members page for the non-members database
(obviously, sorry.)  Each database would have only one price field, but you
would be able to give your members arbitrary discounts just by changing the
prices in one database.

Anyway, this way you could keep two unrelated price lists.  You could take an
Excel file that contains all your product information, and then write a macro
to create to .asc files for use on minivend. (this is just what I have done,
and has nothing to do with minivend.)

You might also be able to use some type of SQL construct to do this too, but
I'm not sure of the logic that would be required.

>Thanks in advance.
>
>-Andy 
>-
>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
--
========================================
Cory Trese 
email : digital@specialty-books.com
fone : (740) 594 - 2274, ext 223
phax : (740) 593 - 3045
========================================
Mail Sent from

Specialty Books,
Athens Ohio, 45701
www.specialty-books.com

RedHat Linux, Hedwig
P][  /   2.3.5
========================================