Spectrum Global Communications Inc. is a full spectrum Information Technology provider for Kitchener, Waterloo, Cambridge, Guelph, Brantford, London and most of Southern Ontario.  We are an Internet Service Provider ( ISP ) with much more inluding Computer Hardware Sales & Service, Network Creation & Maintenance and Web Development & E-commerce Applications.
check your Internet usagenetwork status virus alerttechnical supportcontact information
residential services commercial services network solutions web services telephony corporate information
Spectrum Global Communications Inc.
Thursday, November 20, 2008
Residential Services
Commercial Services
Network Solutions
Web Services


Website Hosting
Web Development
E-commerce
Web Portfolio Showcase
Website Statistics
Web Advertising
Server Colocation…

Telephony
Company Info

request more information

Showcase: Adventures in Advertising

Problems with old System:

  1. Placing an order was taking 20 minutes per product for External Sales Reps. Total orders often took over an HOUR to place!
  2. There was no consistency between the layout of Quotes, Invoices and Purchase Orders between Head Office and the Remote Offices.
  3. Product Catalogues were being shipped to each and every customer and potential customer in two three-inch binders.
  4. Products were repeatedly out-of-date before the catalogues even reached the customers.

The Spectrum Advantage:

By centralizing AIAs product line and customer information on a Centralized SQL server, and creating a Web-based Interface for the Remote Offices, AIA's External Sales Reps are able to place Orders in minutes (not hours)!

All Quotes, Invoices, Purchase Orders, and Credit Applications were created in template format using Cascading Style Sheets so that the name, address and phone number of each Remote Office are automatically input into the form based on the username of each unique Sales Rep. In this way, all forms are consistent throughout the company, regardless of originating office.

By accessing the same Product and Client Database as the Sales Reps, and creating a Public Web Interface, customers are now able to view Products and Pricing in real-time. Customers are now directed to AIAs Online Catalogue, instead of being sent out through the Post Office.

Other benefits to AIAs Spectrum advantage:

  • Previous Clients can log in and see a list of their past orders. They can then choose to re-order an old product or full order.
  • AIAs internal staff can update their Product Catalogue at any time, with the click of a mouse.
  • AIA has established "customized catalogues" for their clients to enable to see only personalized Promotional Products for their own staff to order from. Special Pricing, products, and payment options are available to these groups, based on Username.
  • Customers can view AIAs online catalogue and submit orders 24 hours a day, 7 days a week

Previous Showcase Showcase Home Next Showcase
Residential Services | Commercial Services | Network Solutions | Web Services | Telephony | Corporate
network status | virus alert | contact us | careers | disclaimers  
Member of the Canadian Association of Internet Providers © 2008 Spectrum Global Communications Inc.
Please contact an Account Representative with questions or comments regarding this website.