Edit History

1. yes, there are more tables
2. There is a Webservice API for importing from xml

Product:
* without combinations and discounts or special prices = 6 tables

* with combinations + 5 tables

* with special price + 4 tables

* with discount + 2 tables

etc.
https://devdocs.prestashop.com/1.7/webservice/

Whatever method you want to use, you need to study the documentation.

If you want to know which functions and relevant parameters to use, you will find the information in the folder. /classes/*.*
Need to know what you need to add a product to the script? Find the add () function. Do you need to modify the product? Look for the update () function.

For a programmer who controls Prestashop, it is better to use the Prestashop function.
If you put sql in the database and forget something, either the product will not work for you or the loading will be long.
For Webservice Api it is necessary to study ws parameters for classes.

A lot of beginning programmers or artists who can only use Ctrl + C and Ctrl + V return here with the questions "it doesn't work, I have my own module, what should I do etc ....."

I have been programming for Prestashop for 11 years and I don't know everything yet. With each new version of Prestashoo there are new features and old ones do not work, documentation for changes is minimal, it must be studied ....

1. yes, there are more tables
2. There is a Webservice API for importing from xml

Product:
* without combinations and discounts or special prices = 6 tables

* with combinations + 5 tables

* with special price + 4 tables

* with discount + 2 tables

etc.
https://devdocs.prestashop.com/1.7/webservice/

Whatever method you want to use, you need to study the documentation.

If you want to know which functions and relevant parameters to use, you will find the information in the folder. /classes/*.*
Need to know what you need to add a product to the script? Find the add () function. Do you need to modify the product? Look for the update () function.

For a programmer who controls Prestashop, it is better to use the Prestashop function.
If you put sql in the database and forget something, either the product will not work for you or the loading will be long.
For Webservice Api it is necessary to study ws parameters for classes.

1. yes, there are more tables
2. There is a Webservice API for importing from xml

Product:
* without combinations and discounts or special prices = 6 tables

* with combinations + 5 tables

* with special price + 4 tables

* with discount + 2 tables

etc.
https://devdocs.prestashop.com/1.7/webservice/

Whatever method you want to use, you need to study the documentation.

If you want to know which functions and relevant parameters to use, you will find the information in the folder. /classes/*.*
Need to know what you need to add a product to the script? Find the add () function. Do you need to modify the product? Look for the update () function.