I'm looking for a way to automate new orders to be exported to a SQL program, which we're using as the main database for our company. We're using Zapier, but are experiencing a lot of problems with the exported information, and are looking for an alternative option. Ideally we'd like to be able to export and format a lot of different information from shopify, process it in the SQL program and then upload it and have it automatically update the information on shopify.
Is there an app that is capable of doing this or should we be looking at building an API for this?
I don't know offhand of any integration that can do this, my approach would be to probably use Google Cloud Functions to get the relevant data from the Shopify API (whether using REST or GraphQL) and then link that with Google Cloud SQL which I believe has a MySQL integration. And then after you've done whatever processing on your end, do everything in reverse so that you perform writes back to the Shopify API.