[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
RE: Simple (?) price adjustment
****** message to minivend-users from "Thompson-Jordan" <Thompson-Jordan@mindspring.com> ******
> ****** message to minivend-users from Barry Treahy
> <treahy@mmaz.com> ******
>
> You're using SQL? Are there ideas for the vanilla system?
Not sure exactly what "vanilla system" you mean.
Christopher Thompson
>
> 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
>
-
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