Yes, standard data formats would be nice to have. Until common standards emerge from widely used best practices we can simply translate between different data formats.
What’s not clear to me is how a replication protocol would work
Is it possible with the current OFN rest API to get the products that have been modified since some (last sync) timestamp? How to detect deletes? What is soft delete mentioned in the API docs?
Most of the time two systems connect they will already be almost in sync. It would be great to quickly cheaply detect that… Any ideas?
@wvengen afaics you do quite some sophisticated data synchronisation between the central product database and various foodsoft instances. Do you delete and reimport everything to catch deleted products? Are there also (two-way-sync) changes uploaded from the instance to the central database?