Ecommerce Database Design

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: 


Image Source:

Above image shows all the product categories,

Fig: Product option table

Product option : Different type of product options like color, size etc. For.



Image Source:

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: