I need to sync orders to an external system. My idea was to do this through a webhook (orders paid). The problem is that either this webhook can error enough, the connection could fail, the data could be invalid and require a re-sent to the external system, the external system could be down etc.
To solve this I was thinking about querying all orders from Shopify that still needed to be processed, except that it seems I can't seem to keep track of this information in Shopify and retry or send whatever wasn't processed yet. My initial approach was to use metafields as this let me set a status to communicate errors and let the user set flag to retry sending to the external system i.e. when missing information has been added to the order in Shopify.
The GraphQL lets me fetch the information but not filter for it. I basically want to do "get all orders where metafield X does not exist or is true" but this seems to not be possible. What would be the recommended approach to do this? I've got the feeling I have to constantly sync the order information to an app and then send it from there, but this requires me to constantly be checking ALL orders in Shopify which doesn't seem very efficient.
