php - E-commerce website database design

Question

How to design the database of e-commerce website? Are there any good templates?

Answer 1

Imitate Taobao SKU select product attribute code https://www.yujianni.top/news/comp_artinfo.html?id=103

Answer 2

E-commerce is a large area and cannot be generalized. Different types may have big differences. For example, the business logic of retail e-commerce and hotel and catering e-commerce are very different. Of course, the database design will also be very different. Big difference. However, since it is e-commerce, there will of course be similarities. For example, there will be suppliers and buyers. Since there is a transaction, it will involve goods, and if there are goods, it will involve the attribute information and price of the goods. and inventory. In addition, store information should be involved for sellers, and shopping cart information should be involved for buyers. If it involves online transactions, it will involve payment, and if it involves payment, it will involve orders. If it involves delivery, there will be logistics information. If the comment function is turned on, comment information and ratings will be involved. . . The simplest case is to create a table for each item I mentioned above~~

Answer 3

The poster can refer to GitHub open source mall programs such as opencart Magento, etc. (including database design)
Recommend the poster to take a look at this project https://github.com/fecshop/yi... The open source mall developed by Chinese people is based on the Yii framework code quality Not bad (database design included)

Answer 4

Refer to shopex or ecshop

Answer 5

It is recommended to refer to shopnc, not only the database, but also the code inside is good.
Forget it about ecshop, it’s too old and it’s been messed up, it’s terrible.