190 likes | 296 Views
Joe Lieman E-Commerce Solution. Introduction. Provides a good and reliable online business, providing the customer with a simple and rewarding shopping experience An affordable way to open an online store with PayPal, UPS, FedEx and USPS compatability. Project Specification (end-users).
E N D
Joe Lieman E-Commerce Solution
Introduction • Provides a good and reliable online business, providing the customer with a simple and rewarding shopping experience • An affordable way to open an online store with PayPal, UPS, FedEx and USPS compatability
Project Specification (end-users) • View a product's details • Place a product in the shopping • View and edit the shopping cart • Check out and place an order • Search for certain products based on product names or descriptions • Browse the list of products by category • Login, order history, and order tracking
Project Specification (admin) • Modify orders • Monitor traffic • View and edit the shopping cart • Email customer • Add products, categories, users control • Promote products using “on special” feature
Technology • PHP • MyMarket CMS • PayPal SourceForge Project • MySQL • eBay Platform?
A little bit about MyMarket • MyMarket is a fully functional online shopping catalog system, built using PHP and MySQL. It was created by Ying Zhang for the purpose of teaching people about the basics of creating an E-Commerce site. • http://mymarket.sourceforge.net • Projects based on MyMarket: http://www.freznoshop.com/shop/index.php, http://www.pgmarket.net/, http://digilander.libero.it/marketplus/demo/index.htm
Setting Up • Install PHP on an NT/2000/XP Server running IIS 4 or newer • Install MySQL • Download & Install MyMarket v1.72 • Configure your MySQL and MyMarket
Database Design • TABLE Categories: id, parent_id, name, description • TABLE order_items order_id, product_id, price, qty • TABLE orders id, username, o_timestamp, a_timestamp, status, status_details, custinfo, comments, amount
Database Design • TABLE products: id, name, description, price, on_special, timestamp • TABLE products_categories product_id, category_id, • TABLE users username, password, priv, firstname, lastname, email, phone, address
GUI Design • The Default page • Shopping Catalog page • Communication page • Password page • Setting page • Search page • Shopping cart page • Order history page • Admin page
Email System • Auto email for new users • Password reset email • PHP email to send receipt to buyer and store owner
Payment System • Currently using PayPal • Integrating 2 different shopping cart system • PayPal account payment • Credit card payment
Credit Card Validation System • Server side • http://project.xpconcepts.com/test/ccvs-php/ccvs_example.php • More security • Faster
Tracking Page • UPS • USPS • Fedex
RMA Page • Only let customer with a valid orders can apply • Auto email • Admin can easily update the status
Using Secure Socket Layer (SSL)? • If using PayPal Payment Gateway, we don’t need to implement own SSL certificates • This is very helpful since SSL can be expensive to set up
Conclusion • Affordable solution • Easy to implement • Expandable • Free
References • www.paypal.com • https://developer.paypal.com/ • http://mymarket.sourceforge.net • http://www.php.net • http://www.mysql.com/