e commerce web site sales and inventory management system n.
Skip this Video
Loading SlideShow in 5 Seconds..
E-commerce Web Site: Sales and Inventory Management System PowerPoint Presentation
Download Presentation
E-commerce Web Site: Sales and Inventory Management System

Loading in 2 Seconds...

play fullscreen
1 / 25

E-commerce Web Site: Sales and Inventory Management System - PowerPoint PPT Presentation

  • Uploaded on

E-commerce Web Site: Sales and Inventory Management System. Markku Marjoneva. The customer: Akiba Oy. Founded in 2003 Retailer selling: Computers and computer equipment Digital cameras Home theater systems GSM, GPS and outdoor equipment

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'E-commerce Web Site: Sales and Inventory Management System' - ziv

Download Now An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
the customer akiba oy
The customer: Akiba Oy
  • Founded in 2003
  • Retailer selling:
    • Computers and computer equipment
    • Digital cameras
    • Home theater systems
    • GSM, GPS and outdoor equipment
  • Concentrates mostly on enthusiast level equipment with competetive pricing
  • A new company with a web site layout without functionality
  • Tools for editing products and product categories already done
  • Database design mostly done
  • In need of customer site functionality
requirements 1
Requirements 1
  • A customer web site
  • Browsable product categories
  • Product information view
  • Product search
  • A shopping basket
  • Order sending
  • Product promotions
requirements 2
Requirements 2
  • Employee web site
  • Order management and handling
  • Order search
  • Inventory management for separate warehouses
  • Inventory transfers between warehouses
requirements 3
Requirements 3
  • Additional tools for employees
  • Sales reporting
  • Warranty handling tools
  • Employee communication tools
  • Product information integration
  • Not covered in depth in the thesis
customer web site1
Customer web site
  • Implementing the functionality to the site design and keeping a consistent overall look for the customer site
  • Using the product information already in the database to create product listings
  • Shopping basket
  • Search
  • Promotions
web based application
Web-based application
  • Benefits of web-based application
    • Platform independence
    • GUI tools ready
    • Low learning curve
    • Accessable
    • Does not require installation
    • Can be hosted off-site
    • PHP and MySQL a proven platform
web based application1
Web-based application
  • Disadvantages of web-based application
    • Can be slow
    • Simple user interface
    • Network outage disables the system
    • High bandwidth usage
    • Real time tools require special arrangements
    • Not suitable for all tasks
    • Possible browser incompatibilities
employee web site
Employee web site
  • Orders were at first sent as emails
  • Database based order management was needed quickly
  • Required database design and implementation to hold the order and product data
  • Required creation of order editing tools
order editing
Order editing
  • The most important functionality
  • Holds the information of
    • Order status
    • Customer information
    • Extra information
    • Ordered items
  • Displays product inventory status
order search
Order search
  • Interface is similar to the order editing view
  • All fields are searchable
  • Powerful search capabilities
  • Familiar interface
  • Receipt has to be printable from the web-based system
  • There is no enforced web standard for printing a web page
  • Browser selection can be controlled (Mozilla Firefox & MS Internet Explorer)
  • Solved with CSS and PDF
inventory management
Inventory Management
  • Inventory management is needed to control the product flow
  • The system should know if the required product is in stock, if it needs to be ordered of if it is already ordered.
  • This has to work on several warehouses
inventory management1
Inventory Management
  • When products are ordered this is marked in the database
  • When products arrive from the suppliers, they are signed into the system
  • The products and their serials (if needed) are read using barcodes
  • The inventory tools had to be designed so they work with barcode readers
inventory management2
Inventory management
  • Inventory status has to be updated automatically when orders are handled
  • The inventory status is visible from the order editing interface
inventory transfers
Inventory transfers
  • All products are signed in at the main warehouse
  • Products are transferred from the main warehouse to other location(s)
  • There is a tool for transferring batches of items from one warehouse to another and keeping the inventories up to date
  • Security is based on usernames, passwords and user group separations
  • User names and passwords are used for entering the system
  • The system is divided into seller site and office site with different privileges
  • All the tools are separate script files
  • Common variables and functions are kept in include files
    • Database connections
    • Global configuration variables
    • Common methods
  • Functionality can easily be tested and implemented separately
problems with the project
Problems with the project
  • Requirements for features came as the system progressed
  • No real overall design for easy implementation of functionality
  • Partially obsolete database structure the cannot be changed
  • Adding new functionality without affecting old functionality is difficult
  • The project was a success and is in use
  • The system is still under constant development to include new functionality
  • Design and implementation of a new system has been started