Automatic entry of information from the site into the database of another

Question

Programming

Hello, suppose there are two identical online stores, you need to automatically update the price list on the first one, the same price list is updated on the other, how can this be done?
Thanks in advance.

Answer 1

Write a price parser that will check for changes via cron and update the information if it is found.

Answer 2

Depends on whether they are on the same server (or nearby) or not.
If not on one:
Make a “receiver” page on the second store, and when the data on the first one changes, send a POST request with new data (if your servers allow it, of course). The receiver page should check where the request came from (some kind of secret key, checking the ip address), its integrity - and then update its data.
If on one:
use the shared database or file at the given shared path.
Yes, in general there are many solutions, you would clarify the conditions.

Answer 3

For example, set up replication of the DBMS of the first store to the second one. But then the second one will be Read Only. Even better is to use one DBMS. Reads can also be distributed using replication.

Answer 4

I will clarify, there is no access to the server of the first online store