Synchronization and two-way exchange of the 1C store database with the MySQL database of the same online store?

Question

MySQL

There is a retail store where 1C 8 is used as a database, trade management 10.3

. It is planned to make an online store where goods from the same database should be available, with the possibility of buying them online, with a MySQL database.

How to synchronize the exchange of information in both directions? Those. if a person came to the store and physically bought a product there, information on this product, its quantity decreased by -1 in their 1C, how to get these changes on the server?

And, accordingly, vice versa, if the purchase occurred through the site.

I looked for information on the vastness of the network, for some reason almost everywhere infa 2008-2013. Perhaps it is still relevant? For example https://core.ac.uk/download/pdf/53080806.pdf. I did not find exhaustive manuals everywhere. Everywhere confusion. As I understand it, there are several ways in my task, I didn’t analyze it in detail:

1) Data exchange through the ODBC driver.
2) Universal XML data exchange.

But are they right for me? There are 60.000 products in the database. After all, I don’t need to upload the entire database to the site after buying 1 product, only update the position on it. Automate, set the frequency of synchronization or upon the fact of data changes in one of the parties.

Answer 1

It is better to look for more on the profile
. Although the information will be the same, only examples will be added.
One way or another is suitable, it is decided experimentally.
Processing is written for 1C and you try to work with MySQL from it. A lot of code will be in the description of what to unload and where to write the downloaded.