We're finding syncing can be quite a task because we need to fetch all records with large joins on the database to see what's changed. Without webhooks, or creating a module the api requires a fetch of all products to determine if an update's needed.
If all objects (orders, products, attributes, attribute values, etc.) would have a type of checksum or hash to check against, we could save a huge amount of database load by only fetching the checksum and the entity id via the api, and comparing it to the last sync.
We're finding syncing can be quite a task because we need to fetch all records with large joins on the database to see what's changed. Without webhooks, or creating a module the api requires a fetch of all products to determine if an update's needed.
If all objects (orders, products, attributes, attribute values, etc.) would have a type of checksum or hash to check against, we could save a huge amount of database load by only fetching the checksum and the entity id via the api, and comparing it to the last sync.