190 likes | 298 Vues
MyMarket E-Commerce Solution provides a good and reliable online business platform for a simple and rewarding shopping experience. This solution offers affordable ways to open an online store with PayPal, UPS, FedEx, and USPS compatibility, catering to end-users and administrators alike through various functionalities such as ordering, monitoring traffic, product promotion, and order modification. Utilizing PHP, MySQL, and MyMarket CMS, it ensures ease of use and seamless integration. Setting up is straightforward, with GUI design focused on enhancing user experience, efficient email and payment systems, and secure credit card validation and tracking features. The project is expandable, offering a free and efficient solution for online businesses.
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/