SQL DATABASE

Stam2
New Member
3 0 0

What is the best way to connect a physical retail stores SQL database to Shopify.

Want to send SQL data like Product features, prices, inventory levels, (from SQL to SHOPIFY)

Want to send SHOPIFY data like Customer info, Orders, etc. (from SHOPIFY to SQL)

and can this be setup to work instantaneously.

???

Replies 3 (3)
channelup
Shopify Partner
522 25 120

Hi

If on premises rather than cloud based you would need to develop a native app and connect the data with Shopify API: https://shopify.dev/api/admin

If the SQL database is cloud based I'm guessing it must be used by some sort of software to access it. You need to check if that software has any integration possibilities via API etc which could then be used to link data to Shopify.

Regards

Tom

Bundleup - bundle your products and unbundle your orders.
Channelup is a product data management solution helping Shopify stores automate their processes.
If you require custom development or would like to test out our features contact me at tom@channelup.io
JassyKel
New Member
3 0 0

Preliminary requirements for joining the database?

annastoll
New Member
5 0 0

@JassyKel wrote:

Preliminary requirements for joining the database?


The database must first be disconnected. Attempting to join a database that has not been disconnected will cause an error. For more information, see Disconnecting a database on the postgresql client. When entering a database, all data files (MDF and LDF files) must be available. If any data file has a different path than the path it had when first created or last merged, you must specify the current approach to the file. The operation will end with an error if the MDF and LDF files are in different directories when joining the database and one of the paths contains \\?\ GlobalRoot.