Synchronization of 1C and Opencart price + balance in stock?

Question

Do it yourself

I need to find/write a plugin myself that will upload ONLY the Prices and the quantity of goods in stock (in the respective stores, and there are 2 of them) by UNIQUE ID to the online store on the latest version of Opencart.
Should I use OpenCart Exchange 1C?? Is there such functionality?
Never wrote under OpenCart. In extreme cases, it is possible to upload goods to Excel and synchronize with the site from there (in the morning and in the evening, for example). What do you say?
(The fact is that the Base in 1C is very specific (there are extra letters and numbers in the nomenclature that are necessary for the operation of the store, but they are not needed on the site)
In the end, I need that after the "Exchange with the site" in the Site database The fields for the quantity of goods in the corresponding warehouses and its price have changed.
By the way, the exchange is ONE-WAY (i.e. if a request is made on the site, the number does not decrease in 1C)
Perhaps there is a module for 1C itself, by setting up ftp access of which it is able to change columns in the database ??
Thank you.

Answer 1

I myself am a supporter of the REST API, so I used https://opencart-api.com , there is a legacy code, a few rules.
The main problem is storing the guid on the opencart side. On the elements of the product, the GUID from 1C was written to " scu
", with the rest the problem is due to the lack of such a field
its associated "black box".
Option "directly to SQL": cms1c.ru/opencart

Answer 2

here is a great processing www.opencart1c.ru/integracii-1c/1c-opencart-api, will solve all your problems

Answer 3

Great solution, I recommend https://opencartforum.com/files/file/2849-obmen-ex...