Re: Simple (?) price adjustment

[Barry Treahy <treahy@mmaz.com>]

******    message to minivend-users from Barry Treahy <treahy@mmaz.com>     ******

You're using SQL?  Are there ideas for the vanilla system?

Barry


Thompson-Jordan wrote:

> ******    message to minivend-users from "Thompson-Jordan" <Thompson-Jordan@mindspring.com>     ******
>
> > ******    message to minivend-users from Tim Shea
> > <tim@valutech.net>     ******
> >
> > Hi Mike,
> >
> > Why don't you just update the prices before uploading? Should
> > be pretty simple to do in either Access or Excel.
>
> I precalculate price with an update query. It's fast even with many
> records. My source database has cost fields and I generate the price
> field. I can even select the lowest cost vendor for an item. I like to
> precalculate and presort whenever possible; Minivend has enough to do.
>
> Christopher Thompson
>
> >
> > Cheers,
> > Tim
> >
> > On Thursday, April 08, 1999 12:57 PM, Mike Lerley
> > [SMTP:mike@bfent.com] wrote:
> > > ******    message to minivend-users from Mike Lerley
> > <mike@bfent.com>     ******
> > >
> > > In the hopes that someone missed this the first time, I am
> > reposting the
> > > following question... please help me.
> > >
> > > ******    message to minivend-users from Mike Lerley
> > > <mike@bfent.com>     ******
> > >
> > > OK.  The prices in my products database, which is supplied to me by my
> > > distributor, are MY cost.  I want to add $2 to each as my
> > retail price.
> > > i.e. if the price in the db is $9.49, the price to the customer should
> > > be $11.49.  I have searched the docs and list and can't find
> > an easy way
> > > to do this.  Do I have to set up a pricing database with attributes,
> > > etc?  Please tell me there's a simple way.  Thanks!
> > > -mike
> > >
> > > --
> > > Mike Lerley, System Integrator
> > > Goold Health Systems
> > > 24 Stone Street
> > > Augusta, ME 04330
> > > Email mike@bfent.com
> > > Phone (207) 622-3298
> > > Fax   (207) 623-5125
> > > -
> > > 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
> > -
> > 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
> >
>
> -
> 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



-
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