Williams Specialty Company (WSC) eCommerce Web Site
1. System Description
Williams Specialty Company (WSC) is a small print and engraving organization. Currently, WSC is operating on a stand-alone system that provides an electronic catalog and allows authorized WSC employees to add and update customer and order information. WSC wants to provide a web site so that their clients can provide the order information through a website. In addition, WSC wants to provide their entire catalog on the website. However, the sales person must also be able to access customer and order information as necessary to assist the customer and fill out customer orders if requested by the customer.
The following is a narrative describing how the operations are currently conducted within WSC.
When a customer requests a printing or engraving job the sales person must enter the information into the order database (1) type of job (print or engraving), (2) media (clothing, plague, or trophy) (3) media catalog number, and (4) content into the print/engraving request database. The sales person then makes payment arrangements with the customer, which includes billing an existing customer, setting up an account for billing, or payment on delivery. If a payment on delivery option is selected, the sales person requests and receives at least a 10 percent deposit.
The operations manager validates the order by verifying the payment and customer information. If the order is not valid, the customer is notified via email and telephone. If the order is valid, the operations manager assigns the job to a printing or engraving specialist.
The Printing/Engraving specialist is notified when they have been assigned a new job. They check the inventory stock level. All available stock needed to fill the order is marked as sold and the Stock Room Clerk is notified to pull the media for the job.
All orders that cannot be filled with the available stock are marked as