The most important table in an Ecommerce website is Product table. E-Commerce means Electronic Commerce. To order any product, you don’t have to go anywhere else, you can order it at home and then it gets delivered at your home. Due to the emergence of E-commerce websites, it has become very easy to shop online.
Product Table
This is the most important table used in an ecommerce site because product table relates to all tables in the databaseand related fields are entered in this table like product name, price sku code etc.
Open Source which develops commerce sites are as follows:
- OpenCart
- PrestaShop
- Magento Community Edition
- Zen Cart
- Spree Commerce
- Drupal Commerce
- osCommerce
- simpleCart
- WooCommerce
- WP e-Commerce
- Jigoshop
To Create Product Table,
![]()
Product Category Table
Product category means different types of product with different categories. See example below:
Fig: Product option table
Product option : Different type of product options like color, size etc. For.
Example:
Options tables : productoptions
Table name: options
Table name: optiongroups
User table :
User table is used to store user information in the database .
Order table :
Purchase product and generate unique order number. ![]()
Description of Tables Using Relation Diagram
![]()
Read more articles on
Databases: