Database design for a price comparison site

Hi! I am working on a relational database design and need someone with experience to double check and optimze my setup.

Project info:
- I have already setup a suggested database, without relations. The link is here: https://dbdiagram.io/d/lux-6542c7567d8bbd64654e4ee0
- I suggest buidling the database in https://dbdiagram.io/ as I have already started there.
- I have attached JSON file swith all the data from another price comparison site, which can be used as background/template for designing the database
- I need the database design itself and code on how to create it in sql.

Basically I am looking to copy the abilities to these two price comparison sites:
https://www.pricerunner.se/
https://www.prisjakt.no/

About the database, it will contain for example:
- products
- webshops
- three levels of product categories
- search for products and categories
- users
- user reviews (of products)
- user notifications
- product reviews (by for example a magazine)
- delivery alternatives
- payment alterantives
- brands table
- price history
- images
- videos
- siblings products
- recommended products
- suggested products
++ Please have a look at the dbdiagram.io-table and json

What needs to be searchable/indexed (result = a list of products):
- Product names and description
- Categories (use case: show all products within a category)
- Brand names

Filtering on different settings/attributes must also be quick, for example if I just want products within a price interval from brand X.

I am open to suggestions on how to make this database 100% correct and optimized. This also applies to the tables different data types.

About me
Hobby programmer working as a project manager within IT. I am easy to work with and will answer quickly.

About you
You have experince setting up relational databases.

Technology
Probably I will use a mysql database.