Intranet and Extranet - Outcompeting the Competitors

![]()
Our client need a system to "outcompete the competitors". It required a system that would lower it's own operating costs by delivering what customers need, just when they need it. Further, a staff Intranet was required to provide enhanced, web-based information anytime, anywhere for the MD, the sales reps and the support staff.
We were therefore required to build a system that permits:
- customers to:
- login securely
- view stock on hand in each state
- view ETA's for stock on backorder
- view negotiated pricing
- build orders
- place orders through e-commerce system within credit limits, else credit card
- calculate freight accurately to any postcode in Australia via multiple carriers
- View invoices online
- View statements online
- View backorders online
- Search for serial numbers purchased
- Request returns based on serial numbers cross-checked against invoice numbers
staff to:- View extended price and availability information
- View upcoming shipments
- Update customer records
- Create reminders for customers
- Records notes against customers
- Send customers customised price lists in the following formats:
- Excel
- DBF
- CSV
- MDB (MS Access)
- Any fields, iIn any field order
- Search invoice records
- Search serial numbers
- Search customer order data
- Email statements
- Email invoices
- Generate barcoded labels
![]()
Developed over a number of years, this particular Intranet and Extranet was created on an extremely scalable and solid foundation, including Microsoft SQL Server 2000 and replication from existing legacy databses (read: the accounting system).
The key is thorough planning and a vision to create a staff and customer centric system that "outcompetes the competitors".
![]()
Both staff and customers securely access their control panels on a daily basis retrieving information and obtaining service that would otherwise have resulted in an interruption to a fellow staff member or a phone call.
Delivering just what is needed, when it is needed allows our client to "outcompete the competitors".

