I had a conversation with a vendor, he would like to link his database with mine. He asked me for API integration and asked for IP address and location details for the development and production server.
Can someone help me with finding these details and is it possible to link two databases? How can the vendor control it from his end and how to fulfil the orders and all under such a scenario.
They'll have to leverage Shopify's Private or Custom App and/or Shopify Webhooks to integrate with Shopify backend. As Shopify is a SaaS platform, there is no way to control or directly connect to the Shopify Backend. More info here - https://help.shopify.com/en/manual/apps/app-types and here - https://help.shopify.com/en/manual/sell-online/notifications/webhooks