How to organize the correct table structure for an online store goods - suppliers?

Question

MySQL

Good day. When designing a database (Spanish MySQL) for an online store, a dilemma arose. There is a product table. A product can have several suppliers (nomenclature item number). Suppose there are 10 suppliers and 10 products. I have two options for storing data:
1. two tables: products(id,....) and providers(id_product,p1,p2,...,p10) - pluses one to one, since there will be about 20k products. Cons to add a supplier, you will need to change the structure of table
2. three tables: products(id,...),providers(id,name),product_providers(id_product,id_providers,code) - the pros seem to be similar to EAV, but not sure about performance .. And by the number of records in the table. And you can easily add a new supplier.

The cost of goods from suppliers is not taken into account.

Answer 1

Products - positions - providers