RE: Where would you start?

Gary,

good suggestions all - in fact most of this is already spec'd out.

The workflow has already been charted, and I could implement 5 or 6 things
to improve the existing process in short order, but my fears (and those of
management) are that these would only be patches, rather than a strategic
long solutions, and any half-a** attempt at shoring up the existing system
would be throwing good money after bad.  The other fear is that we could
get ourselves into a quagmire of just-learned technologies and techniques
that won't work as thought or advertised - more good money after bad.

The stores are already on a vpn, in fact they can get nowhere except our
network, and specific sites of our choosing.

I guess what I'm looking for is the actual design/programming platforms
that would lend themselves to our requirements.

thanks,

Rick

---original message-----------
Rick,

It may be you are looking at job security, perceived data security, and
CYA issues.  I'd start by doing a work flow diagram of your existing
process.  You'd be surprised at what jumps out at you.  Then I'd start
asking questions and looking for ways to streamline the process.  One
thing that stands out in the process you describe is the paper trail
generated by both sides.  Says to me some form of change control
mechanism to satisfy both sides needs to be part of the solution.

I'd also look at the ROI of my proposed solutions.  If I'm going to a
more computerized solution SSL or VPN will probably play into the mix.
Will you need more equipment, personnel, etc. to implement the solution?
And so on.