What are the optimal "schemes" for creating an online store?

Question

MySQL

You need to create the simplest type of online store with a list of products, a filter by category, authorization and a shopping cart.
Are there any optimal database schemes for online stores? And how to "build" the code in these projects?

Answer 1

Are you interested in gray schemes or are you still white?

Answer 2

The simplest scheme - we take csv, write a script, make a static site
More difficult - EAV
Even more difficult - json

Answer 3

Guys, maybe a little off topic, but how to attach product cards using the simplest html? Or even easier, how to make a big picture pop up when clicking on a product in a category? The site was written in a notepad, it is now more of a corporate than an online store: www.lustry-gus.ru We want to turn it into a store with minimal effort.