
1. Case-study Purpose
The goal of this case study is to deconstruct the Walters Online project, with particular attention being paid towards technical aspects and project management processes. A number of screenshots are presented which show the systems interface, design documents, and administration modules.
The goal of this case study is to deconstruct the Walters Online project, with particular attention being paid towards technical aspects and project management processes. A number of screenshots are presented which show the systems interface, design documents, and administration modules.
2. About Walter’s
'Walter's Wine & Food Store' (or Walter's for short) is a total food and wine concept store where patrons can dine in or purchase food-stuffs to take away with them. Located in the city's Southbank region, the business is well targeted at those with a high disposable income.
The café serves breakfasts and brunches, although it is essentially a food store. The fare displayed in the cabinets is targeted at affluent, high-income city living professionals. Take home salads, a range of ingredients for antipasti and terrines sit alongside more substantial food such as curries, pastas, breads and Walter’s renowned preserves.
With Walter’s catering for the upper echelon of Melbourne’s demographic, it seemed the next logical evolution to their existing online presence to offer online shopping facilities. This would offer busy professionals along with interstate and international visitors the convenience of placing online orders for gourmet food, wine, and gift hampers.
Walter’s existing web-presence generated quite an enthusiastic response. Queries were received from site visitors about the possibility of shopping for wine and food products online.
Walter’s recognised this opportunity for business growth and seized it, commissioning KDG to construct its online e-commerce solution.
This online store would also enable people to send out gift hampers from the convenience of their home to anyone in any part of Australia. The ease with which interstate orders could be handled also granted additional market penetration for Walter's.
3. Project Objectives
The main project objective was to produce a fully functional, profitable, online ecommerce system that works together with the existing Walter’s Wine Bar web-presence. This would provide an alternative avenue for viewing, selecting and purchasing products from Walter’s catalogue.
The success of the system is to be measured by the number of enquiries/orders the website generates and in the reach it has on attracting prospective buyers.
The success of the system is to be measured by the number of enquiries/orders the website generates and in the reach it has on attracting prospective buyers.
4. Benefits to the Organization
In one sentence: reduced costs realised through decreased labour requirements. The website handles a lot of the steps automatically which previously had to be managed by a staff member over the telephone.
Increased market penetration - interstate orders would now be much more viable because customers in other states could see Walter’s catalogue online and purchase goods easily. Another benefit of interstate sales is the boosting of Walter’s branding and image.
Improved product awareness - high resolution images of store goods along with detailed descriptions are available online. Customers can quickly find and research the merchandise they are interested using the online tools.
Refinement of business procedures - the website automatically handles many of the steps normally involved in the purchase process (eg. selection of goods, collection of delivery and payment information, and transfer of funds from customer to Walter’s).
One boon of this automation is reduction in errors caused by Walter’s staff (eg. if a customers delivery address is incorrect, it’s because they entered it incorrectly, not because it was taken down incorrectly by a Walter’s staff member).
Customer and sales information - as purchases are made online; information is gathered and stored in a database. Over time Walters will be able to analyse a customer’s purchasing history and develop targeted marketing and promotions.
Addition of new sales channel - not only will Walter’s be selling their goods via their physical store, they now have a 24/7 presence on the Internet from which to sell merchandise.
5. The Walter’s Online Website
The Walter’s Online website is primarily designed to be an web-based selling tool. Its purpose is to allow customers to buy goods online which are normally available in the physical Walter’s store.
Some of the things the website does include; allow a visitor to peruse Walter’s catalogue of products, provide searching facilities, with product searching by keyword (eg. 'Extra Mouldy Blue'), or by category (eg. show me all the chocolates Walter’s stocks)…
View a picture of a product and read a description about it…
Allow a shopper to add goods to their virtual shopping basket and buy the goods they’ve put in their basket…
The system lets a shopper pay for their goods either by using their credit card or an alternate arrangement made over the phone or by email...
Refinement of business procedures - the website automatically handles many of the steps normally involved in the purchase process (eg. selection of goods, collection of delivery and payment information, and transfer of funds from customer to Walter’s).
One boon of this automation is reduction in errors caused by Walter’s staff (eg. if a customers delivery address is incorrect, it’s because they entered it incorrectly, not because it was taken down incorrectly by a Walter’s staff member).
Customer and sales information - as purchases are made online; information is gathered and stored in a database. Over time Walters will be able to analyse a customer’s purchasing history and develop targeted marketing and promotions.
Addition of new sales channel - not only will Walter’s be selling their goods via their physical store, they now have a 24/7 presence on the Internet from which to sell merchandise.
5. The Walter’s Online Website
The Walter’s Online website is primarily designed to be an web-based selling tool. Its purpose is to allow customers to buy goods online which are normally available in the physical Walter’s store.
Some of the things the website does include; allow a visitor to peruse Walter’s catalogue of products, provide searching facilities, with product searching by keyword (eg. 'Extra Mouldy Blue'), or by category (eg. show me all the chocolates Walter’s stocks)…
View a picture of a product and read a description about it…
Allow a shopper to add goods to their virtual shopping basket and buy the goods they’ve put in their basket…
The system lets a shopper pay for their goods either by using their credit card or an alternate arrangement made over the phone or by email...
6. Project Management
The Walters system took six weeks to complete, with two weeks taken up by the planning phase and the rest taken up by coding. Three staff members worked on the project (ie. project manager/lead programmer, programmer, and independent QA tester).
The following is a quick break-down of some of the stages involved in the project;
The Walters system took six weeks to complete, with two weeks taken up by the planning phase and the rest taken up by coding. Three staff members worked on the project (ie. project manager/lead programmer, programmer, and independent QA tester).
The following is a quick break-down of some of the stages involved in the project;
-
6.1 Specification
Prior to the commencement of any coding, the system to be constructed is thoroughly ‘spec’ed’. This functional specification describes the system from the user’s point of view. The bulk of the spec is taken up by mock-ups of what screens will look like. -
6.2 Design Acceptance Document
The mock-ups created in the functional spec are ‘rough’ to say least, but give a very good indication of what the system will be capable of and what the user will see when they interact with the system.
From here, the next step is to create a graphical representation of the system. This is made in Adobe Photoshop and is non-functional. For the Walter’s project, a number of iterations took place before the final appearance was settled on. -
6.3 Schedule
Again, prior to coding of the system, the project schedule is constructed. This dictates the timeline and features to be delivered. It also allows for a firm date to be set as to when the system will be completed. The schedule also shows how the workload will be distributed amongst the staff members committed to the project. -
6.4 Database & Technology
High volume traffic was expected for the website so the database-system chosen was Microsoft SQL Server 2000. Stored procedures were used extensively to help optimised the speed the site’s facilities (and facilitate future maintenance and expansion). -
6.5 System Test Plan
A thorough systems test plan was developed to put the website through its paces. The format of the document is designed so as rigorously root out any bugs. It contains both independent and interconnected test cases – these seek to not only check the functionality of individual site components, but also check the process flow from page to page where necessary.
7. Administration Module
A powerful administration module was created as part of the project so Walter’s staff could maintain the back-end processes of the system. The admin system allows Walters to create new products manage existing items. In addition Information about orders and users is stored here. The Walter’s administration system was built using KDG’s proprietary Administration Generation System (or AGS).
8. ScenariosIn designing websites, it helps to imagine a few real life stories of how actual (stereotypical) people would use it. This is one scenario extracted from the system’s functional specification;
-
8.1 Scenario: Bill (the online shopper)
Bill is an avid fan of Walter’s products, he works in the city and often pops down to Southgate to grab a nice bottle of wine or arrange for a gift hamper to be made. On his last visit to the shop, Bill spotted a pamphlet advertising Walter’s new online store, “this looks alright; I’ll give it a go” Bill thinks to himself as he grabs a pamphlet.
Later that night whilst surfing the web he remembers the Walter’s pamphlet. Typing in the website address, Bill finds himself at the Walter’s website in no time at all. “Hhhmm… I’m not sure what I want” he thinks to himself, so he looks at the ‘Browse Products’ list - Cheese, yeah, I might buy some nice cheese”.
After clicking on the ‘Cheeses’ link; a new page loads up and he is then presented with a list of the cheeses Walter’s Stocks. “Ooohhh, ‘Blue Mountain Goat Veiny’ - that sounds great. I’m going to buy one of those!” Bill clicks on the link for the cheese he wants and is taken to a page with a more detailed description of the item.
He adds the cheese to his ‘Basket’ and then clicks on the ‘Checkout’ button seeing that’s all he wants. He is taken to the payment and delivery details page where he fills in his name, address, and credit card information.
Bill gets a chance to look over what he’s typed before finally committing his order. A few days later, Bill receives a package in the mail containing the cheese he ordered.
Back to top
