[ic] UI Order Desk help

Doug Alcorn doug@lathi.net
15 Nov 2000 09:29:00 -0500

"Eric Hull" <eric@webuildpcs.com> writes:

> The problem is we have not found a way to enter in different prices
> for products "on the fly"

I am looking at something similar.  We have field salesmen who each
get a specific discount.  I think I will implement this as a seperate
table listing the salesman's name, a special "hard to remember code",
and a discount percentage.  I will then add a new input box so that
the customer can enter the salesman code and receive the appropriate

> the problem is the prices for many products can change daily, and
> not always at a specific rate ($1.00, or 5%) sometimes it is $1.47
> today and $1.83 tomorrow.  Updating this in the database wuld be too
> time consuming.

How do you keep up with price changes now?  Are they in a computer
anywhere?  Can you figure out some perl script that would import the
new prices each day from whatever your source is?  If not, then manual
override of the price may be your only solution.  You have basically
said that you can't keep the prices in the database accurate.  That
seems to be a problem unto itself.
 (__)  Doug Alcorn (mailto:doug@lathi.net http://www.lathi.net)
 oo /  Unix Hacker
 |_/   "It's too late for paradise" (at least in this life)