Order status/ inventory status viewing 1

[ajdesigns]

How can I develope a web page so that my customers can submit thier order no and view the status of their order from a report generated from our database ie: Completed , Despatched,etc.. I know this report would have to be refreshed often. Also could I go along the same lines to allow our suppliers to enter a raw material code and check our inventory so that when it reaches a predetermined level (safety level)it would initiate an order from us to replenish our stock.
I assume this web based route is the only way this could be achieved,
please help
AJD

 

[ChrisHunt]

If you have a database of stock/orders, both features should be easy to implement.

For the "Where's my order?" bit, you need to write a server-side program using PHP, ASP, Perl, or similar to query the database and return the order status in response to a request (there's no need to refresh a whole load of static reports). You might need to implement some kind of password system to protect the privacy of order recipients.

For the stock replenishment bit, have some kind of trigger or batch job which checks stock levels and prints an order/sends an email when they get too low.

In both cases, though, you may want to look around for a ready-made solution rather thn trying to re-invent the wheel yourself. It could work out cheaper in the long run.

-- Chris Hunt

http://www.extracon.com

http://www.mcgonagall-online.org.uk

http://www.napitalia.org.uk

http://www.leicesteryha.org.uk