Transcript Web-Based Commerce Auto Parts Store

Web-Based Commerce
Auto Parts Store
presented
by
Victor Hsu
Agenda







Problem/Need
Relevant research
Solution (User profile and design protocol)
Deliverables/Objectives
Technical elements (Software/hardware)
Demonstrate project
Summarize how deliverables were met
Problem
Cincinnati Generators and Starters (CGS)
would like to expand its services
throughout the States.
 As a small business, it does not have
the sale force or the revenue to market
its products through traditional means.
E-Commerce as a Solution




Allows small businesses to compete
with the giants in the industry
Marketing
Sales
Customer support
Has This Approach Been Done?
Auto parts stores on Web





Post company profile
Post specials
Few contain a searchable database
Few allow online ordering
There is a lot of auto parts stores on the
web today, most of them are merely
a marketing presence online
User Profile
Any individual who has contact with the
system is a user of the system.
 The end-users:




Garages
Parts stores
Do-it-yourselfers
And the person maintaining the
database
Design Protocols






Easy to use
Support searching of vehicle parts
Allow updates of vehicles and parts
Identify customer
Make purchase
Support credit card payment
Web Layout
Page Heading
L
I
N
K
S
Web Content
Home Page
Page Heading
L
I
N
K
S
Web Content
Child Page
Deliverables


Relational database with a front-end data
entry forms
E-commerce site:






Allows user interaction
Vehicle parts search
Login/Registration
Shopping cart
Credit card verification
User-centered design
Software




Microsoft SQL Server 7
Visual InterDev 6
Visual Basics 6
Maromedia Fireworks 3
Hardware

Fourth floor lab servers
two server setup – IIS and SQL Server
IIS
Server
SQL
Server
Hardware (cont.)

Home Development Server
IIS and SQL Server on one machine
Same Server
Database
IIS Server
With
SQL Server
Database Architecture
Relational Database Diagram
Database Architecture (cont.)
Implementing the Shopping Cart
Front-End Database Entry
Vehicle Entry Form
Front-End Database Entry
Parts Entry Form
Project Demonstration
CGS Home Page
How Deliverable were Met

A relational data base with front end




Database was created using SQL Server.
Front-end offers a simple solution to data entry
Add new vehicles and parts
E-commerce - User centered-design



Easy to use navigation bar
Layout
Easy to use parts search
Summary (cont.)

E-commerce - User Interaction





Users can contact CGS via email
Go to parts search page
Make purchase
Inline personalization
E-commerce - Parts Search


Smart searching using DB to populate the
select box fields
Used stored procedure to query the result
Summary (cont.)

Login/Registration



Login and registration forms
Used post method
Shopping Cart


Table containing selected items
Items in basket are referenced to current
session
Summary (cont.)

Credit Card Verification


Credit card information form
Validate the authenticity of a credit card
number using VBscript
Questions??????