Hi, I am new to database design. I want to make an complex ecommerce database design can someone suggest me nice tutorial that can teach me complex ecommerce database design structure ?
Why would you want to do something complex?
My rule of thumb is KISS.
You will at least need the following tables
Don't know how familiar you are with Laravel but I suggest following Adam Wathan's Testdriven Laravel where lots of the things you will need for an e-comerce site is covered.
learn the basic first if you are new....
Thank you guys, so I did research again and I have made my own ecommerce database design.
I have one question, Question is : because there are many foreign keys and adding more foreign keys comes with the performance hit than how do u handle this ??
take the mysql database design lessons above, the answer is inside.
The database is necessary for any ecommerce website. It become complex according to the features you’re providing in website. The product table is the most important table for any ecommerce site. My website https://www.customizejackets.com/ has multiple features and to accommodate it I have used the free MYSQL database with all the necessary tables and columns. Laravel may also be used to manage the complex database.
When it comes to e-commerce, you'd probably want to manage your products out of a PIM and not in your webshop. You could look at some open-source PIM systems to see what your needs are.
The biggest open-source PIMs are: PIM Core and Akeneo.
Please or to participate in this conversation.