Hi. We are new to Shopify. We currently have a system using SQL DB for orders, inventory, invoicing, etc. We would like to integrate this to the Shopify store so that if we update the price or product quantity available in the current system it will be reflected also in the Shopify store and if there are items sold in the Shopify store, it will update the quantity in the inventory in the current system.
Question is: Do we need just one app that will serve as the middleman between Shopify API and the current system to pass on data both ways? Or are there more components that we will need to be able to integrate them?
Thank you very much in advance for your help.