FROM CACHE - en_header

SQL connection with Shopify

Niumar_Melone
New Member
6 0 0

 have a database in SQL server, is it possible to connect this database with shopify? to centralize and update the inventory from any of the two platforms. Is it possible to create a development?

Replies 11 (11)
Zameer
Shopify Staff
Shopify Staff
297 31 88

Hey Niumar,

Zameer here from the Shopify Developer Experience team.

It sounds like you're looking to store shop data such as inventory levels, in your own database. This is definitely possible through the use of our REST or GraphQL API. You can retrieve all the relevant information from the shop using your access token, and then write the data to your SQL server. 

To keep the information in sync, I would recommend subscribing to the relevant webhooks that you require. However, since webhook delivery is not always guaranteed, you should implement reconciliation jobs to periodically fetch data from Shopify as well.

 

Niumar_Melone
New Member
6 0 0

excellent information, now I have a client within my shopify partner that also needs this functionality and the same has the Pervasive SQL database, in the same way is this possible? Now is there an expert that could hire for this? thank you

Zameer
Shopify Staff
Shopify Staff
297 31 88

Hey Niumar,

I'm not familiar with Pervasive PSQL myself, however, I see no reason why it can't be used to store Shopify data that is retrieved from the Admin API.

If you're looking for an expert that can help you implement a solution, check out this link that let's you look through the full catalogue of official Shopify Experts.

Best of luck!

Niumar_Melone
New Member
6 0 0

thank you very much for your quick answers, sorry but I do not know much about shopify I have my shop for three months active with shopify, when you mention the Admin API, exactly what do you mean? I have to install something else in my store to start performing these tasks?

Zameer
Shopify Staff
Shopify Staff
297 31 88

The Admin API gives you access to a series of endpoints that you can use to retrieve a variety of data from a Shopify store. This includes info about products, orders, customers etc.

This guide walks you through the process of creating an app which has access to the API. If you're new to development, we recommend hiring a Shopify Expert to assist you in the process.

Niumar_Melone
New Member
6 0 0

thank you very much for your help, I will study and review everything you have told me, you have helped me a lot with all this, if I have any other questions I hope to contact you again for this post.

JeremyMTB
New Member
1 0 0
Hi Zameer,

Will this process automatically create new tables in a database when writing to SQL Server or do I need to have certain tables, conditions and relationships in place before I start writing?
anc_business
New Member
2 0 0

Hi Zameer;

 

We need the same. We are moving from Umbraco to Shopify. But we want to keep using MS SQL as database. So can you confirm that using your REST or GraphQL API,  we can synchronize our local MS SQL database with Shopify? Which membership plan should we sign up for, and is it extra charged per data request basis?

 

Thank you

ElijahStownton
Tourist
11 0 2

Hi! Yes, it is possible. For instance, using a third-party app, such as Skyvia. It is a web-based, no-coding solution, which allows you to easily connect SQL Server to Shopify (https://skyvia.com/data-integration/integrate-shopify-sql-server) You can schedule this process and update your data as frequently as you need

wrishav
New Member
1 0 0

Is there any way I can code using python or powersheell or terraform to connect to my sql server hosted in Azure VM. Please give me a quick answer.

Stam2
New Member
3 0 0

Hi...does anyone know of a developer in Greece.??