How to implement a database for the content of 3 online stores?

Question

CMS

Good day to all!
There are 3 online stores (on different engines) that display the same product. There is no synchronization with 1C, since 95% of the goods are on order.
It is necessary to update the assortment of goods on all sites by one content manager. There is an idea to create a database with an interface for the content manager, with the ability to export and further import content to sites.
How do you like this idea? And are there ready-made solutions?
PHPMyAdmin do not offer)

Answer 1

option by the database:
a product label (self-made) and three triggers (according to the number of stores) on insert and three on update.
Then, when inserting or editing data in it, mysql will automatically perform the operations described in the triggers.
About phpmyadmin in vain you are there, it is just the same and it is convenient to use it to fill that "alpha table", as well as to create triggers.

Answer 2

You can create a service elementary site / data management system or use one existing site as a data source and synchronize the data using the scheduler (cron).
I think it's better to create a separate mini-site (without front-end, purely admin panel) for the content manager, when editing the content or status of the product, queries were made to the store database.
It all depends on what systems the sites work on and the structures of their databases.
I have not yet seen ready-made solutions, but I have not searched hard either.