HomePHP Page 3 - Building an E-Commerce Site Part 1: Building a Product Catalog
Overview of a Simplified E-Commerce System - PHP
This is the first article in a three-part series dealing with using PHP 4 and MySQL to make a comprehensive e-commerce storefront solution. This article covers the product catalog database design and creating the catalog administration interface.
E-Commerce systems, no matter how fancy or how simple, involve three basic functions:
Displaying a product catalog
Allowing customers to browse through the product catalog
Allowing customers to buy items from the product catalog
What do you do when you visit an online merchant? You look through their product catalog to see what they have for sale. Let's say you find something that you like and would like to buy, you'd add the item into your shopping cart and then eventually complete the order by supplying payment information.
Here is a simple diagram to illustrate the process:
John Doe visits the MyMarket website and access the product catalog
The server generates the product catalog by reading the items from the database
John browses the catalog and adds items into his shopping cart
The server updates John's shopping cart with the items he has selected
John goes to the checkout to complete his order
The server generates his order summary by calculating the price of the order
John verifies the order, then supplies his credit card number for validation
The server talks to a payment authorization service to validate the credit card
The payment is authorized and the result is sent back to the server
If all goes well, and John's transaction is saved into the database and John waits for the socks
That's the big picture of the entire process. For now it may be a little confusing, but as we go through each of the steps everything will make more sense. We will begin by creating the product catalog, and the maintenance scripts that will us to manage it.